Term Project for the MET CS 669 Database Design and Implementation for Business
This project will be creating a database for a simple RPG (role playing game) like the 1989 video game DragonQuest. The database outlined below would contain all the necessary information about the Hero, Monsters, Skills, and Items that the player could interact with as they play the game. This daatabase is a SQL Postgres database which creates tables, indexes, procedures, and constraints.
Please run the scripts in the following order to create the database:
- create_tables.sql
- procedures.sql
- data_insertion.sql
- history_table_and_trigger.sql
The following scripts are optional to run and return results for various project 'questions' or data visualizations:
- questions.sql
- data_visualizations.sql
General Information:
Monster Data - https://dragonquest.fandom.com/wiki/List_of_monsters_in_Dragon_Quest_Bestiary
Item Data - https://dragonquest.fandom.com/wiki/List_of_items_in_Dragon_Quest
Walkthrough (more monster/location/item data) - https://gamefaqs.gamespot.com/switch/272748-dragon-quest/faqs/78448