WEEK 7-9
Database normalization is the process of organizing the attributes and tables of a relational database to minimize data redundancy. If a database design is not perfect it may contain anomalies, which are like a bad dream for a database itself. Managing a database with anomalies is next to impossible. Normalization is a method to remove all these anomalies and bring a database to a consistent state, free from any kinds of anomalies. Research normalization.
Normalization and Redundancy:
• Suggest one (1) of the problems that normalization seeks to solve within a database. Describe one (1) example of your suggested problem and explain the overall benefit that normalization would provide. (Note: Your example can be hypothetical or use the university business function/operation.)
• Identify the key determinants that could affect the degree of normalization of a database. Justify your response. Next, identify the aspects of the database design that can be denormalized. Explain the key ways in which the business rules support the degree of normalization and the elements that can be denormalized.
Engage the following resource(s) to get started.
Video(s)
Normalization | Database Management System
https://www.youtube.com/watch?v=IwswNIZ_PSg
How to do database normalization
https://www.youtube.com/watch?v=UDFRhj_K508
Database Normalization
WEEK 8*****************************
Database servers store and retrieve large volumes of structured data on high speed disk arrays. The server software can be purchased off the shelf from companies like Oracle or Microsoft; then, software developers use the database services to hold the data collected by their programs. Data gets held in structures known as tables, with each table holding a set of related items. One table may hold a list of customers, listing their names, addresses, credit ratings, and other data. A second table may hold customer sales, listing each purchase by customer. The database stores all this data in a way that makes it fast and easy to retrieve related items. Research the role of databases and database management systems.
Discuss the role of databases and database management systems in the context of enterprise systems. Also include a discussion on the components of the DBMS.
WEEK 9*******************************
Data security ensures that data is protected against unauthorized access, and if the data is accessed by an authorized user, that the data is used only for an authorized purpose. Database security concerns the use of a broad range of information security controls to protect databases (potentially including the data, the database applications or stored functions, the database systems, the database servers, and the associated network links) against compromises of their confidentiality, integrity, and availability. Research the role of data security and database security.
Discuss the role of data security including technical, procedural/administrative, and physical controls as well as a discussion on confidentiality, integrity, and availability. Also include a discussion on the consequences of a security breach. Suppose you are also in charge of securing your organization’s data. Identify at least two (2) data security measures that you believe are necessary to prevent data security issues.
Engage the following resource(s) to get started.
Video(s)
Best Practices in Data Security