COSC 416 - Special Topics in Databases
Assignment 1 -  Relational Databases

Each assignment you will build a simple application that uses a database. Every assignment will use the same web interface but change the database system that supplies the data.

Assignments may be done in groups of 2 or 3.

The domain that we will model is a Game Center system that stores information on games, players, and their achievements and high scores. A domain description:

Use MySQL to host your database. The database should be on cs-suse-5.ok.ubc.ca (note it is cs-suse-5 not cs-suse-4!).

Task #1 (20 marks) - Create your Database

Create a SQL DDL script that contains CREATE TABLE statements and INSERT statements to populate the database. The database requires at least 5 games, 5 players, and 10 achievements. A player does not have to play all games and may not have an achievement in a game. Add some player scores and achievements. You must upload some form of profile picture for each player.

Bonus: (10 marks) Create a generator program (preferably in Java) that can generate a DDL script, CSV files, or automatically creates the database from code that can have a customizable number of games, achievements, and players.

Task #2 (80 marks) - Create your Web Interface

The web interface will allow easy browsing of games, players, achievements, and scores. You can build the interface in any language you wish (JSP recommended). You can host on cs-suse-5.ok.ubc.ca or your own site. We will be using this web interface throughout the course, so you will want to design and build it for easy maintenance and modification.

Web Site Requirements

Bonus: (up to 30 marks)

Submission

Submit all code and files using Connect. You can demonstrate your web site at any time for feedback and marking.


*Home