CSCI 440 - Database Systems

This is the base upstream repository for CSCI 440. It contains homeworks as well as the class project information.

Getting Your Private Copy (Clone)

Rather than the traditional Forking model, we are going to use a Copy model for the class.

Please use the following steps to create a private version 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-fall2020-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-fall2020.git
$ cd csci-440-fall2020
$ git remote set-url origin git@github.com:<YOUR GITHUB USER NAME>/csci-440-fall2020-private.git
$ git remote add upstream https://github.com/msu/csci-440-fall2020.git

Whew! You now have a private copy of the repository on github and are working in your own branch, named after your NetID. 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

Getting Your Public Copy & Registering (Fork)

Next, please fork this repository to your personal account. You will now have two copies of the project, one public and one private.

The private repository will be used for your work and our grading.

The public repository can be used for contibuting back to the class project. DO NOT PUSH WORK CODE TO THIS REPOSITORY

I highly recommend against cloning the public respoitory to your local system, to avoid confusion between the two. You can edit files in the public repository via the web interface, and that will be much safer.

Please add a file to /repos named

<YOUR NET ID>.txt

with the git URL of your private repository, e.g.

git@github.com:1cg/csci-440-fall2020-private.git

And then create a pull request against this repository.

We will accept the pull request, and your private work repo will be registered for the class at that point.

Homeworks

Each homework has it's own directory (/hwk0, /hwk1, etc.). Please do your work in the homework directory

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
• At least one entity must have all CRUD operations surfaced
• 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

Project Resources

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