hwk04dbms[1] - drop table lineitem; drop table order; drop...

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

View Full Document Right Arrow Icon
drop table lineitem; drop table order; drop table marketingmaterial; drop table cd; drop table customer; drop table vendor; drop table zipcode; create table zipcode ( zipcode char(10), zip_city char(20), zip_state char(20), zip_country char(20), constraint pk_zip primary key (zipcode) ); create table vendor ( vendor_id number(9), vendor_name char(20), vendor_address varchar(30), vendor_zip varchar(10), vendor_contact varchar(20), vendor_phone varchar(15), zipcode char(10), constraint pk_vendor primary key (vendor_id),, constraint fk_vendor_zip foreign key (zipcode) references zipcode ); create table customer ( customer_id number(7), customer_lname char (20), customer_fname char (20), customer_address varchar(30), customer_zip varchar(10), vendor_phone varchar (15), customer_email varchar(20), zipcode char(10), constraint pk_customer primary key (customer_id), constraint fk_customer_zip foreign key (zipcode) references zipcode ); create table cd ( cdid char(6), cd_title char(20), cd_artist char(20),
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

hwk04dbms[1] - drop table lineitem; drop table order; drop...

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

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