Question: SQL . Just insert, don't need to create tables. Do not name any constraints other than the full_name for client and employee. Insert data in
SQL. Just insert, don't need to create tables.
Do not name any constraints other than the full_name for client and employee.
- Insert data in the tables
Insert the following into the client table:
| First Name | Last Name | |
| Sara | Smith | smiths@hello.com |
| Miguel | Cabrera | mc@hello.com |
| Bo | Chan'g | bochang@hello.com |
Insert the following into the employee table:
| First name | Last name | Start Date | |
| Ananya | Jaiswal | 4/10/2008 | ajaiswal@hello.com |
| Michael | Fern | 7/19/2015 | michaelf@hello.com |
| Abdul | Rehman | 2/27/2018 | rehman@hello.com |
Insert the following project instances into the project table (you should use a subquery to set up foreign key references and not hard-coded numbers):
| cid | title | comments |
| reference to Sara Smith | Diamond | Should be done by Jan 2019 |
| reference to Bo Chan'g | Chan'g | Ongoing maintenance |
| reference to Miguel Cabrera | The Robinson Project | NULL |
Insert the following into the works_on table. Again, your queries here should not have hard-coded integers for foreign keys.
| employee | project | due_date |
| Ananya Jaiswal | Chan'g | 11/19/2020 |
| Michael Fern | The Robinson Project | 12/05/2020 |
| Abdul Rehman | Diamond | 1/1/2021 |
.sql file:
-- write your queries to insert data here
-- Leave the queries below untouched. These are to test your submission correctly.
select * from project;
select * from client;
select * from employee;
select * from works_on;
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
