Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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. Convert the previous question's ERD into a relational database. The result of conversion is a collection of "CREATE TABLE commands or simplified commands (as shown in Ch06_Examples)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

How To Build A Million Dollar Database

Authors: Michelle Bergquist

1st Edition

0615246842, 978-0615246840

More Books

Students also viewed these Databases questions