To understand how data modelling works, this repo covers designing the basic relational database schema in Python.
Chinook Data [accessed on 02-June-2023]
This data source provides the csv files for all the tables in our database which can be used to read the data and populate the database. The following ER Diagram is helpful in developing the tables and defining the relations between them.
Google Colab for Python and SQLite databases were used for this task.
data_modelling_basics.py contains the Python code for creating the database, creating the tables, establishing relationships between them and inserting the data from csv files into the database.
After the successful creation of SQLite database, the ER diagram of the database can be made using MySQL Workbench. The step by step guide is illustrated in this Guide. The following diagram is obtained which matches our original model from the beginning thus the schema is built correctly.
