THE ACCOUNTING INFORMATION SYSTEM

Running head: ACCOUNTING INFROMATION SYSTEM
Accounting Information System
Name of the Student:
Name of the University:
Author Note

1
ACCOUNTING INFROMATION SYSTEM
Table of Contents
Need for the use of a database.........................................................................................................2
E-R Diagram....................................................................................................................................2
Tables in the Third normal form......................................................................................................2
Database design...............................................................................................................................2
Tables...............................................................................................................................................2
Data..................................................................................................................................................5
Creation of Queries and forms.........................................................................................................6
Reports.............................................................................................................................................8
IT controls needed...........................................................................................................................9
Ethical, privacy and security issues.................................................................................................9
Bibliography..................................................................................................................................10

2
ACCOUNTING INFROMATION SYSTEM
Need for the use of a database
Database is system to sort as well as take care of the data. Database engine could sort,
serve or modify information stored inside the database. Information itself could be stored within
several separate processes. Database is computer program which is used to manage electronic
database. Data within database could be organized in few ways. Database store data as well as
provides the facilities to search certain record within provided data. Special information is stored
inside database that is used for managing data. They could solve cases in where several users
attempt to access similar data entries. Access rights are managed by the database. Specific
attributes are essential than the others, these could be used for searching other data. Database
makes sure that data has context always. Several different rules are there which could be added
for telling database if data have some sense. Invalid data should be rejected automatically.
E-R Diagram

3
ACCOUNTING INFROMATION SYSTEM
Tables in the Third normal form
The data requirement description for the organization has been described below:
Sales Representative (RepresentativeNo (primary key), LastName, FirstName, Street, City, State,
Zip, Commission, Rate)
Customers (CustomerNo (primary key), CustomerName, Street, City, State, Zip, Balance,
CreditLimit, RepresentativeNo (foreign key))
Category (Category (Primary key))
Warehouse (WarehouseNo (Primary key))
Products (ProductNo, ProductName, OnHand, Category (foreign key), Warehouse (foreign key),
UnitPrice)
Orders (OrderNumber (primary key), OrderDate, CustomerNo (foreign key), ProductNumber
(foreign key), NumberOrdered, QuotedPrice)
Database design
Tables
Warehouse