SQL & PL/SQL

Having a hard time running my script. Essentially I have to create a few table entries into the 3 tables shown in my E/R Diagram and create the "Personnel Emergency Vehicle Shelter" table using the primary keys from the other three tables as a foreign key.

http://img7.imageshack.us/img7/6443/dynamicenies.png

notepad+ doesn't have anything for Oracle only SQL.


drop table emergency_vehicle;

create table emergency_vehicle(
e_veh_ID varchar2(8) primary key,
e_veh_plate varchar2(8),
e_veh_registered_owner varchar2(50),
e_veh_make varchar2(50),
e_veh_model varchar2(50)
);

insert into emergency_vehicle values
('veh00001','ABA12345','General Hospital','FORD','E-350');

insert into emergency_vehicle values
('veh00002','ANA56844','General Hospital','FORD','E-350');

insert into emergency_vehicle values
('veh00003','TEST8408','City Fire Department','MACK','Model 95');

insert into emergency_vehicle values
('veh00004','EMRGNCEE','City Police Department','Dodge','Charger');

select * from emergency_vehicle;


drop table shelter;

create table shelter(
shelter_ID varchar2(8) primary key,
shelter_location varchar2(100),
shelter_description varchar2(50),
);

insert into shelter values
('she00001','1660 Main Street','This is the General hospital for the city');

insert into shelter values
('she00002',’100 Wayne Drive’,’Red Cross location #808’);

insert into shelter values
('she00003',’3000 Jefferson Place’,’Red Cross shelter #321’);

select * from shelter;


drop table first_responders;

create table first_responders(
first_responder_ID varchar2(8) primary key,
first_responder_name varchar2(50),
first_responder_function varchar2(50),
);

insert into first_responders values
('FRP00001',’Jack Smith’,’EMT’);

insert into first_responders values
('FRP00002',’Officer Kimble’,’Police Officer’);

insert into first_responders values
('FRP00003',’John Matthews’,’Firemen’);

select * from first_responder;