This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Tutorial 1 answers Q1: I) Entities: Departments, Employees, Supervisor, Projects II) Assigned (Employee-Department), Has (Department-Supervisor), Works-On (Employee-Project), III) The only attributes indicated are the names of the departments, projects, supervisors and employees, as well as the supervisor and employee SSN and a unique project number. IV) The primary keys are Department_No (Dept_ Name is also acceptable), Supervisor No (same as the supervisor’s emp_no), Employee No, Project Number. Q2 : I) The entities in this system are DRIVER (a role), VEHICLE (a tangible item), LOAD (an event), EXPENSE (an event), STOP (a location) and ITEM (a tangible item). Most of these entities are evident from the wording in the problem. What may not be clear is the need for both LOAD and ITEM. A LOAD is the contents of a truck on a single trip. A LOAD contains many ITEMS which are dropped off at the various STOPs. Note that DEPOT is not an entity since it has only one instance....
View Full Document
This note was uploaded on 02/06/2012 for the course FACULTY OF WXGE6320 taught by Professor Noraini during the Winter '09 term at University of Malaya.
- Winter '09