In this article, we’ll explore the steps of ER modelling for database design. By the end, you will know what database design is and how to create an entity-relationship diagram (ER). In addition, you will also learn how to translate an ER from a case study.
We will be using MySQL for the purposes of this post and connecting it with Python to write CRUD queries– you can use whatever flavor of SQL you are comfortable in (if you’re unsure which to pick, check out our post on How to Pick a SQL Flavor. By the end of this post, you will have found the answer to the question: “How To Write MySQL CRUD Queries In Python”.
A Comparison of SQL Database Flavors: How To Pick The Right SQL Database Flavor For You? SQL, or Structured Query Language, is a database that has widespread uses with many flavors– which we will explore. As such, in our data-driven world, SQL is fast becoming an essential skill. Therefore, in this article, we will look […]
Maintaining a sound understanding of CRUD operations in MySQL, or SQL itself, is one of the most important things you can do as a beginner because this proves fruitful down the road when you have this major concept stored in the back of your heads and don’t get confused on these basic queries that form the foundation of SQL.