Database Design and Implementation of Employee Database

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

Introduction
Complete report is being showing the database design and implementation of the Employee
database. ER diagram is representing all relations in the database.
The ER diagram will be converted to relational database system and will be implemented in the
Microsoft Access database. Microsoft Access database is very useful relational database system
in which all database queries, database reports etc. can be built.
Use of Database
The Employee database is very important, crucial and very big. To save the complete database
into the file system is very difficult to manage as there is no separate table for specific data, no
queries, no reports etc.
But the relational database management system helps in maintaining the complete database very
easily. It manages the data in the tabular form. The relational database management system
provides the features to use queries, reports etc. It helps in searching the database in a very less
time.
File system has so many limitations as mentioned below. That is why; the relational database
management system is most used and much better technique-
- No option of searching data
- No option to make queries and reports
- Very time consuming
- Difficult to maintain access control
ER Diagram