ER Diagram SQL
$10-30 USD
Paid on delivery
you will need to develop a database design for the PetDoctor case study described in the attached document. Your solution deliverables for this are an ER diagram in pdf format (Part 1) and a logical database design in pdf format (Part 2)
Part 1
Your ER diagram should be normalized to 3NF and show all entities, relationships, relationship labels and arrowheads, multiplicity notation, non-key attributes, PKs, and FKs.
.
Part 2
In the development of your logical database design, your submitted solution to Part 2 should consist of SQL "create" statements for each entity in your ER solution to Part 1.
To earn full points, your SQL "create" statements should:
[login to view URL] all needed tables and attributes based on your ER diagram from part 1 above.
[login to view URL] all primary key attributes and foreign key attributes using CONSTRAINT clauses.
[login to view URL] database integrity, for example, required attributes, attribute domain consistency, entity integrity, multiplicity, and referential integrity using ON UPDATE and ON DELETE clauses.
The "Supplemental Material" attached document should be reviewed before starting work on this project
I have already completed both parts to this assignment, but received this message as feedback...."You still have some errors in your ER diagram such as missing relationships and incorrect multiplicity. I suggest you review the problem requirements and confirm that you have correctly addressed all the requirements in your ER diagram. "
I just need help figuring out what I am doing wrong in the ER diagram.
Project ID: #8252550
About the project
24 freelancers are bidding on average $38 for this job
Dear Sir, Please provide me your scenario. I can do the ERD fixing and Part 2. I got 10+ years of experience. Thanks
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in More
Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here More
I am database expert having experience of 2 years.I will do all the modification to your ER diagram as per your requirement and deliver it to you.
Dear Sir, As we are masters of the field (Please see my profile) we can handle your project nicely... Please allow us to complete your project (Database) for a minimum initial milestone payment and you can pay rest ba More
greetings, i expert in ERD, and database design, i'm working in huge ERP programs, so it's easy to me to do this assignment. Thank you Ehab Ali
As you can see my profile i am experienced software engineer in .net using SQL. I can help you in this assignment because I teach database system in university as well. Hire me to get full points in your assignment. Th More
For example confused relationship essence "Pet" and "Clinic", as well presence of the field "Pet_no" in essence "petOwner"...
Hi there I can make this er diagram for you l I am very good at the databases and it's concepts. I have read your requirements. kindly contact as soon as possible. Thankyou!
I have experience in big projects for some companies in South Europe. Task can be done quickly and efficiently. The documentation you provide is very good.
We are a team and we are really invested in the research and development of databases. We have recently completed database relevant projects and we are more enthusiast to do more. Thank You