• Normalization is the process of removing redundant data from your tables in order to improve storage efficiency, data integrity and scalibility. This improvement is balanced against an increase in complexity and potential performance losses from the joining of the normalized tables at query-time.
• The database community has developed a series of guidelines for ensuring that databases are nomarlized. These are reffered to as normal forms and are numbered from one through five. In practical applications, you will often seen 1NF, 2NF and 3NF along with the  ocassional 4NF. Fifth Normal form is very rarely seen.
• First normal form (1NF) sets the very basic rules for an organized database.

Eliminate duplicative columns from the same table.

Create Seperate tables for each group of related data and identify each row with a unique column or set of columns ( the primary key). Continue Reading

What is a database ?

A Database is a collection of Organized data belonging to some organization or an Organizational process.Say if you are storing your friends contacts and organizing them in some fashion , then you are said to have an contacts database. As Long as you’re collecting and storing the data in an Organized form for a specific purpose , you have got a databse. Mainly we are going to discuss of Operational databases.

Operational databases are the backbone of many companies and Organizations throughout the world today. This type of database is primarily used to collect,store, modify and maintain data on a day-to-day basis. An example of Operational database could be retail stores, Manufacturing companies, Hospitals, clinics and Publishing houses.

Continue Reading