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
Step: 1
CUSTOMER EMPLOYEE PRODUCT SALE VENDOR Heres an explanation of how each entity was derived from the g...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started