Question: Here's the raw data name of each unnormalized table provided; Saleorder# SaleOrderDate ApprovedByStaff# StaffName StaffPositionName StaffPositionID StaffContactPhone StaffStartDate Customer# CustomerName CustomerAddress CustomerSuburb CustomerState CustomerPostcode CustomerPhone

Here's the raw data name of each unnormalized table provided;

Saleorder#

SaleOrderDate

ApprovedByStaff#

StaffName

StaffPositionName

StaffPositionID

StaffContactPhone

StaffStartDate Customer#

CustomerName

CustomerAddress

CustomerSuburb

CustomerState

CustomerPostcode

CustomerPhone

CustomerContact

Inventory#

InventoryDescription

InventoryListPrice

SaleOrderPrice

QuantityOrdered

Invoice#

ProcessedByStaff#

StaffName

StaffPositionName

StaffPositionID

StaffContactPhone

StaffStartDate

ShippingDate

InvoicePrice

QuantitySold

ReceivedByStaff#

StaffName

RemittanceAdvice#

StaffPositionName

StaffPositionID

StaffContactPhone

StaffStartDate

CashAccount#

CashReceiptDate

CashReceiptAmount

AmountDescription

BankName

DateAccountEstablished

Normalize the above data into 10 tables s in third normal form (3NF) including the below tables:

1: SaleOrder

2:Inventory

3:Employee

4:Customer

5:Sale

6:CashReceipt

7:CashAccount

8:EmployeePosition

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!