Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started