Question: Convert the ERD shown in Figure 2 into a table design. This problem was adapted from problem 11 in Chapter 6. VolunteerArea Family VANO VAName

Convert the ERD shown in Figure 2 into a table

Convert the ERD shown in Figure 2 into a table design. This problem was adapted from problem 11 in Chapter 6.

VolunteerArea Family VANO VAName VAControl Coordinates FamNo OHFamLastName1 FamFirstName1 FamLastName2 FamFirstName2 FamHome Phone FamBusPhone FamEmail FamStreet FamCity FamState FamZip Supports VolunteersFor Event VolunteerWork EventNo EventDesc EventEstHrs EventBeg Time EventEnd Time EventRecurPeriod HO EventExpDate EventNum Vols EventDateNeeded EventDateReq WorksOn WorkDone VWNO VWDate VWNotes VWHours VWLocation VWFirstName VWLastName VWDate Entered Figure 2: ERD for Problem 2 VolunteerArea Family VANO VAName VAControl Coordinates FamNo OHFamLastName1 FamFirstName1 FamLastName2 FamFirstName2 FamHome Phone FamBusPhone FamEmail FamStreet FamCity FamState FamZip Supports VolunteersFor Event VolunteerWork EventNo EventDesc EventEstHrs EventBeg Time EventEnd Time EventRecurPeriod HO EventExpDate EventNum Vols EventDateNeeded EventDateReq WorksOn WorkDone VWNO VWDate VWNotes VWHours VWLocation VWFirstName VWLastName VWDate Entered Figure 2: ERD for Problem 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!