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.

  1. manager monitors employee

data: employee name, salary, and addresses

  1. sales person resells product to customer

data: customer, product, purchase date, company price, sale price

  1. sales team facilitates resale of product to customer

data: customer, product, purchase date, vendor price company price

  1. 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

1 Expert Approved Answer
Step: 1 Unlock

CUSTOMER EMPLOYEE PRODUCT SALE VENDOR Heres an explanation of how each entity was derived from the g... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!