Answered step by step
Verified Expert Solution
Question
1 Approved Answer
P 0 8 0 1 Bluewater Consulting Open P 0 7 0 1 . sql created in chapter 7 and save as P 0 8
P Bluewater Consulting
Open Psql created in chapter and save as Psql Perform the following:
Use the insert statements in P Bluewater Consulting.sql file in the student files to insert
data into the BCEMPLOYEES and BCBILLINGS tables.
Using individual INSERT statements not batch insert insert the following rows into the
BCPROJECTS table by specifying the column names and the column values. Project leaders
have not been assigned.
Project ID
Project Name
Lakeview
Web App
Blue Light
Power Lite
Using individual INSERT statements not batch insert insert the following rows into the
BCJOBS table by specifying only column values.
Job id
Job Title
Lead Programmer
Database Designer
Programmer
Systems Analyst
General Support
DDS Analyst
Clerical Support
Charge Per Hour
Using SQL statements, add the following project leaders to projects:
Project ID
Project Leader ID
Use an SQL statement to remove employee Darlene Smithson from the database.
Use an SQL statement to change the hours billed for employee Alice Johnson who is
working on project from hours to
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 Psql file.
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