The purpose of this assignment is to make an attempt to use Normalization to con
ID: 3543168 • Letter: T
Question
The purpose of this assignment is to make an attempt to use Normalization to construct a set of well-behaved tables for a specific database application. Create your assignment in Word - show the initial table(s) you start with, and show the normalization process you used. It's best to start with one big table complete with errors and nasty repeating groups. Then apply the process systematically, removing the dependencies as required by each normal form.
____________________________________________
IMPORTANT NOTE**** The format that I am expecting for the normalization assignment should match Figure 3.28 below vv
Figure 3.28
Third normal form table list. The list is an easy way to fit dozens of tables on a page but does not show the relationships.
Customer(CustomerID, FirstName, LastName, Address, City, State, ZIPCode)
Sale(SaleID, SaleDate, CustomerID)
SaleItems(SaleID, ItemID, Quantity)
Item(ItemID, Description, ListPrice, QuantityOnHand)
____________________________________________
1. A friend of yours only buys items if she has coupons or rebates for the product. Coupons are OK, but the rebates are proving to be a problem. It often takes 4-6 weeks to get the rebate, and by then she forgets which product the rebate was for. Plus, some rebates are lost or possibly never paid. She needs a database to track the rebates
Explanation / Answer
where are the figures
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.