Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems 6th Asian Conference Aciids 2014 Bangkok Thailand April 7 9 2014 Proceedings Part I 9 2014 Proceedings Part 1 Lnai 8397

Authors: Ngoc-Thanh Nguyen ,Boonwat Attachoo ,Bogdan Trawinski ,Kulwadee Somboonviwat

2014th Edition

3319054759, 978-3319054759

More Books

Students also viewed these Databases questions

Question

6. Explain the power of labels.

Answered: 1 week ago

Question

Differentiate 3sin(9x+2x)

Answered: 1 week ago

Question

Compute the derivative f(x)=(x-a)(x-b)

Answered: 1 week ago