Question: Please help. I have no idea what to do here. 4. Figure 4-32(c) shows a third alternative data model for the sheet-music-tracking problem. In this

 Please help. I have no idea what to do here. 4.Figure 4-32(c) shows a third alternative data model for the sheet-music-tracking problem.

Please help. I have no idea what to do here.

4. Figure 4-32(c) shows a third alternative data model for the sheet-music-tracking problem. In this data model, use either Work_Version2 or Work_Version3, whichever you think is better. a. Select primary keys for each table in your data model. Justify your selection. b. Summarize the differences between this data model and that in Figure 4-32(b). Which data model is better? Why? c. Design a database for this data model. Specify key and foreign key columns. 5. Which of the three data models is the best? Justify your answer. Figure 4-32 Three Data Model Alternatives Choir Member LastName First Name Email Phone Part Work NameOfWork Composer Part CopyNumber (a) Data Model Alternative 1 Choir Member LastName First Name Email Phone Part Work_Version2 NameOfWork Composer Work Version 3 WorkID NameOfWork Composer or Copy Assignment Part CopyNumber (b) Data Model Alternative 2 (Either Work_Version2 or Work_Version) Copy Choir Member LastName First Name Email Phone Part CopyNumber Part Assignment DateOut Dateln (c) Data Model Alternative 3

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 Databases Questions!