1CREATE DATABASE numismatics; 2 3CREATE DATABASE numismatics; 4 5CREATE TABLE coin (cid INT(8) PRIMARY KEY, 6 unit VARCHAR(20), 7 value NUMERIC(8,2), -- just a comment here; 8 mintage_year INT(8), 9 mint_id INT(8), 10 CONSTRAINT mint_id_fk FOREIGN KEY(mint_id) 11 REFERENCES mint(mid)); 12