none
Purchase History Schema RRS feed

  • Question

  • Hello everyone. I thought this would be an easy endeavor, but now I'm not so sure. What I am trying to do is create a personal database to keep track of all of my digital content purchases, specifically iTunes.  The way I see it, I need two tables - one for Orders, and one for Order details.  Here are my two tables:

    OrderID (pk)                                ItemID(fk)

    ItemID(pk)                                  ItemDetail

    Item                                            ItemType

    Artist

    Type

    Price

    So, am I oversimplifying this? 

    Here's the way that iTunes lays out their purchase history data:

     Thanks everyone for looking at this.

    Robert

    Tuesday, March 15, 2016 1:14 PM

Answers

  • Artist should be ArtistID from the Artists table. Over time you may record much more there than just the Artist name.

    Type would be TypeID from the Types table.

    Also make sure you set most fields to Required, and that you create an enforced relation between the two tables.

    Don't forget PurchaseDate. Also TaxAmount or TaxPercent.


    -Tom. Microsoft Access MVP

    • Marked as answer by greenthnkr Tuesday, March 15, 2016 4:46 PM
    Tuesday, March 15, 2016 2:22 PM

All replies

  • Artist should be ArtistID from the Artists table. Over time you may record much more there than just the Artist name.

    Type would be TypeID from the Types table.

    Also make sure you set most fields to Required, and that you create an enforced relation between the two tables.

    Don't forget PurchaseDate. Also TaxAmount or TaxPercent.


    -Tom. Microsoft Access MVP

    • Marked as answer by greenthnkr Tuesday, March 15, 2016 4:46 PM
    Tuesday, March 15, 2016 2:22 PM
  • Thanks Tom :)

    Robert

    Tuesday, March 15, 2016 4:42 PM