1CREATE DATABASE numismatics; /*+ CACHESIZE = 16m */ 2 3CREATE TABLE coin (cid INT(8) PRIMARY KEY, 4 unit VARCHAR(20), 5 value NUMERIC(8,2), -- just a comment here; 6 mintage_year INT(8), 7 mint_id INT(8), 8 CONSTRAINT mint_id_fk FOREIGN KEY(mint_id) 9 REFERENCES mint(mid)); 10 11CREATE TABLE mint (mid INT(8) PRIMARY KEY, 12 country VARCHAR(20), 13 city VARCHAR(20), 14 zip_code INT(8)); --+ DBTYPE = HASH 15 16 17 18CREATE INDEX value_index ON coin(value); 19 20CREATE INDEX mint_id_index ON coin(mint_id); 21 22CREATE INDEX mintage_year_index ON coin(mintage_year); 23 24CREATE INDEX zip_code_index ON mint(zip_code); 25 26/* SELECT * from mint;*/ 27