Question: 1 . Take your physical design for and create the tables along with all the constraints. Use a mix of: a . CREATE TABLE with
Take your physical design for and create the tables along with all the constraints. Use a mix of:
a CREATE TABLE with columnlevel constraints
b CREATE TABLE with tablelevel constraints
c ALTER TABLE commands
Create all tables with constraints
a dont forget to drop tables in reverse order with CASCADE option
b create tables in order parents first and then children
c composite PK should be implemented as table level constraints after column definitions
Package your solution up in a folder and zip it using Windows compress and submit it Structure should include:
a Root Folder
i Attribution List
b A Build Folder
i Contains a script and spool file that creates all the tables
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
