In this tutorial, l’m going to quickly go over the languages that exist in SQL. SQL stands for Structured Query Language. It is made up of three components, Data Definition Language(DDL), Data Manipulation Language(DML) and Data Control Language(DCL). Let’s take a look at each of these languages and the general statements that fall under it […]
In this tutorial, l’m going to discuss the topic of normalization. normalization is the technique of minimizing redundancy and anomaly in the data. It leads to creation of more tables. There a many normal forms but l’m going to discuss only the first 3 normal forms because they are the most important. To begin with, let’s look at […]
Today, l’m discussing the relation schema. This document comes directly from the Entity Relationship Diagram. However, l don’t think you need an entity relationship diagram to create the relation schema but l think its the approved way of going about the database design. I’m going to use a sample Entity Relation schema l drew for […]
This weeks tutorial is dedicated to one important document in the database design life cycle. This is Entity relationship Diagrams, l’ll refer to it as ERD through out the tutorial. What is an ERD? It is a simple graphical representation of the Entities and relationship that exist among them. It also captures all the attributes […]