Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Financial Accounting

Authors: Walter T. Harrison, Charles T. Horngren

6th Edition

0131499459, 978-0131499454

More Books

Students also viewed these Accounting questions