I’ve been discussing general information about database/sql development but l’m now going to concentrate on one flavour of SQL called TSQL, microsoft version of SQL. TSQL is used by all microsoft SQL servers, so knowing TSQL in general will allow you to program in all microsoft SQL servers with minimal changes. I’m going to base […]
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 […]