Entity Relationship Diagram (ERD) Final Project
qofmefjordan
presentation1.pptxData points of the Entity Relationship Diagram (ERD) model
Data points
Employees
They provide data for the employee data stored in the table employee.
It contains a range of information regarding employee including:
Employee Id
First Name
Address
Last Name
Phone Numbers
2
Product
Product
Gives the details on the products sold by the organisation
The details include the following:
Product Id
Product Name
Unit Price
Supplier ID
Cont.
Supplier
Captures all details of all companies who supply products or services to the company
It contains in details the following:
Supplier Id
Campany Name
Adress
Phone
Cont.
Order
Captures details of all orderings with the following details:
Order ID
Order Date
Total Value
Employee ID
Customer ID
Cont.
Customer
Will contain all the data for the customers of the organisation
Among the details are:
Customer ID
First Name
Last Name
Address
Phone
6
