Question: The requirements specify which entities and data are important to the business. Here are the requirements for this database. manager monitors employee data: e mployee
The requirements specify which entities and data are important to the business. Here are the requirements for this database.
- manager monitors employee
data: employee name, salary, and addresses
- sales person resells product to customer
data: customer, product, purchase date, company price, sale price
- sales team facilitates resale of product to customer
data: customer, product, purchase date, vendor price company price
- vendor sells product to company
data: vendor, product, vendor price
| Post Entities List - First Pass Go through each requirement and determine the entities it's describing. There are no marketing department, manager, sales team, nor sales person entities. They indicate other more general entities. Reduce the number of your entities using recursion and types. For example: WEB_CUSTOMER, IN_STORE_CUSTOMER would be modeled as CUSTOMER with an attribute named CustomerType. CustomerType would have the values 'web' and 'in store'. Post you entities in UPPER_CASE as a vertical list below. Write one entity per line. |
Step by Step Solution
There are 3 Steps involved in it
CUSTOMER EMPLOYEE PRODUCT SALE VENDOR Heres an explanation of how each entity was derived from the g... View full answer
Get step-by-step solutions from verified subject matter experts
