{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Group_A_Week4_Total

Group_A_Week4_Total - DROP TABLE CHANNEL_LIST CASCADE...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 DROP TABLE CHANNEL_LIST CASCADE CONSTRAINTS PURGE DROP TABLE DEPARTMENT CASCADE CONSTRAINTS PURGE DROP TABLE EMPLOYEE CASCADE CONSTRAINTS PURGE DROP TABLE SALES CASCADE CONSTRAINTS PURGE DROP TABLE CHANNEL CASCADE CONSTRAINTS PURGE DROP TABLE PROGRAM CASCADE CONSTRAINTS PURGE DROP TABLE PACKAGE CASCADE CONSTRAINTS PURGE DROP TABLE SUPPLIER CASCADE CONSTRAINTS PURGE DROP TABLE GUIDE CASCADE CONSTRAINTS PURGE DROP TABLE SURVEY CASCADE CONSTRAINTS PURGE DROP TABLE CUSTOMER CASCADE CONSTRAINTS PURGE DROP TABLE BILL CASCADE CONSTRAINTS PURGE DROP TABLE ADDRESS CASCADE CONSTRAINTS PURGE CREATE TABLE CUSTOMER ( Customer_ID NUMBER(10) NOT NULL, First_Name VarChar2(20) NOT NULL, Last_Name VarChar2(20), Phone NUMBER(9), Email VarChar2(30), Fav_Chan NUMBER(3) NOT NULL, Package_IDd CHAR(10) NOT NULL, Street_Numbera VarChar2(50) NOT NULL, Statusa VARCHAR2(8) UNIQUE, City VarChar2(30) NOT NULL, State Char(2) NOT NULL, Zip NUMBER(5) NOT NULL, PRIMARY KEY (Customer_ID) ) CREATE TABLE ADDRESS ( Street_Number VARCHAR2(50), City CHAR(20) , State CHAR(2) DEFAULT ('AL'), Zip CHAR(5), Customer_IDa NUMBER(10), PRIMARY KEY (Street_Number) ) CREATE TABLE PACKAGE ( Package_ID CHAR(10) NOT NULL, Pack_Name CHAR(10) NOT NULL, Pack_Type CHAR(5) NOT NULL, Pack_Price NUMBER(9,2) UNIQUE, Pack_NumSold NUMBER(1,0) NOT NULL, Customer_IDb NUMBER(10) NOT NULL,
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Sheet1 Page 2 List_IDa NUMBER(5) NOT NULL, Bill_IDa NUMBER(9,2) NOT NULL,
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}