Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Following are two tables used by a software development company: JOB CLASS and EMPLOYEE Table Name: JOB CLASS Table Name: EMPLOYEE JOB CLASS ID
1. Following are two tables used by a software development company: JOB CLASS and EMPLOYEE Table Name: JOB CLASS Table Name: EMPLOYEE JOB CLASS ID | JOB CLASS TYPE EMP ID | EMP LNAME | JOB CLASS ID 1 PT Permanent 2 FT 3 FT 4 PT Temp 5 FT 6 FT 7 FT Tem 2020 2021 Smith 2022 Penn 2024 Snyder 2025Jordan 2026Oliver 2029 Buchanan 2030 Matthew 2035 Phil 2 4 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 vou 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 don't 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 iob classes 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 rg hown in each table does NOT indica number of r set! I have made each table equal in the number of rows. So maybe allof 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). (8 pts) EMP I EMP LNAME JOB CLASS ID 2020 Davelia 1b. Complete the table below by filling in the values that would be returned for an outer join on JOB_CLASS (14 pts) 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 14 pts) EMP ID EMP LNAME JOB CLASS ID 1. Following are two tables used by a software development company: JOB CLASS and EMPLOYEE Table Name: JOB CLASS Table Name: EMPLOYEE JOB CLASS ID | JOB CLASS TYPE EMP ID | EMP LNAME | JOB CLASS ID 1 PT Permanent 2 FT 3 FT 4 PT Temp 5 FT 6 FT 7 FT Tem 2020 2021 Smith 2022 Penn 2024 Snyder 2025Jordan 2026Oliver 2029 Buchanan 2030 Matthew 2035 Phil 2 4 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 vou 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 don't 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 iob classes 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 rg hown in each table does NOT indica number of r set! I have made each table equal in the number of rows. So maybe allof 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). (8 pts) EMP I EMP LNAME JOB CLASS ID 2020 Davelia 1b. Complete the table below by filling in the values that would be returned for an outer join on JOB_CLASS (14 pts) 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 14 pts) EMP ID EMP LNAME JOB CLASS ID
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started