Question: Step One: Write the first SQL script to create Oracle database tables using SQL Data Definition Language ( DDL ) for each table listed in
Step One: Write the first SQL script to create Oracle database tables using SQL Data Definition Language DDL for each table listed in the metadata of Project a Include DROP TABLE statements for each table at the script. b Ensure that referential integrity is established between related tables. Every table must have a Primary Key. Related tables must have Foreign Keys defined. These can be defined in ALTER TABLE statements later in the script. c At least one ALTER TABLE statement must be included in the first script. d Ensure all table constraints are properly defined such as PRIMARY KEYS, FOREIGN KEYS, etc. e Be sure to save your first SQL script that creates all of your tables with a sql extension.
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
