Hi All, I know there are a few DBA's in here that might be able to help.

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.



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


drop table emergency_vehicle;

create table emergency_vehicle(
emergency_vehicle_ID varchar2(8) primary key,
emergency_vehicle_plate varchar2(8),
emergency_vehicle_registered_owner varchar2(50),
emergency_vehicle_make varchar2(50),
emergency_vehicle_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;

 

What can I help you with?

 

Maybe this will help: http://www.techonthenet.com/oracle/f...reign_keys.php