Question: 1 . Analyze the spreadsheet shown in Figure 4 - 3 0 and list all of the problems that occur when trying to track the

1. Analyze the spreadsheet shown in Figure 4-30 and list all of the problems that occur when trying to track the assignment of sheet music using this spreadsheet. Also describe a report the choir master might like to see from this data.
2. Figure 4-31(a) shows a two-table data model for the sheet-music-tracking problem.
a. Select primary keys for the ChoirMember and Work tables. Justify your selection.
b. This design does not eliminate the potential for data integrity problems that occur in the spreadsheet. Explain why not.
c. Design a database for this data model. Specify primary key and foreign key columns.

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!

Q:

In fact, a spreadsheet is ill-suited for this application. A database would be a far better tool, and situations like this are obvious candidates for innovation. 1. Analyze the spreadsheet shown in...

Q:

Analyze the spreadsheet shown in Figure 5-17and list all of the problems that occur when trying to track the assignment of sheet music using this spreadsheet.

Q:

Analyze the spreadsheet shown in Figure 4-37 and list all of the problems that occur when trying to track the assignment of sheet music using this spreadsheet.

Q:

Analyze the spreadsheet shown in Figure 4-37 and list all of the problems that occur when trying to track the assignment of sheet music using this spreadsheet.

Q:

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

Q:

NASA/SP-2011-3422 Version 1.0 November 2011 NASA Risk Management Handbook NASA/SP-2011-3422 Version 1.0 NASA Risk Management Handbook National Aeronautics and Space Administration NASA Headquarters...

Q:

PROJECT DESCRIPTION Patrick Fitzgerald is the director of Career Development at Finn Technical Institute, a local community college. The Institute offers workshops on resume writing, interview...

Q:

Liting Wang Shelly Cashman Excel 2013 Chapter 10: SAM Project 1a Submission #2 Score is 79 out of 100 1. Go to the Event Schedule - 2018 worksheet and use the password J@Nuary18 to unprotect the...

Q:

I have this Accounts assignment that needs to be done. Need help on that Statement of individual work Individual work required This project is designed to assure that all students, individually, have...

Q:

Math\t107-6381\t-\tQuiz\t#4\t-\tSchultz\t-\tDue\tFebruary\t21,\t2016\t-\tpage\t1\tof 3 Follow\tthese\tdirections\tcarefully. This\tquiz\tis\tdue\tby\t11:59\tEastern\ttime\ton\tFebruary\t21,\t2016. o...

Q:

As a manager of a middle-size Polish airport, you identified the need for increasing commercial revenues. Develop a possible strategy to do this. Refer in your answer in particular (but not only) to...

Q:

Greenworks, Inc. mass-produces goods in three processes. In the first process, direct materials are added 20% of the way through the process, conversion costs are incurred evenly throughout the...

Q:

10. If a= = -3 AC Exp , find the possible values of s that a 7 units, leaving your answer in (i.e. square root form in this case) if necessar

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

3. Is the length of the probationary period in the last chance agreement reasonable? If not, does this period make the last chance agreement unreasonable? On March 27, 1998, the Company, the Union,...

Q:

5. You be the arbitrator. Should the Grievance be sustained or denied? Explain your reasoning. Background On March 30, 2006, David Gates was arrested and charged with felony Conspiracy to Distribute...

Q:

6. You be the arbitrator. You decide and give your reasoning. On March 27, 1998, the Company, the Union, and Mr. Danny Webb, the Grievant, entered into and signed the following Agreement: Without...