Question
Please normalize to 1NF: StoreNo, RcptNo->Date, EmpNo, EmpName StoreNo, RcptNo, ItemNo->Qty, Price ItemNo->ItemName EmpNo->EmpName StoreNo->Taxrate, Address, State, Zip FlatFile [StoreNo, RcptNo, Date, EmpNo, EmpName, ItemNo
Please normalize to 1NF:
StoreNo, RcptNo->Date, EmpNo, EmpName
StoreNo, RcptNo, ItemNo->Qty, Price
ItemNo->ItemName
EmpNo->EmpName
StoreNo->Taxrate, Address, State, Zip
FlatFile [StoreNo, RcptNo, Date, EmpNo, EmpName, ItemNo1, Qty1, Price1, ItemName1 ItemNon, Qtyn, Pricen, ItemNamen, Taxrate, Address, State, Zip]
This problem describes a typical grocery checkout situation. We own multiple stores, and we generate receipt numbers that are unique only within the store. Receipts have dates. Every receipt is generated by a store employee that has an employee number and a name. The tax rate, address, state and zip code are found on the receipt. On the receipt detail line, we have the item number, item name, qty and price. The item name is identified by the item number.
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