Question: Objective: To develop a script to create and populate PROJ database Your need to do the following tasks: 1 . Using the Lucid chart and
Objective: To develop a script to create and populate PROJ database
Your need to do the following tasks:
Using the Lucid chart and data dictioanry provided, create the data moel for Proj DB
Using the data dictioanry provided, develop the CREATE TABLE script for Proj DB
Data for Proj DB tables are provided in the worksheets of the Proj data dictioanry.
Using these worksheets, develop INSERT statements for each table of PROJ DB
Create a schema called PROJ using your SYSTEM schema
Connect to Proj Schemsa using SQL Developer
Run PROJ table script t create tables
Run PROJ INSERT script to load data in PROJ database
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:
Using the Lucid chart and data dictioanry provided, create the data moel for Proj DB
Using the data dictioanry provided, develop the CREATE TABLE script for Proj DB
Data for Proj DB tables are provided in the worksheets of the Proj data dictioanry.
Using these worksheets, develop INSERT statements for each table of PROJ DB
Create a schema called PROJ using your SYSTEM schema
Connect to Proj Schemsa using SQL Developer
Run PROJ table script t create tables
Run PROJ INSERT script to load data in PROJ database
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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help