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

CASE#5

CREATE TABLE consultant
( c_id		number(6),
  c_last	varchar2(20),
  c_first	varchar2(20),
  c_mi		varchar2(1),
  c_add		varchar2(30),
  c_city	varchar2(30),
  c_state	varchar2(2),
  c_zip		varchar2(5),
  c_phone	varchar2(10),
  c_email	varchar2(50),
  CONSTRAINT consultant_c_id_pk	PRIMARY KEY(c_id));
  
CREATE TABLE skill
( skill_id	number(6),
  skill_describtion	varchar2(50),
  CONSTRAINT skill_skill_id_pk	PRIMARY KEY(skill_id));
  
CREATE TABLE consultant_skill
( c_id		number(6),
  skill_id	number(6),
  certification	varchar2(1),
  CONSTRAINT	consultant_skill_c_id_fk	FOREIGN KEY(c_id)	REFERENCES consultant(c_id),
  CONSTRAINT	consultant_skill_skill_id_fk	FOREIGN KEY(skill_id)	REFERENCES skill(skill_id));