Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
4. The Allocation table
Quiz
Summary

Instruction

Perfect! And finally – the last table.

Exercise

Select all the information from the table Allocation.

At the company we're discussing, each employee (EmployeeId) can work on a single project (ProjectId) on a given date (WorkDate) for a given number of hours (HoursSpent). For instance, employees can work on project 1 on Monday, project 2 on Tuesday, project 1 again on Wednesday, etc.