Develop a script to create and populate a Database

This database has 4 tables

Cust

Emp

Product

Orders

Garden Spreadsheet has 4 worksheets for each of above tables.Graden Data Model

You need to create script to create Garden schema using SQL Developer

You need to develop a script to create tables

Garden dictionaries assist you to create tables.

You also need to create INSERT statement for each table.

Order of create table script should be as follow:

Cust

Emp

Product

Orders

Insert statements should also be in the same order as create tables.

-Run Insert statements.

-Run some sample queries to see if all data is correctly loaded.

Orders Product Customer \begin{tabular}{cl|rr|} & & \multicolumn{2}{|c|}{ UNIT_C } \\ PNO CATEGORY & name & UNIT_PRICE & OST \\ \hline 120 flowers & Dozen White Roses & 26.00 & 8.00 \\ \hline 130 flowers & Dozen Pink Roses & 25.00 & 6.00 \\ \hline 140 flowers & Dozen Yellow Roses & 24.00 & 6.00 \\ \hline 150 flowers & Dozen Rainbow Roses & 60.00 & 25.00 \\ \hline 160 Vegitbles & Dozen Big Tornatos & 60.00 & 25.00 \\ \hline 170 Vegitbles & Dozen Cherry Tomatos & 4.95 & 1.95 \\ \hline 190 flowers & Dozen Red Roses & 28.00 & 6.00 \\ \hline 200 Supplies & Potting Soil & 60.00 & 25.00 \\ \hline 210 Supplies & Hose & 60.00 & 25.00 \\ \hline 220 Supplies & Watering cane & 24.00 & 6.00 \\ \hline \end{tabular} Employee \begin{tabular}{cl|ll|l|l|} \hline ENO LNAME & FNAME & JOB_TITL & Gender & STATUS & DOB \\ \hline 1001 Hanzdo & Lee & Manager & M & Retired & 30-Apr-1931 \\ \hline 1002 Sims & Steven & Manager & M & Actlve & 10 May-1960 \\ \hline 1003 Adam & Bruce & Sales Rep & M & Active & 10-Nov-1955 \\ \hline 1004 Adam & Jan & Sales Rep & F & Terminal & 8-Nov-1960 \\ \hline 1005 Black & Jane & Sales Rep & F & Active & 4-Nov-1976 \\ \hline 1005 Black & Jane & Sales Rep & F & Active & 10-May-1960 \\ \hline 1005 Black & Jane & Sales Rep & F & Active & 10-Nov-1955 \\ \hline \end{tabular}