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