Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write out the set of relations and foreign key constraints for this ERD Diagram. Write your answers in the same format as my example, except
Write out the set of relations and foreign key constraints for this ERD Diagram. Write your answers in the same format as my example, except you should underline primary keys and put dotted lines under foreign keys (or both as needed) Example: Dog(Dogid, RegName RegAge, weerlo) Foreign Key Qwoerd References Owner(QwerD Null Allowed, On Delete Set Null Acceptable Shorthand: (Use these shortcuts or none at all) Dog(DogID, DogName, DogAge, Owner) FK OwnerID REF Owner(OwnerID) NA/NN, ODSN/ODR/ODC Account Customer PK PK Account CustID Address Balance Last Pet Date Last Pm Amt Onder Order_1 PK PK.FK1 Inventory 1 PK FK2 Order Order Date Credit Status FK1 Custo FK2 Branch_Num Hem ID 10 Branch PK Branch Num PK Description Color Inventory Inventory ID PK Pattern FK2 Branch Num FK1 Item_ID Employee Employee ID PK Ski P Training KFKI SKLID PKF Employee 1 Telephone Hire Date PK SKILD Skie Name Date Leamed FK1 Branch_Num
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started