1CREATE DATABASE numismatics;
2CREATE DATABASE numismatics1;
3
4CREATE TABLE coin (cid INT(8) PRIMARY KEY,
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