Sample Database

Draw an arrow form the field in Employee to the field in Department that matches.

Draw an arrow from the employee table field to the field that matches in the time log.

Determine whether there is a one or many relationship in either direction.

Fill in the blanks

Column headings are also called: ______________

EMPLOYEE

Employee ID	First Name	Last Name	Address	City	State	Zip	Hourly Rate	Department
33452	James	Young	23 Howard Blvd	Bethlehem	NY	35255	10.00	001
35625	Jill	Pepper	356 Hill St	New Haven	CT	35666	7.00	002
35666	Beth	Vogel	3 Rt 1	Bethlehem	NY	35352	8.00	003
35555	Mary	Othre	352 Yelling St	Garden City	NY	56352	7.00	001

The names (and possible values) of all the headings in a table make up the _______________

DEPARTMENT

Department Id	Department Name	Department Manager
001	Linens	James Young
002	Kitchens	Carrie Plan
003	Bath	Mary Link

TIME LOG

Employee ID	Date	Hours Worked
33452	01/01/2006	8
33452	01/02/2006	7
35625	01/01/2006	6

The data in a table is also called a __________