1. Entity-relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. Using this knowledge, explain the key reasons why entity-relationship modeling is important, and determine at least a way in which it impacts the overall development of the database.
2. Suggest one of the problems that normalization seeks to solve within a database. Describe one 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 or 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.
3. 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.
- Discuss the role of data security including technical, procedural or 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 organizations data. Identify at least two data security measures that you believe are necessary to prevent data security issues.
5. Using the organization you selected, explain the key ways in which your organization or agency uses business intelligence to gain a competitive advantage.
Next, speculate on the technological limitations regarding data, software, and hardware that you believe might challenge your chosen organization or agency in the future. Provide a rationale for your response.
5-7 sentences each number
Leave a Reply