Applied Databases

[Project assessment for Applied Databases Module - GMIT 2020]

The project has the following features:

• MySQL-Queries: 5 MySQL queries in a .txt format.
• Mongo-Queries: 4 MongoDB queries in a .txt format.
• PostgreSQL-Queries: PostgreSQL queries in a .sql format.
• PythonApp: interaction with MySQL and MongoDB databases.
• Normalisation: .doc file containing analysis of an employee database and my evaluation of its design.

Submitted by: Olga Rozhdestvina (Student No: G00387844)

Lecturer: Gerard Harrison

---

Set up

Applications used for completion of the project are Visual Studio Code, cmder, MySQL Workbench

Distribution of the Python used is Anaconda Python distribution.

Libraries used for the PythonApp are: PyMySQL, PyMongo. All of these are installed with the Anaconda Python distribution.

---

How to run the Python App

1. Download or clone current repository "Applied-Databases"
2. Open Command Interpreter
3. Get into correct directory
4. Run python code by typing python project.py

---

License

This project is licensed under the MIT License - see the LICENSE.md file for details

---

Acknowledgment

• GMIT lecturer Gerard Harrison
• educative