drop table Outcomes;
drop table Battles;
drop table Ships;
drop table Classes;

create table Classes
(
	class varchar(15),
	type varchar(3),
	country varchar(20),
	numGuns number,
	bore number,
	displacement number
);

insert into Classes values ( 'Bismark','bb','Germany',8,15,42000) ;
insert into Classes values ( 'Iowa','bb','USA',9,16,46000);
insert into Classes values ( 'Kongo','bc','Japan',8,14,32000);
insert into Classes values ( 'North Carolina','bb','USA',9,16,37000);
insert into Classes values ( 'Renown','bc','Gt. Britain',6,15,32000);
insert into Classes values ( 'Revenge','bb','Gt. Britain',8,15,29000);
insert into Classes values ( 'Tennessee','bb','USA',12,14,32000);
insert into Classes values ( 'Yamato','bb','Japan',9,18,65000);


create table Ships
(
	name varchar(20),
	class varchar(15),
	launched number
);

insert into Ships values ( 'California','Tennessee',1921);
insert into Ships values ( 'Haruna','Kongo',1915);
insert into Ships values ( 'Hiei','Kongo',1914);
insert into Ships values ( 'Iowa','Iowa',1943);
insert into Ships values ( 'Kirishima','Kongo',1915);
insert into Ships values ( 'Kongo','Kongo',1913);
insert into Ships values ( 'Missuri','Iowa',1944);
insert into Ships values ( 'Musashi','Yamato',1942);
insert into Ships values ( 'New Jersey','Iowa',1943);
insert into Ships values ( 'North Carolina','North Carolina',1941);
insert into Ships values ( 'Ramillies','Revenge',1917);
insert into Ships values ( 'Renown','Renown',1916);
insert into Ships values ( 'Repulse','Renown',1916);
insert into Ships values ( 'Resolution','Revenge',1916);
insert into Ships values ( 'Revenge','Revenge',1916);
insert into Ships values ( 'Royal Oak','Revenge',1916);
insert into Ships values ( 'Royal Sovereign','Revenge',1916);
insert into Ships values ( 'Tennesse','Tennesse',1920);
insert into Ships values ( 'Washington','North Carolina',1941);
insert into Ships values ( 'Wisconsin','Iowa',1944);
insert into Ships values ( 'Yamato','Yamato',1941);


create table Battles
(
	name varchar(15),
	bdate varchar(15)
);

insert into Battles values ( 'Denmark Strait','5/24-27/41');
insert into Battles values ( 'Guadalcanal','11/15/42');
insert into Battles values ( 'North Cape','12/26/43');
insert into Battles values ( 'Suriago Strait','10/25/44');

create table Outcomes
(
	ship varchar(20),
	battle varchar(15),
	result varchar(15)
);

insert into Outcomes values ( 'Arizona','Pearl Harbour','sunk');
insert into Outcomes values ( 'Bismark','Denmark Strait','sunk');
insert into Outcomes values ( 'California','Surigao Strait','ok');
insert into Outcomes values ( 'Duke of York','North Cape','ok');
insert into Outcomes values ( 'Fuso','Surigao Strait','sunk');
insert into Outcomes values ( 'Hood','Denmark Strait','sunk');
insert into Outcomes values ( 'King George V','Denmark Strait','ok');
insert into Outcomes values ( 'Kirishima','Guadalcanal','sunk');
insert into Outcomes values ( 'Prince of Wales','Denmark Strait','damaged');
insert into Outcomes values ( 'Rodney','Denmark Strait','ok');
insert into Outcomes values ( 'Scharnhorst','North Cape','sunk');
insert into Outcomes values ( 'South of Dakota','Guadalcanal','damaged');
insert into Outcomes values ( 'Tennessee','Surigao Strait','ok');
insert into Outcomes values ( 'Washington','Guadalcanal','ok');
insert into Outcomes values ( 'West Wirginia','Surigao Strait','ok');
insert into Outcomes values ( 'Yamashiro','Surigao Strait','sunk');

commit; 

select * from Classes;
select * from Ships;
select * from Battles;
select * from Outcomes;

grant select on Classes to public;
grant select on Ships to public;
grant select on Battles to public;
grant select on Outcomes to public;