s

An overview of a project for the Applied Database module



A Python application that performs CRUD on relational and non-relational databases

MySQL logo  MongoDB

  This post contains some reference notes for using both relational and non-relational databases as well as an overview of a project completed for the Applied Databases module as part of the Higher Diploma in Data Analytics at GMIT.

  • MySQL is a relational database management system. Queries are written in the SQL language.
  • MongoDb is a document database used for non-structured data. MongoDB is based on JSON.

The applied databases module provided a primer on databases with a focus on data analysis; CRUD ( Creation, Retrieval, Update and Deletion) of both structured and unstructured data for a number of modern database systems and architectures; Topics on Relational databases, NoSQL databases, databases interfaces and database logic.

The project for the Applied databases module had 4 different sections.

  1. Working with a relational database using MySQL.
    Import the world.sql database and then write queries to satisfy some questions.

 

  1. Working with a non-relational ‘student / courses’ database using MongoDB
    Writing some queries to satisfy some questions on a student / courses database

 

  1. Writing a Python application that allows a user perform CRUD operations on both relational and non-relational databases. The application consists of a main menu with an interface to a MySQL database and a MongoDB database.

  2. Normalisation: Examining a relational database to see whether it is considered a good or bad design. A discussion on the design of a sample database.


MySQL: Some notes on Relational Databases

  • Some notes on using MySQL
    MySQL is a database management system. Some notes on using MySQL using either the MySQLWorkbench application or using the command line interface. An overview and some examples of queries.

  • Relational database tables
    An overview of relational databases, SQL, MySQL and common queries.

MongoDB: Some notes on Non-Relational Databases


Applied Database screenshot

Tech used:
  • MySQL
  • MongoDb
  • Python
  • MySQLWorkbench
  • pymysql