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.

   

Transcribed Image Text:

Distributor PK DISID DalName Phora FK AddressD Catalog PK CallD FK Dist FK Novol PK Fi FeeList FK Rall FK Standard Fee LaFe Denuntarenage DamagedFeet RowingFoo CuatiD CHE Address PK AddressID She Address City State ZoCode Rental PK RentallD FK CUID FK Invertory D RealDa Acta RetumDate FK TeeD Customer PK Customerio ScheduleRetumDate Director PK Director D FName FNam FK Addresa D Name FK Award FK Movie D LName Phone Email Inventory PK InventoryD FK Movie D PK Movie Movie MovieName Actor Movielang MovieRating Year Released Gene CE FK Dist Academy Awards PK Awards0 AwardName FK Acto D FK MovielD Genre PK Genrein GaraNama FK MavelD ActorActoresses PK ActorID FName LName Movies FK MovelD FK AwardID Distributor PK DISID DalName Phora FK AddressD Catalog PK CallD FK Dist FK Novol PK Fi FeeList FK Rall FK Standard Fee LaFe Denuntarenage DamagedFeet RowingFoo CuatiD CHE Address PK AddressID She Address City State ZoCode Rental PK RentallD FK CUID FK Invertory D RealDa Acta RetumDate FK TeeD Customer PK Customerio ScheduleRetumDate Director PK Director D FName FNam FK Addresa D Name FK Award FK Movie D LName Phone Email Inventory PK InventoryD FK Movie D PK Movie Movie MovieName Actor Movielang MovieRating Year Released Gene CE FK Dist Academy Awards PK Awards0 AwardName FK Acto D FK MovielD Genre PK Genrein GaraNama FK MavelD ActorActoresses PK ActorID FName LName Movies FK MovelD FK AwardID

Answer rating: 100% (QA)

Drop tables if they exist DROP TABLE IF EXISTS Distributor DROP TABLE IF EXISTS Address DROP TABLE IF EXISTS Customer DROP TABLE IF EXISTS Product DRO... View the full answer