Database Systems (CIS-3010) Labs

This document contains a listing of labs for the Database Systems class. Not all of these labs are used every semester. However, they are all presented here for reference.

Introduction to Database Systems. In this lab you connect to the database management system (DBMS) we will be using during the class, and get some experience with the tools we'll be using.
Basic Queries. In this lab you will practice using SELECT to answer various questions about the VariableStars database you prepared in Lab #1.
A PeakBaggers Database. In this lab you will create the first version of a database that allows hikers to track the various mountains they have climbed.
PeakBaggers Queries. In this lab you will populate the PeakBaggers database you created in the previous lab and then do some queries on the data to illustrate JOIN, INSERT, UPDATE, and DELETE queries.
A Temperature Database. In this lab you will create a database for storing temperature data collected by a campus-wide sensor network.
Temperature Data. In this lab you will populate the database you defined in Lab #5 and issue various queries on your data.
Stored Functions. In this lab you will continue to develop the temperature database by using a stored function to implement a complex constraint check on the temperature data.
FoodTracker. In this multi-week lab, you will create a food tracking database.
MongoDB. In this lab you will experiment with the NoSQL system MongoDB. Mongo is an example of a "document oriented" database.