Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Office Supplies Inc. (OSI) sales office supplies to institutional buyers. It's sales representatives use the attached form to take orders. Customer account numbers on the

Office Supplies Inc. (OSI) sales office supplies to institutional buyers. It's sales 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 and the contact person information are filled out when a new customer account is created or when there is a change 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 OSIs 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 OSIs 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 drivers 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.

1. Identify the entities involved in the OSI application.

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

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

Database Systems Design Implementation And Management

Authors: Peter Rob, Carlos Coronel

3rd Edition

0760049041, 978-0760049044

More Books

Students also viewed these Databases questions

Question

Evaluate three pros and three cons of e-prescribing

Answered: 1 week ago