Database Setup

Use this page to initialize the database and load sample data.

Warning: This will reset any existing data. Make sure you want to proceed.
Gas Station Database

Initialize the gas station transaction database with the following tables:

  • customers - Customer information and segmentation
  • gasstations - Gas station locations and details
  • products - Product catalog information
  • transactions - Transaction records
  • yearmonth - Monthly consumption data
Student Club Database

Initialize the student club management database with the following tables:

  • major - Academic majors of club members
  • zip_code - Geographic information
  • member - Club member information
  • event - Club events and activities
  • attendance - Event attendance records
  • income - Club income and funding sources
  • budget - Budget allocations for events
  • expense - Expense records for club activities