Question

Create data tables within MySQL based on this diagram. Use all the entities and relationships described in that question. Choose Primary keys and foreign keys minutely. There should be a table called ocean, strait, continent, and island then followed by 3 relationship tables: connected_to, separated_by, and located_in. A total of 7. Add a couple values too

name area name area bodies of water land mass connected isa isa many to many continent island ocean strait separated many to 1 many to 1 located

Answer 1

OCEAN TABLE :

CREATE TABLE IF NOT EXISTS OCEAN (

name varchar(100),

area varchar(100),

isa varchar(100),

located varchar(100),

Primary Key (isa)

)

STRAIT TABLE :

CREATE TABLE IF NOT EXISTS STRAIT (

name varchar(100),

area varchar(100),

isa varchar(100),

located varchar(100),

separated varchar(100),

Foriegn Key (isa) References OCEAN(isa)

)

CONTINENT TABLE :

CREATE TABLE IF NOT EXISTS CONTINENT (

name varchar(100),

area varchar(100),

isa varchar(100),

located varchar(100),

separated varchar(100),

Primary Key (isa)

)

ISLAND TABLE :

CREATE TABLE IF NOT EXISTS ISLAND (

name varchar(100),

area varchar(100),

isa varchar(100),

located varchar(100),

separated varchar(100),

Foriegn Key (isa) References CONTINENT (isa)

)