Skip to content

CSCI 126 - Databases semester project files: CSV data, and SQL queries

Notifications You must be signed in to change notification settings

nugentmichael1/CSCI126Project

Repository files navigation

CSCI126Project

Run first five lines of SQL file to create appropriate tables.

Import each CSV file into its respective table:

File -> Table

CSCI126ProjectMarket.CSV -> Market

CSCI126ProjectReagents.csv -> Recipe_Reagents

CSCI126ProjectRealms.csv -> Realms

CSCI126ProjectRecipes.csv -> Recipes

CSCI126ProjectItemDescriptions -> Items

Use remaining queries of SQL file to test the database.

Notes: Importation of CSCI126ProjectRealms.csv -> Realms crashed MySQL Workbench. Recommend SQLiteStudio if error encountered.

About

CSCI 126 - Databases semester project files: CSV data, and SQL queries

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published