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 assignmentBusiness 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 NF Example and instructions are inside the above document. Turn in a ERD in NFHint: 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 NFYour ERD must: Be in NF Must include a Pet table, a Visit table, a Procedure table, and a Owner table be careful! There are 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 onetoone, onetomany
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
