Answer:
Legal Issues in Database
Fringe Dweller is planning to store customer’s important and highly confidential information into database. There may be many legal issues may occur at while maintaining these details into the database. Some of them are as follows-
- The important detail like credit card details etc. can be hacked and can be used illegally by hackers.
- Customer’s personnel data should also be saved into the database privately. It can be searched by social sites and it should be restricted to be happening.
- There is Personnel Act right and it should be followed by the company. If it will not, the users can claim to the company.
Techniques to Secure Database
There are so many techniques that may be sued in securing the data like below-
Encryption / Decryption Techniques
The encryption/decryption techniques can be used to store the important detail of customers like credit card details etc. this technique stores the data into encrypted format and when extracted from the database, decrypt the information and gives accurate results.
This technique is very useful and reduces the risk of hacking.
Firewall
It helps in restricting the unauthorized outsider websites. It helps in maintaining the database security by not giving access to the outside world.
Authentication / Authorization
This technique helps in restricting the unauthorized users to access the database. It first authenticates users before login into the database. If the user is not authenticated, the user cannot enter into the database otherwise the user will be given access to the database.
These are the best techniques to secure the database from malicious viruses or hackers.
Importance of ER Diagram
The ER diagram is very important to show the data flow pictorially. It can easily show the complete process very easily in spite of plain text. The ER diagram very easily shows the necessary detail like customer details etc.
It is like a blueprint that helps in making the database and works as a sketch that helps the database designer to understand the complete database very easily. It shows all the entities with their attributes and shows the relationship in between different entities. Complete database is made with entities, and attributes and it is very difficult to understand the plain text but ER diagram shows all entities in the form of tables and shows the relationship pictorially that is very easily readable.
References
CS Odessa Corp. (2016). Design elements – ERD (crow’s foot notation) [online]. Available from: https://www.conceptdraw.com/examples/crowfoot-notation [Accessed: 25-May-2018]
etutorials.org. (2018). Chapter 12: SQL and RDBMS Security [online]. Available from: https://etutorials.org/SQL/sql+bible/Part+V+Implementing+Security+Using+System+Catalogs/Chapter+12+SQL+and+RDBMS+Security/ [Accessed 25-May 2018].
