Database Design of Employee Database for ACCT6001 Accounting Information Systems

Student ID –
Date -
ACCT6001 Accounting Information Systems
Database Application
Module Tutor -

Report
Introduction
The report is showing the database design of Employee database. After designing the normalized
database, the database will be built in Microsoft Access database. First ER diagram is created in
the report and after that normalized ER Diagram is created to resolve the redundancy.
The report is showing the complete database designing from un normalized database to
normalized database. IT Controls, Ethical, Privacy and Security Issues etc. all are discussed in
the report.
Importance of Database Usage
Database is a very important for every application. To manage the data of any application
database is required. File system can be used for this but file system does not provide all the
necessary features that a relational database system provides. File system does not maintain the
database very efficiently like the relational database system.
A relational database system gives so many facilities over file system like below-
- Searching the database
- Make queries and reports
- Time saver
- User Access control facility
- Performance analysis
- Very useful to the top level management
All the above mentioned features of the relational database system helps in managing the
database accurately and it helps in reducing the fetching time of data from the server that
increases the system performance in a large business.

ER Diagram
The above ER diagram is not normalized ER Diagram. Tables are not in 3 NF. A material may
be sourced from different suppliers. In this case, the information of the material will be repeated
number of times. The same thing will happen in the Employee table. An employee may be
belonged to more than one project. In this case, the employee detail will be repeated number of
times. To resolve this issue, the tables are converted to 3 NF and the normalized ER diagram is
shown below-