Normalisation

Normalization
In a relational database we store data into relations (tables). There is more chance of repetation of data which is known as data redundancy. To minimize the redundancy, we divide a table into different tables and establish a relationship between them so that we can easily fetch data and reduce repetition of similar data, this is known as Normalization. There are multiple forms of normalization, some important of them are explained below.
1NF
A table or relation is in 1NF if it follows the following rules:
· All the attributes/columns of a relation must be atomic that is, the column should contain single value.
· The value of an attribute should belong to the same domain (it is a set of permitted value for each attribute).
· The name of attributes/columns must be unique.
A set of names is an example of a non-atomic value because names can be divided into first name and last name. Composite attributes such as “address” are considered as non-atomic domain because it can be further classified into street, city, zip etc.
2NF
A table or relation is in 2NF if it follows the following rules:
· The relation should be in...