Com506 Homework Assignment 4

Homework Assignment 4

Complete the following homework
problems and submit them as a Word document to the appropriate course Dropbox
no later than Sunday 11:59 PM EST/EDT. (This Dropbox basket is linked to
Turnitin.)

Coronel & Morris Chapter 7,
Problems 1, 2 and 3 (p. 308)

Coronel & Morris Chapter 8,
Problems 19 and 20 (p. 421)

19. Write a query to display the
products that have a price greater than $50.

20. Write a query to display the
current salary for each employee in department 300. Assume that only current
employees are kept in the system, and therefore the most current salary for
each employee is the entry in the salary history with a NULL end date. Sort the
output in descending order by salary amount.

Figure P8.20 Current salary for
employees in department 300

clip_image006

Q2

1. Write the SQL code that will
create the table structure for a table named EMP _1. This table is a subset of
the EMPLOYEE table. The basic EMP _1 table structure is summarized in the
following table. (Note that the JOB_CODE is the FK to JOB.)

2. Having created the table
structure in Problem 1, write the SQL code to enter the first two rows for the
table shown in Figure P7.2.

3 Assuming that the data shown in
the EMP _1 table have been entered, write the SQL code that will list all
attributes for a job code of 502.