The requirements specify which entities and data are important to the business. Here are the requirements for
Question:
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. |
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill