Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedPlease add a complete ERD, DO NOT HAND DRAWimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions