Rainbow High School Yearbook Team's Database Website

Rainbow High School is a hypothetical high school whose yearbook team is responsible of tracking over 10,000 students as well as various clubs, sports, and events. This website helps the yearbook team interface with their database made up of 5 tables (Students, Graduating Classes, Clubs, Sports, Events) and 3 intersection tables to keep track of students' participation in clubs, sports, and events. Furthermore, the database allows the yearbook team to note which page numbers students appear on so it is easier to cite where they appear at the end end of the yearbook.

Access the website here: https://rainbow-hs-database-website-1z65.onrender.com

Important

I am using a free hosting plan, so the application may take awhile to load. Thank you for your patience!

Technologies Used

Website

• MySQL
• Node.js
• Express.js
• Handlebars.js

Hosting

• Render
• AWS

Database Details

DB Entity-Relationship Diagram

DB Schema

Code Citations

Citation for Handlebars and Express setup

• Date: 08/01/2024
• Adapted from CS340 2024 Summer Term Node.js starter code step 3
• Source URL: https://github.com/osu-cs340-ecampus/nodejs-starter-app

Citation for dynamic data display on all pages (READ)

• Date: 08/01/2024
• Adapted from CS340 2024 Summer Term Node.js starter code step 4
• Source URL: https://github.com/osu-cs340-ecampus/nodejs-starter-app

Citation for inserting new data on all pages (CREATE)

• Date: 08/04/2024
• Adapted from CS340 2024 Summer Term Node.js starter code step 5
• Source URL: https://github.com/osu-cs340-ecampus/nodejs-starter-app

Citation for dynamic dropdowns on Students, Club Memberships, Sport Memberships, Event Memberships pages

• Date: 08/04/2024
• Adapted from CS340 2024 Summer Term Node.js starter code step 6
• Source URL: https://github.com/osu-cs340-ecampus/nodejs-starter-app

Citation for deleting data on all pages (DELETE)

• Date: 08/10/2024
• Adapted from CS340 2024 Summer Term Node.js starter code step 7
• Source URL: https://github.com/osu-cs340-ecampus/nodejs-starter-app

Citation for updating Students and Sport Memberships data (UPDATE)

• Date: 08/09/2024
• Adapted from CS340 2024 Summer Term Node.js starter code step 8
• Source URL: https://github.com/osu-cs340-ecampus/nodejs-starter-app