Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. 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 3Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started