1CREATE DATABASE numismatics; 2CREATE TABLE coin (cid INT(8) PRIMARY KEY, 3 unit VARCHAR(20), 4 value NUMERIC(8,2), 5 mintage_year INT(8), 6 mint_id INT(8), 7 CONSTRAINT mint_id_fk FOREIGN KEY(id) 8 REFERENCES mint(mid)); 9 10CREATE TABLE mint (mid INT(8) PRIMARY KEY, 11 country VARCHAR(20), 12 city VARCHAR(20)); --+ DBTYPE = HASH 13 14