Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please work these 2 questions out and explain what you did and why? I would like to check over my work using a
Can you please work these 2 questions out and explain what you did and why? I would like to check over my work using a solid reference.
Page 1:
Page 2:
Homework Assignment #5 MSIS 3333 Remember to make a copy for yourself 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(DoglD, DogName, DogAge, OwnerlD) Foreign Key OwnerlD References Owner(OwnerlD) Null Allowed, On Delete Set Null Acceptable Shorthand (Use these shortcuts orFK OwnerlD REF Owner(OwnerlD) none at all) Dog(DogID, DogName, DogAge, OwnerlD) NA/NN, ODSN/ODR/ODC Adcress Saahe Zip 008 Primary Lang Onder PK Order ID Order Dato Credit Status FK2 Branch Nu PK Beanch Num Zo Type tem ID City Traning Hre Date Skil Name Salary FK1 Branch Num Homework Assignment #5 MSIS 3333 Remember to make a copy for yourself 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(DoglD, DogName, DogAge, OwnerlD) Foreign Key OwnerlD References Owner(OwnerlD) Null Allowed, On Delete Set Null Acceptable Shorthand (Use these shortcuts orFK OwnerlD REF Owner(OwnerlD) none at all) Dog(DogID, DogName, DogAge, OwnerlD) NA/NN, ODSN/ODR/ODC Adcress Saahe Zip 008 Primary Lang Onder PK Order ID Order Dato Credit Status FK2 Branch Nu PK Beanch Num Zo Type tem ID City Traning Hre Date Skil Name Salary FK1 Branch NumStep 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