Question: I have been given a normalisation exercise with all of these info with their respective data (i will be the leaving the data out as

I have been given a normalisation exercise with all of these info with their respective data (i will be the leaving the data out as it is unnecessary):

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 AccountDescription BankName DateAccountEstablished Staff#

(note: Staff# has no data) I have made a sale order table with:

SaleOrder# SaleOrderDate ApprovedByStaff# Customer#

and an inventory table with:

Inventory# InventoryDescription InventoryListPrice

and an employee table with:

StaffName StaffPositionName StaffPositionID StaffContactPhone StaffStartDate

and a customer table with:

Customer# CustomerName CustomerAddress CustomerSuburb CustomerState CustomerPostcode CustomerPhone CustomerContact

and a sale table with:

Invoice# Customer# ProcessedByStaff# QuantityOrdered SaleOrder# SaleOrderDate

and a Cash Receipt table with:

RemittanceAdvice# CashReceiptDate CashReceiptAmount CashAccount# Customer#

and a cash account table with:

CashAccount# AccountDescription BankName DateAccountEstablished

and an Employee Position table with:

StaffPositionID StaffName StaffPositionName

My first question is, what are the two or three many to many relationship tables that I can make ( what would they be called and what tables or data of the ones i listed at the start should be included in them?) and my second question is whether you think these 8 tables I have already done are good and what would you recommend I add/take out of certain tables, if not?

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 Finance Questions!

Q:

Describe the roles of ASIC, the AASB, the ASX and the FRC, and the relationships between these regulatory bodies.

Q:

I have been given a normalisation exercise with all of these info with their respective data (i will be the leaving the data out as its unncessary): SaleOrder# SaleOrderDate ApprovedByStaff#...

Q:

What is the difference between MouseListener and MouseAdapter? [3 marks] (b) Via suitable HTML, the compiled version of the following Java code is presented to the appletviewer application: import...

Q:

Pramod K. Sharma, the chief executive officer (CEO) of Neelkanth Drugs Pvt. Ltd. (NDPL), was pensive. It was January 2013, and he was flipping through the papers given to him by his head of...

Q:

Navigation in SAP Systems Introduction to Navigation in SAP solutions on the basis of SAP ERP Product SAP ERP 6.08 Global Bike Level Beginner Focus Navigation Authors Babett Koch Stefan Weidner...

Q:

I have a attached a copy of the data used to answer the question Prepare a 2007 classified balance sheet and multistep income statement. Use the account balances from the unadjusted trial balance and...

Q:

Please answer the following questions based on the case below i) what activities/plans/initiatives could potentially constitute a legal violation? (e.g., ad board, speaker program, research grant,...

Q:

1. On November 1, 2020, Jill Luckovich began Jill Luckovich Interior Design Co. with an initial investment of $6,725, and on November 30 her records showed the following (alphabetically arranged)...

Q:

6-7; 6-9; 6-12 . I need help with these finance questions. PROBLEM 6-1 Cash provided by operations (CPBO) differs from free cash flow for the following reasons: 1. Solution Legend = Value given in...

Q:

I need help with the following assignment: Final Project PART I. I'm attaching the final project rubric, but just the first part needs to be done (PART I). Every single critical element must be...

Q:

Year 0 1 2 3 4 5 EBIT Taxes NOPAT Plus: Depreciation Less: CAPEX Less: Net working capital needs (See Note 1) Plus: Salvage value of the fixed assets in year 5 Firm Free Cash Flow (FFCF) Net Fixed...

Q:

A 15 cm black disk is placed halfway between two black 3 m diameter disks which are 7 m apart with all disk surfaces parallel to each other. If the surroundings are 0 K, determine the temperature of...

Q:

A circulant of order n is the n à n matrix defined by C = circ (c1, c2,..., cn) The elements of each row of C are the same as those in the previous rows, but shifted one position to the right...

Q:

What three things must you deduct from advances, bonuses, and retroactive pay increases? ( P . 3 2 )

Q:

. Marin Co. owes $211,700 to Headland Inc. The debt is a 10-year, 11% note. Because Marin Co. is in financial trouble, Headland Inc. agrees to accept some land and cancel the entire debt. The...