Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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

Oracle Database 19c DBA By Examples Installation And Administration

Authors: Ravinder Gupta

1st Edition

B09FC7TQJ6, 979-8469226970

More Books

Students also viewed these Databases questions

Question

Show the properties and structure of allotropes of carbon.

Answered: 1 week ago