Question: * This is an individual assignment * Business Description: A pet is identified by the Pet ID . A Pet can be one Pet Type

*This is an individual assignment*Business Description: A pet is identified by the Pet ID. A Pet can be one Pet Type Only but there are from zero to many Pets of a particular Pet Type. A Pet has one and only one owner, but an owner has from one to many pets. Add an Owner ID to the Owner Table. A pet has from one to many visits (ADD A VISIT ID to a Visit Table that Includes the Visit Date and whatever foreign keys are necessary). During a visit, there are one to many procedures and each procedure is represented in one to many visits. The procedure table will need to have a procedure ID and the Procedure description.Task: Normalize to 3NF. Example and instructions are inside the above document. Turn in a ERD in 3NF.Hint: use an iterative process - identify the dependencies and work with the ERD to eliminate many to many relationships and transitive dependencies. Make sure every relationship is connected with a foreign key.Turn in:Submit a screenshot or image of the ERD in 3NF.Your ERD must: Be in 3NF Must include a Pet table, a Visit table, a Procedure table, and a Owner table (be careful! There are 2 more tables that I have not mentioned that you must identify and include) show the columns in each table For any primary keys and foreign keys you must identify these with PK or FK Show the relationship lines and the correct end point based on the relationship (one-to-one, one-to-many)
* This is an individual assignment * Business

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!