x
Info
x
Warning
x
Danger
 / 
 / 
 / 
1.Analyze the spreadsheet shown in Figure 5-15 and list all

Question : 1.Analyze the spreadsheet shown in Figure 5-15 and list all : 1585158

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

2.The following two tables could be used to store the data in Figure 5-15 in a database.

a.Redraw the data in Figure 5-15 into this two-table format.

b.Select primary keys for the ChoirMember and MusicalWork tables.

c.The two tables are not integrated; they do not show who has checked out which music. Add foreign key columns to one of the tables to integrate the data.

d.This two-table design does not eliminate the potential for data integrity problems that occur in the spreadsheet. Explain why not.

Solution
5 (1 Ratings )

Solved
Management Information Systems 2 Days Ago 30 Views
This Question has Been Answered!

Related Answers
Unlimited Access Free
Explore More than 2 Million+
  • Textbook Solutions
  • Flashcards
  • Homework Answers
  • Documents
Signup for Instant Access!
Ask an Expert
Our Experts can answer your tough homework and study questions
3885 Management Information Systems Questions Answered!
Post a Question