Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help answer parts B in the following picture im supposed to have a coneptual and internal ER model. The entities i have are: SALES

please help answer parts B in the following picture im supposed to have a coneptual and internal ER model. The entities i have are: SALES REP, ORDER, CUSTOMER, TRUCK, DRIVER, ITEM and EMPLOYEE.

image text in transcribed

image text in transcribed

This is what i have so far

image text in transcribed

Office Supplies Inc. Office Supplies Inc. (OSI) sales office supplies to institutional buyers. It's saless representatives use the attached form to take orders. Customer account numbers on the form are unique. Customers have only one billing address. Each customer also has a designated contact person who is responsible for bill payment. The billing address of address or contact person of an existing customer. OSI offers free delivery service to its customers. Usually all deliveries are made within two business days of the order date. If a customer decides to use OSI's delivery service then the delivery address is filled in the order form. Sometimes a customer may not use the delivery service if he/she needs the supplies immediately. In such a case the customer is responsible for picking up the order from OSI's warehouse. All items in an order are delivered to the same address. OSI owns several trucks for delivering customer orders. Trucks have a vehicle number, license plate number, license expiration date, and inspection expiration date The same driver is always assigned to the same truck. OSI maintains information on items it sales. Each item type is identified by an item code and has a unit price. OSI also keeps a record of the number of units of each item type available for sale. OSI employs several employess. Each employee has a social security number, name, address, and phone number. Drivers are a type of employee. In addition to employee information, each driver also has a driver's license number and a license expiration date. Sales reps are also a type of employee. Sales reps have a salary and commission. All other employees have only a salary OSI wants to create an information system to manage its operational data. The OSI management has hired you as consultants for this project Requirements

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

C++ Database Development

Authors: Al Stevens

1st Edition

1558283579, 978-1558283572

More Books

Students also viewed these Databases questions

Question

Were the right people involved in the decision-making process?

Answered: 1 week ago