508-fall-semester-project

Repository for semester project for CMSC 508

Repository Structure

In the Documentations folder, you should find our:

1. Phase 1 Deliverables
   1. Problem Statement
   2. ER Diagram
   3. Relational Schemas
   4. Functional Dependencies
   5. Sample Data
   6. Rough Drafts
2. Phase 2 Deliverables
   1. SQL Files
   1. Creation Script
   2. Load Script
   3. Trigger and Procedure Script
   4. View Script
   5. Insert Update Delete Script
   6. Stored Procedure Script - 20 queries made dynamic as procedures to take in dynamic input
   7. 20 Queries Script - 20 queries with input hard coded which were used for testing
   8. Roles and Privileges Script
   2. Front End Code
   1. Scheduler Front End App Components
   3. PHP Server Scripts
   1. PHP scripts connecting front end to the database
   4. Dist Folder - Build Artifact Deployed on the EC2 Server
   1. artifacts and read me to deploy on the EC2 server
   5. Evidence of Testing Queries
   6. Creation/Load Scripts in Markdown
   7. Citations
3. Link to EC2 Applicaiton
   1. http://ec2-3-93-50-104.compute-1.amazonaws.com/scheduler/

Team Members

Jesus Guerrero

• email: [email protected]
• GitHub Username: guerreroj3

Sophia Fehrmann

• email: [email protected]
• GitHub Username: sophiafehrmann

Jonathan Fung

• email: [email protected]
• GitHub Username: fungjk2

Hunter Arndorfer

• email: [email protected]
• GitHub Username: arndorferh