BSA 545 Project: Creating a Master Data Model for Integration

This project outlines the creation of a master data model (MDM) to integrate Human Resources and Master data, ensuring data integrity and preserving relationships. The project includes MDM requirements, an Entity Relationship Diagram (ERD), and identifies key data points such as Employee, Pro...Read More

MASTER DATA
MODEL
PATRICIA PARKER
BSA 545
[DATE]
DR. CHERYL MASON

CONTENTS
• MDM Requirements
• Entity Relationship Diagram (ERD)
• Key Data Points
• Value Of The Data Points
• Relevance To Each Table

MDM REQUIREMENTS
• This is to merge the data base of Human Resource and the
data base of Master data base into a single data base.
• This work is to be completed with out the loss of any kind of
data integrity in the system.
• Apart from this there should also be the consideration of no
loss in data relations

ENTITY RELATIONSHIP DIAGRAM (ERD)

KEY DATA POINTS
• The following is list of key data points for the ERD
• Employee
• Product
• Order
• OrderDetails
• Customer
• Supplier

VALUE OF THE DATA POINTS
• Employee (employeeID, firstName, lastName, address,
phone)
• Product (productID, productName, unitPrice, supplierID)
• Order (orderID, orderDate, totalValue, employeeID,
customerID)
• OrderDetails (orderID, productID, quantity)
• Customer (customerID, firstName, lastName, address, phone)
• Supplier (supplierID, companyName, address, phone)

RELEVANCE TO EACH TABLE
• Employee looks after the orders
• Each product is delivered by a supplier
• Order consists of employee looking after it and the customer who has
booked it
• Supplier is responsible for the delivery of their products
• Customers book orders from the company.
• Order details of the customer consists of the order, product and the
quantity of the product