Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

CUSTOMER EMPLOYEE PRODUCT SALE VENDOR Heres an explanation of how each entity was derived from the g... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions

Question

Exude confidence, not arrogance.

Answered: 1 week ago