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
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