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.

  1. Insert data in the tables

Insert the following into the client table:

First Name

Last Name

Email

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

Email

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!