Projects: In this module, I was tasked to create a relational database. Building off of the database exercise in the first level, the following project is meant to better structure larger amounts of data by reducing redundancy and enforcing accuracy through the utilization of keys. In this case, the class roster includes a Student ID that acts as the primary key by connecting other related fields in order make better use of relational data that will be called upon via a search box.
In this instance, I used the previous class roster and mapped out five assignments that would be tied to the unique Student ID. Nesting a form within each individual entry allow for individual scores feedback to be recorded and accessed anonymously by relating to the Student ID and not the actual name of the student. Additionally, attaching a date field to feedback allows the instructor to track the progress and make notes that highlight what to examine once a student re-submits an assignment for grading.
This additional information is housed on a third table, allowing grades and comments to remain anonymous by connecting to the student number and not the actual name. Ragic was used to embed database elements into my website as it utilized WordPress shortcodes. Though the interface is a bit clunky, it does help to keep track of the relationships between tables through drag and drop functionality.
Originally, I wanted to re-visit an idea to integrate a database for housing song requests in the form of a jukebox app. Despite putting together a rather large file that incorporated fields