Question: Please add a complete ERD, DO NOT HAND DRAW Figure 6.CP11 in Textbook Page 231 (ERD for Chapter 6 Conversion Problem 11 in Textbook Page
Please add a complete ERD, DO NOT HAND DRAW
Figure 6.CP11 in Textbook Page 231 (ERD for Chapter 6 Conversion Problem 11 in Textbook Page 230) is incomplete in that foreign keys are missing and there is a many-to-many relationship. Draw a complete ERD for it by adding foreign keys and converting the many-to-many relationship to an entity with one-to-many relationships. Be sure to designate the primary key of every entity and add all foreign keys. Family Volunteer Area FIGURE 6.CP11 ERD for Conversion Problem 11 VANA VAName VAControl ------ Coordinates------ FamNa HFamLastName 1 FamFirstName 1 FamLast Name 2 FamFirstName 2 FamHomePhone FamBusPhone FamEmad Fam Street FamCity Fam State Famzo Supports --Volunteers for -- -- -- Event BANA EventDesc EventEstes Event BegTime Volunteer Work EventEndTime EventRecur Period HO- - - Workson ---OWN EventExpDate WwDate EventNum Vols VWNotes EventDateNeeded WWHours EventDate Red VWLocation WWFirstName WWLastName VWatEntered Work Done Figure 6.CP11 in Textbook Page 231 (ERD for Chapter 6 Conversion Problem 11 in Textbook Page 230) is incomplete in that foreign keys are missing and there is a many-to-many relationship. Draw a complete ERD for it by adding foreign keys and converting the many-to-many relationship to an entity with one-to-many relationships. Be sure to designate the primary key of every entity and add all foreign keys. Family Volunteer Area FIGURE 6.CP11 ERD for Conversion Problem 11 VANA VAName VAControl ------ Coordinates------ FamNa HFamLastName 1 FamFirstName 1 FamLast Name 2 FamFirstName 2 FamHomePhone FamBusPhone FamEmad Fam Street FamCity Fam State Famzo Supports --Volunteers for -- -- -- Event BANA EventDesc EventEstes Event BegTime Volunteer Work EventEndTime EventRecur Period HO- - - Workson ---OWN EventExpDate WwDate EventNum Vols VWNotes EventDateNeeded WWHours EventDate Red VWLocation WWFirstName WWLastName VWatEntered Work Done
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
