The business background on the use of the tables is provided to help you better understand the use of the tables and the data, so that the make-up of them makes more sense to you:

Table Name: JOB CLASS			Table Name: EMPLOYEE
JOB_CLASS_ID	JOB_CLASS_TYPE		EMP_ID	EMP_LNAME	JOB_CLASS_ID
1	PT Permanent		2020	Davolio	2
2	FT		2021	Smith	1
3	FT		2022	Penn	3
4	PT Temp		2024	Snyder	1
5	FT		2025	Jordan	4
6	FT		2026	Oliver
7	FT Temp		2029	Buchanan
			2030	Matthew	5
			2035	Philip

Some of the employees, such as interns or external consultants work in the company but are not employed by the company and they are not assigned a JOB_CLASS. These workers dont appear in the company payroll, although they might be assigned an employee id for the duration they work in the company. Other workers such as secretaries, engineers, accountants and manager are assigned a JOB_CLASS to manage the payroll requirements. These employees are assigned various job classes.

The JOB_CLASS_ID in the EMPLOYEE table denotes which job class in the JOB_CLASS table (if any) are assigned to each EMPLOYEE.

Each table contains 20-40 additional attributes that pertain to the entity (all job class information and all employee information, respectively) as well as many, many more rows. This has been condensed for ease of use. The concept remains the same, whether using this small example or tables with hundreds of records.

Using these two tables above, determine the results set from each of the queries (joins) that follow on the next page. Consider each of the MS-Word tables below a results set from a query. The column titles are the attributes that are returned from the query. Each cell in the table contains the values for the row. 2a has been started for you to help in understanding what is required.

The number of rows shown in each table does NOT indicate the number of rows that you should expect in your answer set! I have made each table equal in the number of rows. So maybe all of the rows will be used maybe not.

For any null values you may encounter in a given row, leave the null value blank.

1a. Complete the table below by filling in the values that would be returned for a natural join (note, it has been started for you to help in understanding what is required).

EMP_ID	EMP_LNAME	JOB_CLASS_ID

1b. Complete the table below by filling in the values that would be returned for an outer join on JOB_CLASS:

EMP_ID	EMP_LNAME	JOB_CLASS_ID

1c. Complete the table below by filling in the values that would be returned for an outer join on EMPLOYEE:

EMP_ID	EMP_LNAME	JOB_CLASS_ID