Master Data Model for Desklib Online Library

This presentation discusses the Master Data Model for Desklib Online Library, including MDM requirements, Entity Relationship Diagram, key data points, value of the data points, and relevance to each table. The key data points include Employee, Product, Order, OrderDetails, Customer, and Supplier, with specific attributes for each. The presentation also explains the relevance of each table to the overall system.

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