Reference no: EM132829656

200534 Accounting Information Systems - Western Sydney University

Assignment - Database normalisation exercise

Assignment 3A: Database normalisation exercise and Assignment 3B: Lab exercises are extensions of the theoretical and practical work undertaken in the unit, and will give you the opportunity to experience database application.

In Assignment 3A you will normalise a spreadsheet of data into tables in the third normal form in order to eliminate data anomalies.

Assignment details

Background

Good Fortune Restaurant Supplies (GFRS) is owned by Anna Vuong, a graduate of UWS. GFRS has grown rapidly and has found that managing its sales function is essential to providing excellent customer service and operating profitably. GFRS has asked you to design a database that will help it control its sale and cash collection operation. GFRS sells ingredients and supplies to several different restaurants, food and drink outlets, and a processed food factory. Donna Hay is the account manager who looks after all sale-related activities. Paul Murray is the creditor manager who is responsible for assessing and approving customer credit applications. Anna Vuong is the accounts receivable manager who is responsible for cash collection and accounting function. All orders from customers are processed by the account officer/manager, and approved by the credit officer/manager. The cash payments are received by the accounts receivable officer/manager. Sale orders from customers are confirmed with a printed customer purchase order signed by the customer's purchasing agent. Normally, GFRS delivers shortly after orders are received and approved. A partial delivery of a sale order to a customer is acceptable.

When a delivery/shipment to a customer is made, an invoice is prepared by one of the four account officers/manager and sent to the customer. A remittance advice is attached to the bottom of the invoice. Customers are required to tear off the remittance advice and sent it back with their payments. Anna has made an arrangement with each customer that a direct bank transfer is made by the customer per month to GFRS's bank account to cover all invoices issued for the previous month. This arrangement has reduced the chance of bad debt and internal control issues in relation to cash collection.

The business stores its sale and cash collection transactions on a worksheet. Anna claims that she has done her best to make sure the data on the worksheet is correct.

You will be required to normalise a spreadsheet of data into table in the third normal form for Good Fortune Restaurant Supplies. To do so, you will need to download and use the following documents

Once you have downloaded the spreadsheet, rename is to include your student number (i.e Data_normalisation_spreadsheet_12345678). Make sure you save the spreadsheet file as an Excel Macro-Enabled file so that the marking macro can function properly. All your work must be done and submitted using the spreadsheet file provided.

Attachment:- Accounting Information Systems.rar