CSCI 440 - Database Systems

This is the base upstream repository for CSCI 440: Database Systems

It contains the homework assignments, as well as the class project information.

Getting Your Private Copy

Please use the following steps to create a private copy of this repo for your work:

• Create a private repository in your own account by
  • Going to https://github.com/new
  • Enter the name csci-440-fall2021-private
  • Select Private
  • Navigate to the Settings -> Manage Access section
  • Add 1cg as a collaborator
• Now run the following git commands, substituting your Github user name and NetID where required:

$ git clone https://github.com/msu/csci-440-fall2021.git csci-440-fall2021-private
$ cd csci-440-fall2021-private
$ git remote set-url origin git@github.com:<YOUR GITHUB USER NAME>/csci-440-fall2021-private.git
$ git remote add upstream https://github.com/msu/csci-440-fall2021.git

Whew!

You now have a private copy of the repository on github. You can push and pull to this repository and branch with the standard git pull and git push commands.

When you want to get an update from the public class repository you can run this command:

$ git pull upstream master

Homeworks

Homeworks can be found in the src/test/java/edu/montana/csci/csci440/homework directory and are given in the form of Tests.

Project: Chinook Web App

You will be implementing a web application against a SQL store, found in /db/chinook.db

The web application will be an open-ended project, but must include the following:

• All entities in the chinookdb must be surfaced in the web application
• The Employee entity must have all CRUD operations surfaced
• A tree UI of the Employee hierarchy
• Track search with at least two inputs must be implemented
• At least one report-like page must exist that makes use of a GROUP BY clause
• Implement at least one Redis cache

Project Rubric

The project will be largely graded via automated tests. The grading will be broken down along the following lines:

• 75.4% - The automated test suite (if the test suite passes, you are guaranteed to get a C on the project)
• 15% - A recorded demo, demonstrating the following functionality
  • Navigating the core entities in the database
  • CRUD operations on the Employee entity
  • Track search
  • Paging implemented in the Track main view
  • A Group By based report page
• 10% - Code quality and satisfaction of the Redis cache, determined by manual inspection
• .1% - At least one use of htmx (https://htmx.org) in the application to add dynamic AJAX behavior

Project Resources

• Spark Java Docs
• Velocity Templates Docs
• Active JDBC Docs