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.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.