Oracle Help: Grad School
#1
Oracle Help: Grad School
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.
![](http://desmond.imageshack.us/Himg7/scaled.php?server=7&filename=dynamicenies.png&res=medium)
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;
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://desmond.imageshack.us/Himg7/scaled.php?server=7&filename=dynamicenies.png&res=medium)
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;
#2
The sizzle in the Steak
![](http://i51.tinypic.com/333fk47.jpg)
What can I help you with?
Thread
Thread Starter
Forum
Replies
Last Post
cycdaniel
1G TSX Performance Parts & Modifications
8
12-17-2019 10:58 AM