P$0801$ Bluewater Consulting

Open P$0701.$sql created in chapter $7$ and save as P$0801.$sql$.$ Perform the following:

$$ Use the insert statements in P$0801$ Bluewater Consulting.sql file in the student files to insert

data into the BC$\_$EMPLOYEES and BC$\_$BILLINGS tables.

$$ Using individual INSERT statements $($not batch insert$),$ insert the following rows into the

BC$\_$PROJECTS table by specifying the column names and the column values. Project leaders

have not been assigned.

Project ID

$15$

$18$

$22$

$25$

Project Name

Lakeview

Web App

Blue Light

Power Lite

$$ Using individual INSERT statements $($not batch insert$),$ insert the following rows into the

BC$\_$JOBS table by specifying only column values.

Job id

$501$

$502$

$503$

$504$

$505$

$506$

$507$

Job Title

Lead Programmer

Database Designer

Programmer

Systems Analyst

General Support

DDS Analyst

Clerical Support

Charge Per Hour

$85\mathrm{.}50$

$105\mathrm{.}00$

$37\mathrm{.}75$

$96\mathrm{.}75$

$18\mathrm{.}36$

$45\mathrm{.}95$

$26\mathrm{.}87$

$$ Using SQL statements, add the following project leaders to projects:

Project ID

$15$

Project Leader ID

$105$

$138$

$$ Use an SQL statement to remove employee Darlene Smithson from the database.

$$ Use an SQL statement to change the hours billed for employee $105($Alice Johnson$)$ who is

working on project $15$ from $35\mathrm{.}7$ hours to $49\mathrm{.}5.$

$$ Perform and document constraint testing for the following constraints:

o Default charge per hour

o One PK constraint

o One NOT NULL constraint

o One UK constraint

o One FK constraint

$$ Submit the P$0801.$sql file.