database exercise

database exercise - agent and cashier employee entity...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
1. different stock number for each type 2. one customer order to involve several types of bells. Each customer order is processed by one salesperson ships the order to the customer and an invoice is immediately prepared. One shipping agents for each shipment. , each purchase order results in only one shipment. A shipment never includes goods ordered on more than one purchase order. 3. on account. partial payments on an invoice more than one invoice in one check. Cash receipts one cashiers. an employee table classification of employee that is involved in each event (e.g., salesperson, shipping
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: agent, and cashier). employee entity relationship. • An instance of salesperson cannot exist without a related employee. • An instance of salesperson can be related to only one employee. • An instance of employee can exist without a related salesperson . • An instance of employee can be related to only one salesperson. department entity. directly related to the employee entity. An employee is assigned to only one department at a time. A department cannot exist without an employee, and a department can be related to many employees....
View Full Document

This note was uploaded on 03/19/2012 for the course ACC 361 taught by Professor Eighme during the Fall '10 term at Miami University.

Ask a homework question - tutors are online