Create table ZIPCODE
                    (Zip varchar2(5),
                     City varchar2(20) not null,
                     Primary key (Zip));

Create table EMPLOYEE
		(Employee_Num	varchar2(8)	not null,
		  Name		varchar2(32)	not null,
		  Zip		varchar2(5),
		 Hire_Date	date,
		 Primary key (Employee_Num),
		Foreign key (Zip) references ZIPCODE(Zip));

                 

Create table CLIENT
                   (Client_Num varchar2(9) not null,
                    Name varchar2(32) not null,
                    Street varchar2(32) not null,
                    Zip varchar2(5),
                    Phone varchar2(12),
                    Primary key(Client_Num),
                    Foreign key(Zip) references ZIPCODE(Zip));

Create table PROJECT
                    (Project_Num varchar2(9) not null,
                    Client_Num varchar2(9) not null,
                    Project_Mgr varchar2(10),
                    Start_Date date,
                    End_Date date,
                    Primary Key(Project_Num),
                    Foreign key(Client_Num) references CLIENT(Client_Num));

Create table PROJECT_EMPLOYEE
                   (Project_Num varchar2(9) not null,
                    Employee_Num varchar2(9) not null,
                    Number_Hours int,
                    Foreign key(Project_Num) references PROJECT(Project_Num),
                    Foreign key(Employee_Num) references EMPLOYEE(Employee_Num));



//Insert into CLIENT values (‘09870398’, ‘2383’, ‘49620929’, ‘01/OCT/2002’, null);

//Insert into CLIENT values ('28381', 'Boston Scientific', '57 Brandywine Terrace', '39875', '3429389838');

Insert into ZIPCODE values ('29387', 'Boise ID');
Insert into ZIPCODE values ('29853', 'Knoxville TN');
Insert into ZIPCODE values ('39875', 'Venice CA');
Insert into ZIPCODE values ('29087', 'Reno NV');
Insert into ZIPCODE values ('03944', 'Boston MA');
Insert into ZIPCODE values ('02953', 'Denver CO');

Insert into EMPLOYEE values('49620929', 'Jim Franks', '39875', '01-SEP-1998');