DATA SYSTEMS

Date

2018

TOOLS USED

SQL| Cassandra | MongoDB | MySQL

Below are some assignments from a Design and Analysis of Databases Systems class. The objective of each assignment is captioned.

SQL

In this project, a warehouse was created and populated using scripts provided. This data was then used to run analytical queries and answer some questions about results.

MongoDB

Project provided hands-on practice working with the MongoDB "NoSQL" database software.

Cassandra

Project provided hands-on practice working with the Cassandra "NoSQL" database software.

Database Normalization

Created 3rd Normal Form Schemas that show entities, attributes, and primary keys for data appearing in provided business documents.

Data Modeling

Assignment provided hands-on practice in working with MySQL Workbench to create a key-based, fully attributed, third normal form data model.

Data Warehouse

In this assignment, a warehouse was created and populated using scripts provided. This data was then used to run analytical queries and answer some questions about results.