F4LWBHP7

1CREATE DATABASE IF NOT EXISTS assignment2;
2USE assignment2;
3
4CREATE TABLE continents (
5	cont_name VARCHAR(20) NOT NULL PRIMARY KEY, 
6    cont_area VARCHAR(20) NOT NULL
7);
8
9CREATE TABLE islands (
10	island_name VARCHAR(20) NOT NULL PRIMARY KEY, 
11    island_area VARCHAR(20) NOT NULL
12);
13
14CREATE TABLE oceans (
15	ocean_name VARCHAR(20) NOT NULL PRIMARY KEY, 
16    ocean_area VARCHAR(20) NOT NULL
17);
18
19CREATE TABLE straits (
20	strait_name VARCHAR(20) NOT NULL PRIMARY KEY, 
21    strait_area VARCHAR(20) NOT NULL
22);
23/*
24CREATE TABLE connected_to (
25	cont_name VARCHAR(20) NOT NULL PRIMARY KEY, 
26    cont_area VARCHAR(20) NOT NULL
27);
28
29CREATE TABLE seperated (
30	cont_name VARCHAR(20) NOT NULL PRIMARY KEY, 
31    cont_area VARCHAR(20) NOT NULL
32);
33
34CREATE TABLE located_in (
35	cont_name VARCHAR(20) NOT NULL PRIMARY KEY, 
36    cont_area VARCHAR(20) NOT NULL
37);
38*/
39
40
41INSERT INTO continents
42VALUES 
43	('Africa', '11,730,000 sq miles'),
44    ('Antartica', '5,400,000 sq miles'),
45    ('Asia', '17,212,000 sq miles'),
46    ('Europe', '3,930,000 sq miles'),
47    ('North America', '9,540,000 sq miles'),
48    ('Australia', '3,300,000 sq miles'),
49    ('South America', '6,890,000 sq miles');
50
51INSERT INTO oceans 
52VALUES
53	('Atlantic', '41,100,000 sq miles'),
54    ('Artic', '5,427,000 sq miles'),
55    ('Southern', '7,849,000 sq miles'),
56    ('Indian', '27,240,000 sq miles'),
57    ('Pacific', '63,800,000 sq miles');
58
59INSERT INTO islands
60VALUES 
61	/* African Islands */
62	('Addilo Island', '25,000 sq miles'),
63    ('Bandarka Island', '32,300 sq miles'),
64    ('Bangadini Island', '30,700 sq miles'),
65    ('Bavadi Island', '42,500 sq miles'),
66    ('Turtle Island', '23,400 sq miles'),
67    /* Anartica Islands */
68	('Amherst Island', '24,300 sq miles'),
69    ('Davis Island', '18,400 sq miles'),
70    ('Frenchs Island', '30,000 sq miles'),
71    ('Green Island', '15,500 sq miles'),
72    ('Rose Island', '29,100 sq miles'),
73    /* Asian Islands */
74	('Kamley Island', ' 10,500 sq miles'),
75    ('Okushiri Island', '8,300 sq miles'),
76    ('Teuri Island', '5,200 sq miles'),
77    ('Kamome Island', '2,200 sq miles'),
78    ('Rebun Island', '8,400 sq miles'),
79    /* European Islands */
80	('Satava Island', '1,000 sq miles'),
81    ('Nagu Island', '3,200 sq miles'),
82    ('Jurmo Island', '1,800 sq miles'),
83    ('Kataja Island', '4,400 sq miles'),
84    ('Pellinki Island', '2,800 sq miles'),
85    /* North American Islands */
86	('Adams Island', '800 sq miles'),
87    ('Brock Island', '550 sq miles'),
88    ('Lougheed Island', '3,200 sq miles'),
89    ('Cornwall Island', '650 sq miles'),
90    ('Massey Island', '200 sq miles'),
91    /* Australian Islands */
92	('Tasmania Island', '25,000 sq miles'),
93    ('Melville Island', '2,200 sq miles'),
94    ('Kangaroo Island', '1,700 sq miles'),
95    ('Groote Island', '2,200 sq miles'),
96    ('King Island', '1,000 sq miles'),
97    /* South American Islands */
98	('Bermejo Island', '850 sq miles'),
99    ('San Martin Island', '1,200 sq miles'),
100    ('Cerrito Island', '900 sq miles'),
101    ('Martin Garcia Island', '400 sq miles'),
102    ('Victoria Island', '950 sq miles');
103
104INSERT INTO straits
105VALUES 
106	/* Between Adams Island and Brock Island North American Strait */
107	('Formosa Strait', '80 miles'),
108    /* Between South America and Antartica Strait*/
109	('Drake Passage', '800 miles'),
110    /* Between North America and Asia Strait*/
111	('Bering Strait', '50  miles'),
112    /* Between Europe and Asia Strait */
113	('Dardanelles Strait', '38 miles'),
114    /* Between Satava and Nagu Islands European Strait */
115	('Kvarken Strait', '120 miles'),
116    /* Between Tasmania and Kangaroo Island Australian Strait */
117	('Torres Strait', '35 miles'),
118    /* Between Antartica and Australia Strait */
119	('Bass Strait', '200 miles');