"(New data types)
You are going to create two new tables to be housed in the USERS01 tablespace.
The first table name will be METALS and will be used to store a description of various metals. The following offers some additional direction on how the table should be created.
* The table shall have a primary key called METALS_ID.
* An inline primary key constraint shall be defined. The constraint name shall be METALS_ID_PK shall be used.
* An addition column of METAL_DESCRIPTION shall be added to the table definition.
* A unique constraint on METAL_DESCRIPTION shall be added to the table definition. The constraint name shall be METAL_DESC_UK shall be used.
The PRECIOUS_METAL_PRICE table will be used to store a history of the price of various precious metals. The following offers some additional direction on how the table should be created.
* The table has a four-byte primary key ID number (METAL_ID) and a description of the metal.
* The PRICE column shall store fractions of a penny down to 3 decimal places, but the whole price will always be under 1000 dollars.
* The TIME_BETWEEN column will store the number of days (up to 99 days), hours, minutes, and seconds (to the hundredth of a second) between the current record and the previous record. Alternatively, select an appropriate alternate datatype that records date and time.
* The table shall have a inline foreign key relationship back to a parent table named METALS, which lists various precious metals like Gold, Silver, Zinc, etc. The foreign key constraint shall be named METALS_PRICE_FK.