Provide the text of the SQL statements for each task below

$0.$Write the SQL statements you used to create the frescowebdb database.

$1.$ Create all five tables listed above using the metadata to define the columns.

Client

Consultant

Orderline

Tasks

WorkOrder

$1$b$.$ What statement do you use to list all of the tables in a database?

$1$c$.$ What statement do you use to view the metadata of a table?

$2.$ Populate each table with the tuples listed in the datasets above.

Client

Consultant

Orderline

Tasks

WorkOrder Fresco Web Database Design

Relational Schemas

CONSULTANT$$consItNum$,$ lastName, firstName, street, city, state, zipcode, hours, rate$)$

CLIENT $($clientNum$,$ clientName, street, city, state, zipCode, balance, credithimit, consltNum$)$

TASKS$($taskID$,$ description, category, price$)$

ORDERLINE $($orderNum$,$ taskID, scheduledDate, quotedprice$)$

WORKORDER$($orderNum$,$ orderDate, clientNum$)$

Data Dictionary $($metadata$)$ Tasks

WorkOrder