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 DocumentRight 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.

This note was uploaded on 09/26/2010 for the course CIS 336 taught by Professor Unk during the Fall '10 term at DeVry Houston.

Page1 / 6

Group_A_Week4_Total - DROP TABLE CHANNEL_LIST CASCADE...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online