Question: The table provides a spreadsheet with sample data for the Invoice table. Is there any redundant data in that table? Figure out a way to

The table provides a spreadsheet with sample data for the Invoice table. Is there any redundant data in that table? Figure out a way to eliminate the redundant data by changing the design of the database. (Hint: Add another entity that would contain the redundant data and link that entity to the Invoice entity through a relationship). Make that change on the ER diagram.

The table provides a spreadsheet with sample data for the Invoice table.

Invoice invoiceNum date itemNumber item amount contractNum 2361 2362 2371 2372 2373 2374 2381 2382 2383 2384 2391 2392 2393 2394 2401 2402 2403 04/21/2018 07/07/2018 06/09/2018 07/29/2018 08/23/2018 07/24/2018 06/06/2018 01/03/2018 07/05/2018 07/08/2018 06/09/2018 03/12/2018 03/11/2018 03/27/2018 04/10/2018 08/13/2018 08/26/2018 1244 Schematic Plan 1278 Planting & Materials Plan 1244 Schematic Plan 1791 Community Meetings&Permitting $%2,500.00 3069 1245 Planting Plan 1388 Lighting Plans 1791 Community Meetings & Permitting $3,500.00 3070 1244 Schematic Plan 2400 Construction Documents 3011 Construction Observation 1244 Schematic Plan 1791 Community Meetings & Permitting $4,500.00 3071 2400 Construction Documents 3011 Construction Admin. & Observation $10,000.00 3071 1244 Schematic Plan 2400 Construction Documents 3011 Construction Admin. &Observation $15,000.00 3072 1,500.00 3068 $3,000.00 3068 3,750.00 3069 7,000.00 3069 $2,500.00 3069 $8,500.00 3070 $14,000.00 3070 $9,000.00 3070 $8,500.00 3071 14,000.00 3071 $12,000.00 3072 $30,000.00 3072

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!