Orchestra Database Project

Description

Project for my Fall 2014 Databases course. Created a simple orchestra database with mySQL and the Play framework.

Presentation Link

On Slid.es

Website Link

Website

Website hosted with Heroku, database hosted using ClearDB.

Note: Some triggers/functions don't work on the website due to MySQL limitiations with ClearDB free tier.

Project Checklist

• User Views
• Normalization
• ER Diagram
• Table DDL: At least 7 - Seen in Evolution script.
• View DDL: At least 1 - Seen in app/views
• Procedures DDL: At least 1 - Seen in app/controllers
• Function DDL: At least 1 - Seen in assets/trigger.sql
• Trigger DDL: At least 1 - Seen in assets/trigger.sql
• DML Statements driven by user forms
• Simple user forms
• Simple reports
• Integrity Enforcement: Not Null and restrictions on delete/update of Players table.
• Isolation Level: Repeatable read.

TODO

• Host website
• Upload Database