I need to create a table by hand here is what I have so far.

ID int, CoinType char(2), Date Date, MintMark char(2), Value Decimal(6,2), Condition char(2), AppraisalDate Date );

but I need to also put into the table the following

The mint marks are either D (Denver), P (Philadelphia), S (San Francisco), O (New Orleans), CC (Carson City). Allow only these abbreviations. (HINT: Use in IN statement)

Conditions are PR(Proof), BU (Brilliant Un-circulated), UC (Un-circulated), VF (Very Fine), (F)Fine, G (Good), P (Poor). Allow only these conditions.

Only P, N, D, Q, H1, 1 should be allowed as coin types.

Decide what should be filled when a record is added (nulls).

The greatest portion of my collection is in pennies. Default the data type to a penny.

Decide on an appropriate Primary key.