Family Database Project
Fall 2017 - CSCI 334: Database Concepts
For this course, we worked on a project of our choice for the duration of the semester. Our only restrictions were that we needed to use a MySQL database hosted through SiteGround.com, learn SQL to query the database, and use PHP on the client side to make the calls.
I was inspired by a group of friends I made over the summer during the Google Scholar's retreat. Five of us began talking about how we would like to build an application that would help children and parents of children with Autism Spectrum Disorder. The application would provide a free way for parents to create communities and also allow them to monitor their child's progress - the website would also have useful games or apps for the kids to play with.
This project, although it will probably never be used, is built around that idea. Users can create accounts and then declare whether they are parents or children. They can then add information to their accounts, edit their information, build a user profile, and send messages. I built the app with the intention of it being a mobile responsive web app since users would most likely be using the app from small devices.
Screenshots of the Web App
Initial Design
Languages
Tools Used
Entity Relationship Diagram
Presentation Slides
This entire project (SQL included) is up on my Github if you would like to download and modify it!