CREATE $\_\_($A$)\_\_$ Tablespace$1$

ADD DATAFILE

$\text{'}$E:$/$mysql$/$geography$/$tablespace$1.$ibd'

CREATE TABLESPACE Tablespace$2$

$\_\_($B$)\_\_$

$\text{'}$E:$/$mysql$/$geography$/$tablespace$2.$ibd'

CREATE TABLE Country $($

Code SMALLINT,

Name VARCHAR$(15),$

Capital VARCHAR$(15)$

$)$

TABLESPACE $\_\_($C$)\_\_$;

CREATE TABLE Continent $($

Code CHAR$(2),$

Name VARCHAR$(15),$

$)$

TABLESPACE Tablespace$2$;Continent and Country are large tables frequently updated, and therefore assigned to different tablespaces.