Use Microsoft® Visio® to create an Entity Relationship Diagram (ERD) model for the Human Resources Department tables in the business case when Human Resources data have to be merged into centralized master database from different departments.
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 stated above.
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.