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