Answered step by step
Verified Expert Solution
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.
Discuss the data redundancy and data anomalies exhibited by the file structure. pts
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. pts
You may add more attributes to your new tables, as appropriate.
Orders
Order
ID
Order
Date
PartID Partdesc QtySold ListPrice SoldPrice CusId CusLN
AX Iron $ Wang
BT Gas Grill $ Smith
BZ Washer $ Smith
CB Bike $ Abadi
CX Blender $ Kumar
AZ Dartboard $ Harking
BA Basketball $ Harking
CX Blender $ Pearson
BT Gas Grill $ Pearson
CZ Treadmill $ Wang
SoldPrice is the price after a discount.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started