Question: A three-table database design for the data in the spreadsheet in Figure 5-17 is as follows: Choir Member (Last Name, First Name, Email, Phone, Part)

A three-table database design for the data in the spreadsheet in Figure 5-17 is as follows:
Choir Member (Last Name, First Name, Email, Phone, Part)
Musical Work (Name of Work, Composer)
Check Out (Last Name, First Name, Name of Work, Part, Copy Number, Date In, Date Out)
a. Redraw the data in Figure 5-17into this three-table format.
b. Identify which columns are primary keys for each of these tables.
c. The foreign keys are already in place; identify which columns are foreign keys and which relationships they represent.
d. Does this design eliminate the potential for data integrity problems that occur in the spreadsheet? Why or why not.

Step by Step Solution

★★★★★

3.31 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Choir Member Last Name First Name Email Phone Part Ashley Jane JAsomewherecom 7035551234 Soprano Davidson Kaye KDsomewherecom 7035552236 Soprano Chi... 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)

551-C-S-I-S (410).docx

120 KBs Word File

Students Have Also Explored These Related Information systems Questions!

A three table database design for the data in the spreadsheet in Figure 5-15 is as follows: ChoirMember (LastName, FirstName, Email, Phone, Part) MusicalWork (NameOfWork, Composer) CheckOut...

Produce an object-oriented database design for the DreamHome case study documented in Appendix A. State any assumptions necessary to support your design.

Map the object-oriented database design for the DreamHome case study produced in Exercise 27.25 to the ODMG ODL.

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

CIT-180 Semester Project Before you start the project For this project you will be developing a Microsoft SQL Server database for the following fictitious case study. The case study describes the...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

1 McKraklin AEROSPACE (A) "First you figure out what's inevitable. Then you find a way to take advantage of it." Russell Ackoj INTRODUCTION Dave Costner, Director of Information Systems (IS), shook...

8-1 Discussion: Writing Your Resume Profile For this discussion, you will be writing a professional profile. You will need to find a job posting that interests you and then write the professional...

a. Compute the mean of the following sample values: 1.3, 7.0, 3.6, 4.1, 5.0. b. Show that o(x 2 x) 5 0.

Make a dotplot for the data in Problem 13 regarding the recurrence of tumors after chemotherapy. Compare the dotplot to the histogram for Problem 13.

Suppose that aluminum is a key production input in the production of bicycles. If the price of aluminum falls, and all other variables are held constant, we expect (A) the demand for aluminum to...

Do you think that the amount the BDC spends on promotional items is too much, not enough, or just right?

1. Where are the main markets for Locarnas systems? 2. What problem does Locarna solve? 3. How important are systems such as Locarnas? 4. How have recent technological changes affected or enabled...

Network Effects, Increasing Returns, and Lock In 1. How do the challenges faced by Stantec differ from those faced by other industries? 2. What are the implications of this case for companies that...

Samantha Green owns and operates Twigs Tree Trimming Service. Recall from Chapter 3 that Samantha has a degree from a forestry program, and recently opened her business in Winnipeg. Her business...

You are given the following information for Huntington Power Co. Assume the companys tax rate is 34 percent. Debt: 5,000 6 percent coupon bonds outstanding, $1,000 par value, 20 years to maturity,...

Answer. P(si) for i = 1, 2, 3 as given below: X1(t) P(s1 ) = 3/10 S 0 s1 $2 X2(t) $3 P($2) = 1/5 0 2 -1 X3(t) P($3) = 1/2 2 0 Let the random variable X1 be defined by sampling the random process X(t)...

Motor Vehicles Body Shops contracts to buy from Paint Supply & Equipment Headquarters, Inc., twenty-four spray paint guns at $30 each to be delivered by October 1. Paint Supply knows that Motor...