Question 1: The DAMA DMBOK textbook describes the following two core activities as part of the Data Architecture management exercise: Understanding enterprise information needs and Develop and Maintain the Enterprise Data Model .
Explain these activities, citing relevant academic sources where appropriate. Your discussion should not simply contain general definitions but should consider the context of the organization described in the case study. For instance, how would each of the components in an Enterprise Data Model apply to the healthcare provider described?
Further – consider what makes this particular industry unique from others. Data management is constrained by certain requirements such as government regulations, business concerns and legitimate needs. If any of these areas are relevant to the healthcare industry then these should be mentioned in your discussion.
All sources used should be referenced appropriately using APA referencing style. Your answer to this question should be around 1500 words excluding the reference list.
(50 marks)
Question 2: Now focusing on the specific requirements described in the case study. If we were to build a database to support these needs our first task is to create a suitable data model. This should capture the information requirements of the proposed system and show all cardinality, keys and be implementable in a relational database. (25 marks)
The deliverable for this question should be structured as follows:
a) Table listing the entities and their descriptions (5)
b) A suitable ERD diagram drawn in Microsoft Visio using the notation described in the lecture (15)
c) Any comments or assumptions that were made during the development of the model should be documented in this section as well. (5)