This course provides balanced coverage of database use and design, focusing on relational databases. Students will learn to design relational schemas, write SQL queries, access a DB programmatically, and perform database administration. Students will gain a working knowledge of the algorithms and data structures used in query evaluation and transaction processing. Students will also learn to apply newer database technologies such as XML, NoSQL, and Hadoop.
In this project, my teammate and I utilized OLTP and OLAP design principles to develop a relational database and data warehouse that represents the master schedule of Sweetwater High School’s 200+ staff members.
We implemented a Python CGI web application with MySQL queries so stakeholders (students, staff, and school visitors) can identify, locate, and contact staff members on campus throughout the day.