Tutorial 1Ans - Tutorial 1 answers Q1: I) Entities:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 4

Tutorial 1Ans - Tutorial 1 answers Q1: I) Entities:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online