Objective: To develop a script to create and populate PROJ database

Your need to do the following tasks:

$1.$ Using the Lucid chart and data dictioanry provided, create the data moel for Proj DB

$2.$ Using the data dictioanry provided, develop the CREATE TABLE script for Proj DB

$3.$ Data for Proj DB tables are provided in the worksheets of the Proj data dictioanry.

$4.$ Using these worksheets, develop INSERT statements for each table of PROJ DB$.$

$5.$ Create a schema called PROJ using your SYSTEM schema

$6.$ Connect to Proj Schemsa using SQL Developer

$7.$ Run PROJ table script t create tables

$8.$ Run PROJ INSERT script to load data in PROJ database

$9.$ Verify if database is correctly loaded by rnning the following SQL commands

o Select $*$ from every table

o Selct count$(*)$ from every table

o Check to see if you have lost any datObjective: To develop a script to create and populate PROJ database

Your need to do the following tasks:

$1.$ Using the Lucid chart and data dictioanry provided, create the data moel for Proj DB

$2.$ Using the data dictioanry provided, develop the CREATE TABLE script for Proj DB

$3.$ Data for Proj DB tables are provided in the worksheets of the Proj data dictioanry.

$4.$ Using these worksheets, develop INSERT statements for each table of PROJ DB$.$

$5.$ Create a schema called PROJ using your SYSTEM schema

$6.$ Connect to Proj Schemsa using SQL Developer

$7.$ Run PROJ table script t create tables

$8.$ Run PROJ INSERT script to load data in PROJ database

$9.$ Verify if database is correctly loaded by rnning the following SQL commands

o Select $*$ from every table

o Selct count$(*)$ from every table

o Check to see if you have lost any dat