Database for Online Auction Website

The final project for my Database I class at UNC-CH SILS required me to build an SQLite database for an online auction website.

ClientUNC-CH SILS Database I class
DateDecember 2014
Category

Challenge:

  • Create an SQLite database for an online auction website including the following:
    • Narrative of system specifications and design
    • Entity-relationship¬†diagram
    • Schema mapping diagram
    • Data dictionary
    • SQL used to create all tables
    • 10 queries that demonstrate how users might search for data

Database documentation: bfagge-dbasedocumentation.pdf
Database: bfagge-dbase.sqlite.zip

Image of an entity-relationship diagram for an online auction database