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

Fig: 1

Fig: 2