CIS 411w spring 2017 Due Date: 2/14/2017

For this assignment you will use the emp and dept tables that exist in your schema.

Projection - a relational database management system (RDBMS) definition of projection is the list of columns selected from a table. A projection will limit the limit the number of rows selected so that you only see that data you want in your result set.

Log in to your ApEx account.

1. Write a SQL query that will select the department number and department name from the dept table. You will have to do a DESCRIBE on the dept table to get the actual spelling of the columns. Copy and paste your SQL query code into your assignment. Run your SQL command and save a screen shot of the result set.

2. Write a SQL query that will select the employee number, employee name and job from the emp table. You will have to do a DESCRIBE on the emp table to get the actual spelling of the columns. Copy and paste your SQL query code into your assignment. Run your SQL file and save a screen shot of the result set.

Selection - a relational database management system (RDBMS) definition of selection means which rows are to be returned in a SQL query.

3. Write a SQL query using the emp table that will return only the employees that have CLERK as their job. The columns to be included in the select are: the employee number, employee name and job. Copy and paste your SQL query code into your assignment. Run your SQL file and save a screen shot of the result set.

4. Write SQL query using the emp table that shows only the employees that have a salary greater than 1250. The columns to be included in the select are: the employee number, employee name, job and salary. Copy and paste your SQL query code into your assignment. Run your SQL file and save a screen shot of the result set.

Submit your assignment to the Problem Set 2 drop box for credit.