Office Supplies Inc. (OSI) sales office supplies to institutional buyers. It\'s

Question

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

Identify the entities involved in the OSI application. Define each entity using 1-2 sentences. Create a relationship matrix to identify relationships among these entities. Write business rules to describe the relationships among these entities. Each pair of business rules will have the following format:

Each A is {sometimes | always} related to {one | one or more} B's.

Each B is {sometimes | always} related to {one | one or more} A's.

Describe supertype-subtypes relationships as: A is a kind of B.

                                                               B can be an A.

You don’t need to create E-R diagrams for this part.

Explanation / Answer

Entities/Relations are as follows:-

- Customer

- BillingAddress

Each customer is related to one or more BillingAddress
Each BusinessAddress is related to one or more Customer

- Truck

- Employee

- Driver is a subtype of employee

Each Driver is related to one truck

Each Truck is related to one Driver

- Sales Rep is a subtype of employee

- Item

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.