Accounting Information System for Desklib - ER Diagram, Tables, Relationships, Query, Form, Report, Risks, Future Improvements

ACCOUNTING
INFORMATION SYSTEM

Table of Contents
ER Diagram................................................................................................................... 3
Tables........................................................................................................................... 4
Data types...................................................................................................................... 7
Relationships................................................................................................................ 10
Query......................................................................................................................... 11
Form.......................................................................................................................... 15
Report......................................................................................................................... 17
Potential Risks.............................................................................................................. 20
Structured Narrative Table............................................................................................... 21
Future Improvements...................................................................................................... 23
2

ER Diagram
The ER diagram is shown in below.
The Entity Relationship Diagram contains the following entities employee, member, sale
cash receipt, cash receipt, sale, inventory sale, inventory, customer and Extras. The Sale table
connecting the employee, member, sale cash receipt, customer and inventory sale. The Inventory
sale connecting the Inventory and extras table. The cash receipt table is connected with employee
and member table. Entity relationship diagram shows the full database application for the
Schafer refreshment Kiosk Company.
Tables
3

The Overall data application entities are shown in below.
For Employee Table,
The employee table consists of employee ID, first name, last name, address, suburb,
postcode phone number and email address. Here Employee ID is the primary key.
For Inventory Table,
The Inventory table consists of Inventory ID, Product ID, description, Inventory Cost,
Inventory Price, and Quality on hand. Here the Inventory ID is the primary key and product ID is
the foreign key.
For Member table,
4

The member table consists of Member ID, first name, last name, address, suburb, post
code, phone number, email address and credit limit. Here the member ID is the primary key.
For Cash Receipt table,
The cash receipt table consists of cash receipt ID, data, Cheque Number, Member ID and
Employee ID. Here the Cash receipt ID is the primary key. The Member ID and Employee ID is
the foreign key.
For Sale table,
5

The Sale table consists of Order ID, date, Member ID, employee ID, description,
Quantity Ordered, inventory Price, extension, Order Total, Inventory sale ID and sale cash
Receipt ID. Here the Order ID is the primary key. The inventory sale ID and sale cash receipt ID
is the foreign Key.
For Sale cash Receipt table,
The Sale cash receipt table consists of Cash receipt ID, order ID, amount applied and sale
cash receipt ID. The Sale Cash receipt ID is the primary key and cash receipt ID is the foreign
key.
For Inventory Sale Table,
6