Assignment: Database and Information Management
• Please use APA format only
• Answer all the questions and provide citations where ever required
• Plagiarism free document
• Answer all questions accordingly.
• Please turn it in on time
1. List the three types of metadata that appear in a three-layer data warehouse architecture and briefly describe the purpose of each.
2. List four job skills necessary for data administrators. List four job skills necessary for database administrators.
3. List and discuss five areas where threats to data security may occur.
4. Explain how creating a view may increase data security. Also explain why one should not rely completely on using views to enforce data security.
5. What is the difference between deadlock prevention and deadlock resolution?
6. What are the key components of a data governance program?
7. What are four reasons why data quality is important to an organization?
8. Describe the key steps to improve data quality in an organization.
9. What distinguishes master data management from other forms of data integration?
10. Briefly describe four new specialized DBA roles that are emerging today.
11. What is the difference between an authentication scheme and an authorization scheme?
12. Briefly describe four major characteristics of heterogeneous distributed databases.
13. Explain the advantages and disadvantages of horizontal partitioning for distributed databases.