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 2. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!