csc370-project

CSC370 group project: Subtext inventory database

Group members: Alex, David, Jaiya, Nico

HOW TO LOAD DATA INTO YOUR OWN MYSQL DATABASE:

1. Open mySQL
2. Enter the USE DATABASE; Query
3. Load tables.sql: SOURCE /path/to/your/tables.sql;
4. Load sample_data.sql: SOURCE /path/to/your/sample_data.sql;
5. Now the databases has been loaded with tables and data that you can perform SQL Queries on

SCHEMA FILES:

• tables.sql - creates the tables for the database

• sample_data.sql - loads the tables with sample data

SPRINT 4 FILES:

• No SQL Files but ERD updated

SPRINT 3 FILES:

• transaction.sql - created a test transaction

• roles.sql - adding and removing privileges from users

• views.sql - creates a view to show past sales of books

SPRINT 2 FILES:

• complex_queries.sql - used group by and aggregation to sort data