/M_Database

A musical relational database created in SQL. Contents include detailed queries, views, triggers, stored procedures, and a web application to interact with the database.

Primary LanguagePHP

Musical Database by Ashwin Aggarwal

Made during MPCS 53001 Databases at Masters Program of Computer Science at University of Chicago

The Relational Database Repository

  • Serves as an analog to a recommendation algorithm connecting users with different musical talents together -- thus forming bands and duos.
  • Consists of 6 tables.
  • Has numerous queries to manipulate, update, and read the values in the database using various methods like views, stored procedures, and triggers.
  • Works with a web application was created using HTML and PHP in order to interact with the database hosted on the MPCS linux server. The web application code is included and has little styling.
  • Has a python script to randomly generate values for the tables.