Question: Figure 4-38(b) shows a second alternative data model for the sheet-music-tracking problem. This alternative shows two variations on the Work entity. In the second variation,

Figure 4-38(b) shows a second alternative data model for the sheet-music-tracking problem. This alternative shows two variations on the Work entity. In the second variation, an attribute named Work ID has been added to Work_Version3. This attribute is a unique identifier for the work; the DBMS will assign a unique value to Work ID when a new row is added to the Work table.
a. Select identifiers for Choir Member, Work_Version2, Work_Version3, and Copy Assignment. Justify your selection.
b. Does this design eliminate the potential for data integrity problems that occur in the spreadsheet? Why or why not?
c. Design a database for the data model that uses Work_Version2. Specify key and foreign key columns.
d. Design a database for the data models that uses Work_Version3. Specify key and foreign key columns.
e. Is the design with Work_Version2 better than the design for Work_Version3? Why or why not?

Step by Step Solution

★★★★★

3.41 Rating (182 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Choir Member Last Name First Name could be a composite primary key Email could be a primary key Wo... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

642-C-S-I-S (619).docx

120 KBs Word File

Students Have Also Explored These Related Information systems Questions!

Figure 4-38(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...

Create a local conceptual data model for the Branch user views of Dream Home documented in Appendix A. Compare your ER diagram with Figure 13.8 and justify any differences found.

In Example 30.8, we created a XML Query Data Model for the XML document of Figure 30.22(a). Now create an XML Query Data Model for the corresponding XML Schema of Figure 30.22(b).

RESEARCH PROJECT TEMPLATE - MSLM 610 (3500-4000 words) Introduction (approximately 800 words) Discuss the Introduction here with the following in mind: Summarize the current state of knowledge...

\u0003 The Effects of Some Risk Factors in the Supply Chains Performance: A Case of Study L. Avelar-Sosa*1, J.L. Garca-Alcaraz2 and J.P. Castrelln-Torres3 1, 2 Department of Industrial Engineering...

Demand and Supply Discussion Question: Applications-Ubereconomics Please read the article below and respond to the follow-up question: Why Uber Is an Economist's Dream Does 'surge pricing'...

Demand and Supply Discussion Question: Applications-Ubereconomics Please read the article below and respond to the follow-up question: Using Big Data to Estimate Consumer Surplus: The Case of Uber...

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

Help with writing a short analytical summary of 150-200 words on each of the 2 articles below. Article 1: Exploring community-based options for reducing youth crime. The BackTrack program was...

Due Sunday, 11/20: Problems from Zimmerman text: 2-11, 2-44, Case 2-3, 7-7, and 7-20 Chapter Two The Nature of Costs Chapter Outline A. Opportunity Costs 1. Characteristics of Opportunity Costs 2....

Consider the information in the following table A. What is the beta of this portfolio? B. What (specifically) would you do to bring this portfolio back to a target beta of1.10? a15 V19278 8511 39 911...

Consider a combined gas-steam power plant. Water for the steam cycle is heated in a well-insulated heat exchanger by the exhaust gases that enter at 800 K at a rate of 60 kg/s and leave at 400 K....

Brief Exercise 7-34 Degree of Operating Leverage Chillmax Company plans to sell 3,500 pairs of shoes at $60 each in the coming year. Unit variable cost is $21 (includes direct materials, direct...

The socially optimal price would be (A) P1 . (B) P2 . (C) P3 . (D) P4 . (E) none of the above.

As a class, compile your votes for the most beautiful buildings. Class members should now discuss why they liked the buildings they chose. Be as specific as possible about the terms you use to...

Practice learning new procedures for your smartphone (or laptop if you do not have a smartphone). Find a friend or classmate with a similar phone and find a software app that person uses that would...

Record your vote for the two most beautiful buildings.

The surgery center's building in downtown Charleston has an attached garage, but CPSC employees and patients use only about 50% of the garage's space. The CFO is under discussions to lease the...

Based on past 23 years, Westerfield Industrial Supply's common stock has yielded an arithmetic average rate of return of 10.5 percent. The geometric average return for the same period was 8.57...

exhibit9.9 Based on Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round time value factor and final answers to...