A coin enthusiast has heard you are taking a database course and has asked you to help her design a database to manage her collection.

Currently she tracks all of her coins in a Microsoft Excel Spreadsheet which has the following column headings.

Coin ID, Category, Type, Variation, Date, Mint, Grade, Grade Remarks, Grader, Holder, Value, Composition, Year Purchased, Place Purchased, Price Paid, Remarks, Status

She doesn't collect any one type of coin but instead collects many different types and varieties. She has recommended taking a look at the following website (www.pcgs.com/prices/) to better understand the data she is trying to manage and has provided a small set of example data below.

Sample of the data is:

Coin ID: BHLC-1846-001, BHLC-1847-001

Category: Large Cent, Small Cent, Two Cent, Three Cent, Nickel, etc.

Type: Liberty Head, Flying Eagle, Indian Head, etc.

Variation: Braided Hair - Small Date, Braided Hair, Flying Eagle, Indian Head Variety 1, Indian Head Variety 2, Indian Head Variety 3, etc.

Date: 1846, 1847, etc.

Mint: O, CC, S, P, D, W, etc.

Grade: F, VF, EF, G, VG, AU, MS, PR

Grade Remarks: user entered comments

Grader: PCGS, NGC, ANACS, Self, etc.

Holder: Collector Safe Slab, NGC 123456-123, PCGS 2232.35/12345678, ANACS 123456

Value: $ Amount

Composition: 10.89 grams of copper - 27.5mm

Year Purchased: 2009, 2010, 2011, etc.

Place Purchased: Mint, eBay,

Price Paid: $ Amount

Remarks: User entered comments about purchase

Status: In Stock, Planned Purchase, Overstock Sell, Certify

Step 1: What are the themes involved in this dataset? Identify each theme and the attributes which are related to each of the themes you have identified.

Step 2: What are the relationships between the entities?