A Guide to the Entity Relationship Diagram (ERD)

by Ben | Jul 31, 2019

Learn all about Entity Relationship Diagrams (ERDs), what they are used for, how to understand them, how to create them, and more in this guide. What is an Entity Relationship Diagram (ERD)? An Entity Relationship Diagram (ERD) is a type of diagram that lets you see... Read more

24 Database Design Mistakes and How to Avoid Them

by Ben | Aug 18, 2018

Creating a database is easy. Designing an effective database, the right way, using good practices, is hard. In this article, I’ve listed 24 different database design mistakes that you should try to avoid. Mistake 1: Ignoring the Purpose or Frequency of the Data When... Read more

Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)

by Ben | Jul 10, 2018

Natural key, surrogate key, composite key. What do these terms mean? And why should you know what they are? In this article, you’ll learn what these terms are, so you can communicate better with other developers and understand other online tutorials that use these... Read more

Database Normalization: A Step-By-Step-Guide With Examples

by Ben | Sep 30, 2017

Database normalisation is a concept that can be hard to understand. But it doesn’t have to be. In this article, I’ll explain what normalisation in a DBMS is and how to do it, in simple terms. By the end of the article, you’ll know all about it and how to do it. So... Read more

Singular vs Plural and Other Database Table Naming Conventions

by Ben | Jan 2, 2017

Are you wondering if you should name your Oracle database tables in the singular form or plural form? Learn what the preferred convention is and some reasoning behind it, as well as other database table naming conventions, in this article. Why Do We Need SQL Table... Read more