This is a repository of Postgres PL/pgSQL code that I have written for various projects during my time at North Dakota State University. I believe that these project are great examples of my journey and show the growth in my knowledge over the course of my exposure to database systems between 2019 and 2021.
- Attendance System:
Written in 2021, this project was created for the Human Computer Interaction course at North Dakota State University. The purpose of this project was to create a phsyical, touchless system that allowed students to take their attendance utilizing a student ID and a microcomputer/RFID reader stationed in each classroom. Additionally, this attendance system would allow for the automation of contact tracing during the Covid-19 pandemic.
- Knowledge Base:
Written in 2020, this project was created for the Software Projects Capstone course at North Dakota State University. The purpose of this project was to create a Knowledge Base where the business could connect questions and subquestions in order to accelerate their response time to commonly asked questions.
- Repair Shop:
Written in 2019, this project was created for the Database Systems course at North Dakota State University. The purpose of this project was to create a simple database and reports for the display of data on a mock website.