CJSF 90.1 FM — Database Management System

CMPT 354 Phase 3 | Group 51 | Simon Fraser University

A web-based database management system for CJSF 90.1 FM built with Python Flask and MySQL, developed in collaboration with the station as a service-learning project.

---

Tech Stack

• Python 3, Flask
• MySQL 8.0
• Bootstrap 5, Jinja2

---

Setup

1. Install dependencies

pip3 install flask mysql-connector-python

2. Load the database

mysql -u root -p
source /path/to/sqldump.sql

3. Update credentials in app.py

DB_CONFIG = {
    'host': 'localhost',
    'user': 'root',
    'password': 'your_password_here',
    'database': 'cjsf'
}

4. Run

python3 app.py

Open http://127.0.0.1:5000

---

Pages & Queries

Page	Queries
/members	Q6 Update, Q7 Selection, Q10 Nested
/shows	Q2 Division, Q4 Group-By, Q8 Selection, Q9 Nested
/playsheets	Q1 Join, Q5 Cascading Delete
/donations	Q3 Aggregation, Trigger demo

---

Industrial Partner: CJSF 90.1 FM, SFU