Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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_2

Step: 3

blur-text-image_3

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

Make It Complete A Guide Of Knowledge Advice And Tips For Internal Audit And Compliance

Authors: Mónica Ramírez Chimal

1st Edition

6202304456, 978-6202304450

More Books

Students also viewed these Accounting questions

Question

Understand the different approaches to job design. page 167

Answered: 1 week ago