Question: Let's break down the typical data requirements for a general company, and then conceptualize an Entity-Relationship Diagram (ERD) for it. You may assume the business
Let's break down the typical data requirements for a general company, and then conceptualize an Entity-Relationship Diagram (ERD) for it. You may assume the business rules that lead to relationships between entities, some attributes of entity can be represented as relationships.
Company Data Requirements:
1. Employee Information
Employee ID
First Name
Last Name
Phone Number
Date of Hire
Position/Job Title
Salary
Department
2. Department Information
Department ID
Department Name
Department Manager
Location
3. Product Information
Product ID
Product Name
Product Description
Price
Quantity in Stock
4. Customer Information
Customer ID
First Name
Last Name
Phone Number
Address
5. Sales Information
Sale ID
Customer ID
Product ID
Quantity Sold
Date of Sale
Total Sale Price
6. Supplier Information
Supplier ID
Supplier Name
Phone Number
Address
Product Supplied
7. Invoice Information
Invoice ID
Sale ID
Date Issued
Amount
Payment Status
Step by Step Solution
3.38 Rating (164 Votes )
There are 3 Steps involved in it
To conceptualize an EntityRelationship Diagram ERD for the given company data requirements we can identify entities attributes and relationships Heres ... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help