ndescription create database and load data create the physical databas
Search for question
Question
/nDescription:
Create Database and load Data - create the physical database and load it with
"real" or "realistic" data.
Instructions:
A. Generate the DDL code from the relational model (Use the DDL code
attached).
B. Create tables along with column comments, Primary Keys,
and foreign keys on Oracle Live SQL. ( https://livesql.oracle.com/)
c. Populate all tables with appropriate data - must have adequate data to
support the problem / opportunity of your business case (7 to 10 records
for Parent tables, 10 to 15 records for Child tables, 15 to 20 records for
intersect tables).
D. Run following dictionary queries and capture the screenshots.
REM: List of Tables
select table_name
from user_tables;
REM: List of Table Columns
select table_name, column_name,column_id
from user_tab_columns
order by table_name,column_id;
REM: List of Table Column Constraints
select
table_name,constraint_name, constraint_type,search_condition,index_na
me,r_constraint_name,delete_rule
from user_constraints
order by table_name;
REM: List of Table Column Comments
select table_name,column_name,comments
from user_col_comments
order by table_name;
F. For EACH tables of your database schema run following to show data./nInstructions
student note:
Part C should be as instructed:
A. Populate all tables with appropriate data - must have adequate data to support
the problem / opportunity of your business case (7 to 10 records for Parent tables, 10
to 15 records for Child tables, 15 to 20 records for intersect tables).
C. Populate all tables with appropriate data - must have adequate data to support the
problem/ opportunity of your business case (7 to 10 records for Parent tables, 10 to
15 records for Child tables, 15 to 20 records for intersect tables).
using https://livesql.oracle.com/
Each table name should start with CK_. Examples: CK_ORDER, CK_CUSTOMER
etc
Each table name should start with CK_. Examples: CK_ORDER, CK_CUSTOMER
etc as you see in the images of the logical and relational models