Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following file structure of a database. ( 1 ) Discuss the data redundancy and data anomalies exhibited by the file structure. 5 pts

Consider the following file structure of a database.
(1) Discuss the data redundancy and data anomalies exhibited by the file structure. 5pts
(2) How many tables would you use to eliminate the problems? Draw the table structures you would
recommend. In addition, show the example records in new tables. 20pts
You may add more attributes to your new tables, as appropriate.
Orders
Order_
ID
Order_
Date
PartID Part_desc QtySold ListPrice SoldPrice1 CusId CusLN
124899/23/22 AX12 Iron 1115.00 $15.00101 Wang
124914/23/22 BT04 Gas Grill 1150.00 $139.99201 Smith
124914/23/22 BZ66 Washer 11000.00 $989.99201 Smith
124945/12/22 CB03 Bike 4300.00 $279.99301 Abadi
124955/15/22 CX11 Blender 222.95 $22.95401 Kumar
1249812/6/22 AZ52 Dartboard 214.00 $12.95501 Harking
1249812/6/22 BA74 Basketball 426.50 $24.95501 Harking
125001/6/23 CX11 Blender 122.95 $19.95601 Pearson
125001/6/23 BT04 Gas Grill 1150.00 $129.99601 Pearson
125043/6/23 CZ81 Treadmill 2450.00 $325.99101 Wang
1 SoldPrice is the price after a discount.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual Basic6 Database Programming

Authors: John W. Fronckowiak, David J. Helda

1st Edition

0764532545, 978-0764532542

More Books

Students also viewed these Databases questions