Database Management Systems
Tutorial Week 7
Weight 1%

The tutorial assessment each week is generally based on your understanding of the week’s course content, your written answers to each week’s tutorial questions, your group interaction in discussing your answers, and your presentation to the class.

You are required to provide written answers to each week’s tutorial questions. The due date for providing answers to each week’s tutorial tasks is by the beginning of your following week’s tutorial session. Make sure to submit your answers to the tutorial questions by its due date electronically using Moodle; and to take with you a printed/hand-written copy of your answers to the next tutorial session. For some questions your tutor may randomly select students to share their answers with the class. For some other questions, your tutor may invite students to discuss their written answers in groups and may ask you to present your group’s collective responses to the class.

Due to some particular circumstances, if you are not able to attend a tutorial session, make sure to:
a) let your tutor know asap the reason(s) you missed the class by email;
b) submit your answers to the tutorial questions by its due date electronically using Moodle.

Before attempting the following tutorial activities, you need to learn this week’s lecture slides. To gain more understanding of the topics covered in this week review Chapters: 7.2, 7.3, 7.5, and 8.1 up to but not including 8.1.1 of your textbook.
ASSESSABLE TASKS OF THE WEEK
Objectives:
* Further investigation of normalization * Practice writing SQL statements

1) The following table shows time spent by employees at various hotels. The Company# represents the company the employee is visiting at the time of the visit.

Employee# | Company# | Days | EmployeeName | Hotel# | HotelLocation | 1231 |