Question
CREATE A SQL PLUS SCRIPT deletedb.sql that deleted the whole database including constraints created in the table below! Help please! CREATE TABLE HEAD ( code
CREATE A SQL PLUS SCRIPT "deletedb.sql" that deleted the whole database including constraints created in the table below! Help please!
CREATE TABLE HEAD ( code number(10) , name varchar2(250), htype varchar2(1), hdate date, opbal number(10,4), constraint head_pk primary key (code), constraint head_unique UNIQUE (name), constraint head_check CHECK (htype in ('A','E','L','R')) );
CREATE TABLE SUBHEAD ( hcode number(10) , subcode number(10), name varchar2(250), sdate date, opbal number(10,4), constraint subhead_pk primary key (hcode,subcode), constraint subhead_fk foreign key (hcode) references head(code) );
CREATE TABLE CRCARD ( ctype varchar2(1) , ccnum varchar2(16), expdate date, crlimit number(10,4), constraint crcard_pk primary key (ctype,ccnum) );
CREATE TABLE store,
( name varchar2(100) code number(10), constraint store_pk primary key (code), constraint store_unique UNIQUE (name) );
CREATE TABLE EXPMAST ( expnum number(10) NOT NULL , edate date, cashamt number(10,4), storecode number(10), constraint expmast_pk primary key (expnum), constraint expmast_fk foreign key (storecode) references store(code) );
CREATE TABLE EXPDET ( expnum number(10) , linenum number(10), descrip varchar2(100), amt number(10,4), hcode number(10) , subcode number(10), constraint expdet_pk primary key (expnum,linenum), constraint expdet_fk_expnum foreign key (expnum) references EXPMAST(expnum), constraint expdet_fk_subhead foreign key (hcode,subcode) references SUBHEAD(hcode,subcode) );
CREATE TABLE ExpByCC ( expnum number(10) , ctype varchar2(1) , ccnum varchar2(16), amt number(10,4), constraint expbycc_pk primary key (expnum,ctype,ccnum), constraint expbycc_fk_expnum foreign key (expnum) references EXPMAST(expnum), constraint expbycc_fk_crcard foreign key (ctype,ccnum) references CRCARD(ctype,ccnum) );
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