Use Microsoft® Visio® to create an Entity Relationship Diagram (ERD) model for the Human Resources Department tables in the business case you completed in Week One.
The ERD model should illustrate the data quality process you would recommend for the Master Data Management (MDM) system you described in the business case.
Identify the MDM requirements in your ERD model and ensure that you address risk and security.
Include the following in your ERD model:
- Fact tables, dimension tables, relationships, and cardinality
- MDM concepts that impact your design
Provide an explanation for each element contained within the ERD and the data quality process you would recommend for the MDM system.