Database Design and Implementation of Employee Database

This report covers the database design and implementation of the Employee database. It includes the use of a relational database management system, IT controls, and ethical, privacy, and security issues.

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
( TechTarget. 2016)
(Guru99. 2016)

IT Controls
IT controls are very important part of every database management system. some of them are as
follows-
- Backup/Recovery techniques
- Database performance techniques
- Integrity
- Security
- Database authorization
- User access control
IT controls are very important for the security point of view of the database. Database
authorization database integrity etc. all is very important techniques in maintaining the database
very smartly.
Ethical, Privacy and Security Issues
Ethical Issues
There are lot of ethical, privacy and security concerns in the companies. Ethical issues are very
concerned in every organization but sometimes those ethical issues have to be applied to secure
the database-
- The administrator has right to check the emails of the users to secure the company’s
important data.
- The administrator has right to check the user’s system to secure the company’s important
data.
- The administrator can use the key loggers to ensure the typing text of the users.
Security and Privacy
There are so many security standards that can be applied by the administrator to secure the
company’s information-
- Limit the features at user’s account or machine
- Do not give access on important data to all users
- Secure Copyright information
- Protect customer’s data by encrypting technique
- Do not share the customer’s detail to anyone outside the company
- Do not share the share holder’s detail to anyone outside the company

- Apply antivirus system on every machine
All the above secure and privacy techniques should eb applied on the database to secure the
company’s information. These are the basic techniques that can be applied very easily without
spending lot of money.
References
TechTarget. (2016), entity relationship diagram [online]. Available from:
http://searchcrm.techtarget.com/definition/entity-relationship-diagram / [Accessed 1 May
2018].
Guru99. (2016). Learn Database Normalization with the help of a case study [online]. Available
from:
http://www.guru99.com/database-normalization.html / [Accessed 1 May 2018].