24 Database Design Mistakes and How to Avoid Them
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)
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
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
