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 Num