The Orchestra Management System (OMS) is a full-stack web application used to manage the various musicians, performances, venues, programs, and sheet music of an imagainery orchestra that travels the United States. The relationships between these entitites is described below in the schema diagram.
- React
- Node.js
- Express
- MySQL Workbench
- MariaDB
- Languages: JavaScript, SQL, HTML, CSS
The OMS utilizes React on the frontend to offer seamless integration with a Maria database on the backend. The application utilizes Node.js and Express to integrate the frontend and the backend. The user will interact with the GUI and be able to perform full CRUD operations on the musician entity. All other entities have create and read functionality, but no update or delete. All CRUD operations were written in SQL to correctly query the database.