Create and populate a database in its 3rd normal form

Reference no: EM131415123

Overview of project

Project I is an assignment for system development in a 4GL environment. Even though as an accountant we are not programmers or IT professionals, we should have some knowledge of how a system is built before we start using or auditing them.

Computer applications are usually made out of two components. The part seen by the user, such as menus, are called the front end. The part which does the number crunching etc. is called the back end. In modern computing the second part is usually handled by a DBMS.

This assignment is aimed to help you understand how data is stored and processed by a DBMS in the background.
If we understand what goes on behind the scenes, the audit will be much easier.

Using MS Access (a 4GL tool), in this project we will develop a system to create invoices and other reports a business might need.

PROBLEM
Assume that you are employed as an accountant by an online appliance wholesaler. On your first day to work, the owner complains about the billing and the difficulty he has in keeping up with invoices, receivables etc. and asks you to improve the situation.

You notice that the current orders recorded on an Excel spread sheet and invoices are manually prepared by using MS Word. A copy of a recent report on receivables is given in a pdf file (see consumerinvoices.pdf). A section of the spread sheet data is posted as "invoicedata.xls" (download this spread sheet onto your PC to work on it).

In your conversations with the accounting staff, you obtain the following information:

- After orders are taken, ordered items are combined and shipped together using FedEx and UPS to retail customers in different states.

- The shipping costs of each company is determined by the weight and the distance.

- Shipping fees are collected by the wholesaler and paid to the shipping company periodically. The owner explains the difficulty she faces in determining these payments. The shipping fees are $0.19 and $0.23 per pound/mile for FedEx and UPS respectively.

- Recommended Solution: You realize the existing system can easily be converted to a DBMS application and recommend the employment of MS Access as database management system.

Required:

Using the Excel data, create and populate a database in its 3rd Normal Form. Based on this data prepare an MS Access report as shown in the PDF file.

Attachment:- Invoices.rar

Reference no: EM131415123

Questions Cloud

Which package should you recommend to jacobs : Which package should you recommend to Jacobs? Why?- Which of these strategies do you think will require less input from employees in terms of their reactions? Why?

Strands of the ishikawa diagram : Review the scenario below and create an Ishikawa diagram to analyse the problem presented. You should identify as many possible causes of the problem as possible and categorise them on different 'strands' of the Ishikawa diagram.

Explain the rise of criminological conflict theory : Sykes pointed to what three factors of special importance that sought to explain the rise of criminological conflict theory.

Discuss international performance management : 1. Discuss international performance management and compare it to domestic performance management. Use specific examples to illustrate similarities and differences.

Create and populate a database in its 3rd normal form : Even though as an accountant we are not programmers or IT professionals, we should have some knowledge of how a system is built before we start using or auditing them.

Create a figure or table from a few selected variables : Review the Learning Resources for this week related to frequency distributions and graphic displays of data.Using the SPSS software, open the General Social Survey dataset found in this week's Learning Resources.

Compare the advantages and disadvantages of plea bargaining : Compare and contrast the advantages and disadvantages of plea bargaining. Describe how plea bargaining reflects or thwarts the crime control and due process models of criminal justice.

Google apps files can be shared in which of following ways : .According to the blog "ExcelCharts.com" the chart below on the bottom is an improvement over the original chart from Time Magazine (below on the top). In what specific ways is the chart at bottom superior to the original chart at top?

What was the crime defendant was alleged to have committed : What was the crime the defendant was alleged to have committed? What are the elements of that crime? Is there sufficient evidence to believe the defendant guilty of this crime beyond a reasonable doubt? Explain.

User Account

All Pages