Database Management (CST 363)
Course Description
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.
Final Project
For my final project I built a database and several Java servlets for a fictitious bookstore. One of the challenges of bookstores these days is how to compete with online sales giants like Amazon Books. Bookstores are still viable, and many of us still enjoy the "adventure" of roaming a bookstore and discovering information and stories that pique our interest and inspire our passions.
However, sometimes finding a specific title in a bookstore can be somewhat challenging. Many stores have an "information desk" where a staff member can query a database and determine if a particular book is in stock. Why not provide this information through a self-service kiosk? This was the intent for the Bookstore project.
​
Database Schema
Learning Objectives
MySql Workbench: https://www.mysql.com/products/workbench/
​