Q. need a response to this post. 1. Many large organizations have had their database system hacked and customer data stolen. How should the security for the database be different than security for the rest of the system? Does it make a difference for web-based data designs? If so, how? Explain your answer. Security is a universal requirement for a system. If we are building a system that would connect to the internet and be accessible to all then securing the system and its components is a major task. According to Tilley, this can be done with a combination of good design, software that can protect the system and detect intrusion, stringent rules for passwords and user identification, and vigilant users and managers (Tilley, 2019). Security for the database is a bit different than system security but it is as important as the system security. Database control must include all necessary measures to ensure that data storage is correct, complete and secure (Tilley, 2019). Either, it is a system or database, security triad of Confidentiality, Integrity and Availability remains the same only the methodology changes. System security includes access codes, data encryption, passwords, and audit trails but these security methods are implemented using additional tools and technology. Similarly, Database Management System (DBMS) implements security to data stored in the database. Tilley mentioned that a well-designed DBMS must provide built-in control and security features, including subschemas, passwords, encryption, audit trail files, and backup and recovery procedures to maintain data (Tilley, 2019). These features of the DBMS are used properly to secure the database system. For a database, a subschema can be used to provide a limited view of the database to a specific user or level of users. Different privileges can be associated with different users, so some users are limited to read-only access, while other users might be allowed to update or delete data. Encryption can be implemented on stored data to prevent unauthorized access (Tilley, 2019). In web-based data designs, a well-designed system provides security at three levels: the database, the webserver and the interconnection links that connect all the components of the system (Tilley, 2019). So, the security paradigm remains the same but with additional systems and entities to be protected across the system. Different privileges are designed by the database administrators to secure data in web-based design as data should be secure but easily accessible to authorized users (Tilley, 2019).
Q. need a response to this post.
1. Many large organizations have had their
Security is a universal requirement for a system. If we are building a system that would connect to the internet and be accessible to all then securing the system and its components is a major task. According to Tilley, this can be done with a combination of good design, software that can protect the system and detect intrusion, stringent rules for passwords and user identification, and vigilant users and managers (Tilley, 2019). Security for the database is a bit different than system security but it is as important as the system security. Database control must include all necessary measures to ensure that data storage is correct, complete and secure (Tilley, 2019). Either, it is a system or database, security triad of Confidentiality, Integrity and Availability remains the same only the methodology changes.
System security includes access codes, data encryption, passwords, and audit trails but these security methods are implemented using additional tools and technology. Similarly, Database Management System (DBMS) implements security to data stored in the database. Tilley mentioned that a well-designed DBMS must provide built-in control and security features, including subschemas, passwords, encryption, audit trail files, and backup and recovery procedures to maintain data (Tilley, 2019). These features of the DBMS are used properly to secure the database system.
For a database, a subschema can be used to provide a limited view of the database to a specific user or level of users. Different privileges can be associated with different users, so some users are limited to read-only access, while other users might be allowed to update or delete data. Encryption can be implemented on stored data to prevent unauthorized access (Tilley, 2019).
In web-based data designs, a well-designed system provides security at three levels: the database, the webserver and the interconnection links that connect all the components of the system (Tilley, 2019). So, the security paradigm remains the same but with additional systems and entities to be protected across the system. Different privileges are designed by the database administrators to secure data in web-based design as data should be secure but easily accessible to authorized users (Tilley, 2019).
References:
Tilley, S. (2019). Systems analysis and design (12th ed)., Boston, MA: Cengage Learning
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
