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.
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
Get step-by-step solutions from verified subject matter experts
