Database_Management_Projects

Contributors: Cameron Stewart

The projects in this repository purely academic and were used to explore tools used for Database Management.

---

Table of Contents

• Mini Project 1 - Design Entity Relationship Model
• Mini Project 2 - Simple SQL Query Practice
• Mini Project 3 - Complex SQL Query Practice
• Mini Project 4 - Managing NoSQL Database
• References

---

Mini Project 1 - Design Entity Relationship Model

Project Prompt:

Mini Project 1 Solution:

Back to Top

---

Mini Project 2 - Simple SQL Query Practice

Mini Project 2

This project uses SQL to query a MySQL Database. Project shows the request, the query, and the output. Raw data for database listed in project folder.

Back to Top

---

Mini Project 3 - Complex SQL Query Practice

Mini Project 3

This project uses SQL to query a MySQL Database. Project shows the request, the query, and the output. Raw data for database listed in project folder.

Back to Top

---

Mini Project 4 - Managing NoSQL Database

Mini Project 4

This project uses MongoDB and Compass to connect to a MongoDB Document Database. Project shows the step by step of inserting, updating, and querying the data. Raw data for database listed in project folder.

Back to Top

---

References

Mini Project 1 Solution:

Mini Project 2

Mini Project 3

Mini Project 4

All raw data and project prompts are in the project folders.

Technologies:

MySQL Workbench

SQL

MongoDB

MongoDB Compass

Back to Top