RR-DB (Raccoon Rhapsody Database)

This is a class project which use SQL programming language to create a Raccoon Rhapsody Database (RR-DB) in DB2 (RDBMS). This project has four parts.

If you do not have DB2 installed in your system, check here

Part 1

Scheming: Loot!

Part 1 Requirements

ERD (entity-relationship diagram) of Loot!

---

Part 2

Voila: The Quest MMORPG DB

Part 2 Requirements

Account & Avatar Sample Data (for purposes of testing schema of Quest Game)

ERD of Quest Game

Quest Data of Quest table
Visit Data of Quest table
Plays Data of Quest table

Create a table of Quest Game (schema)
Add the requested data to Quest Game (data)

Requirement and table result

Query

---

Part 3

SQL Jeopardy: Querying the Raccoon-Rhapsody Database

Part 3 Requirements

Create RR-DB (Raccoon Rhapsody Database), File: rrdb-create

Run below command in Command Line

% db2 -tf rrdb-create

Solve the Queries: Query Questions

1. avies answer table
2. golden answer table
3. twotimer answer table
4. sole answer table
5. seconds answer table
6. swap answer table
7. toppers answer table
8. potential answer table
9. themestat answer table
10. follows answer table

---

Part 4

The Update App: Project Robin Hood

Part 4 Requirements

Q-Donation Q-Donor Q-Recipient

Steal app

Run below command in Command Line

% db2 -td! -f steal