Andre Long
CISP 350 Oracle
Febuary 28, 2006
Chapter 2 PSC 

CASE#3

CREATE TABLE customer
( c_id		number(6),
  c_last	varchar2(15),
  c_first	varchar2(15),
  c_mi		varchar2(1),
  c_birthdate	date,
  c_address	varchar2(40),
  c_city	varchar2(30),
  c_state	varchar2(2),
  c_zip		varchar2(5),
  c_dphone	varchar2(10),
  c_ephone	varchar2(10),
  c_userid	varchar2(12),
  c_password	varchar2(12),
  CONSTRAINT  customer_c_id_pk	PRIMARY KEY(c_id) );
  
CREATE TABLE  order_source
( os_id		number(6),
  os_desc	varchar2(20),
  CONSTRAINT order_source_os_id_pk	PRIMARY KEY(os_id));
  
  
CREATE TABLE  orders
( o_id		number(6),
  o_date	date,
  o_methpmt	varchar2(10),
  c_id		number(6),
  os_id		number(6),
  CONSTRAINT orders_o_id_pk	PRIMARY KEY(o_id),
  CONSTRAINT orders_c_id_fk	FOREIGN KEY(c_id)	REFERENCES customer(c_id),
  CONSTRAINT orders_os_id_fk FOREIGN KEY(os_id)	REFERENCES order_source(os_id));