Introduction
The report is showing the complete overview about database implementation of employee database. The relational database management system is built to implement the employee database. MS Access is used for employee database. MS Access is very efficient. It is providing all features like queries, reports etc. to access the entire database efficiently.
Use of Database
The use of database is very important and necessary. To handle a large data the relational database management system is required. Old file systems will not work in maintaining the large data.
The file system does not give all the features like the relational database management system. it does not provide feature to make queries, database reports, performance analysis tool etc.
There are so many limitations in the old file system that is the big reason of popularity of the relational database management system. Some of them are as follows-
- Lack of searching option
- Lack of Query tool
- Lack of Reports tool
- Lack of performance analysis tool
- Lack of access control
- Lack of backup and recovery techniques
Above all mentioned features are very necessary to maintain the large data. All the above features are very important for the top level management also. That is the reason; the relational database management system is being used in all organizations.
The relational database management system provides the backup and recovery techniques. It is the most important feature in the relational database management system which is the main reason to choose the relational database management system over the old File System.
(Intellipaat.com. 2018)
ER Diagram
![]()
(Visual-Paradigm. n.d.)
IT Controls
IT control is the basic of the relational database management system. it helps in maintain the database in a proper way. Following IT Controls are used in the relational database management system-
Data Integrity
Data integrity is the main concern in the relational database management system. It stores the data into the database very efficiently without repeating the group of data.
Data Access Control
Data Access control is very important for the security concern. By Data Access Control, the user can be given authority to access a part of the database and to restrict some part of the database.
Backup and Recovery Techniques
There are so many backup and recovery techniques provided by the relational database management system. It is the most important feature given in the relational database management system. it helps in taking the backup of database on regular basis and does not loss the important data accidently.
Database Security
The database security is the main concern for every relational database management system. It helps in securing the data by applying access control, limiting resource etc.
Ethical, Privacy and Security Issues
Ethical Issues
Ethical issues are the main concern for the organizations now a day. It is very necessary for the organizations as it saves the company’s important data to be leaked outside. Therefore; the organizations follow these things to save important information-
Checks Email of Employee
Companies check the emails of the employees without informing them to check their detail in case they are passing the important detail outside or not. It helps in making trust between the employees and organization also.
Restrict Interaction with the Outside World
Organizations may restrict the employees to interact with the outside world during timing hours so that important data cannot be shared.
Apply Key Loggers
The companies can apply key loggers to check the typing data of users on their machine. It helps in checking the detail that is being shared by the employees.
Security and Privacy Issues
There are so many security and privacy standards in the companies now a day. Some of them are as follows-
Limit Access Features
Companies limit the access features of users by restricting the features of the relational database management system. It is very important point for the security point of view.
Copyright Information
Companies copyright important information so that no one can use that.
Apply Firewall
Companies may apply firewall to restrict the information from going to the outside. it is the best feature of the relational database management system.
Use Antivirus
Companies use antivirus to protect the information from malicious viruses or users.
Use Encryption/Decryption Techniques
Companies use encryption/ decryption techniques to store important detail into the database. The information gets stored in encrypted form and then on the time of retrieval gets decrypted.
These are the ethical, security and privacy issues that may be used by the companies to save the important detail. All the above techniques can be sued to secure the companies information to a high context. All these features are provided by the relational management system and can be easily implemented in every organization.
References
Visual-Paradigm. (n.d.). What is Entity Relationship Diagram (ERD) ? Retrieved from https://www.visual-paradigm.com/guide/data-modeling/what-is-entity-relationship-diagram/
Intellipaat.com. (2018). RDBMS [online]. Retrieved from
https://intellipaat.com/tutorial/sql-tutorial/rdbms/
