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)
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.
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:
[url removed, login to view] all needed tables and attributes based on your ER diagram from part 1 above.
[url removed, login to view] all primary key attributes and foreign key attributes using CONSTRAINT clauses.
[url removed, login to view] 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
38 freelancers are bidding on average $158 for this job
Having 3+ years of Experience in Oracle MYSQL database. Have vast knowledge of Database architecture, performance tuning. Have completed these type of projects previously, Please have a look on my profile.
Hello I am Software Engineer and Expert in database Analysis and Design so you can hire me for this Project Thanks I will Wait For your Quick Response
I am currently responsible for designing enterprise models including logical and physical database designs and would be more than happy to complete this task for you