Database Normalization is a technique that helps in designing the schema of the database.

•Noramalisation reduces storage.

•Normalisation helps in avoiding unnecessary data conflicts because of multiple copies of the same data

getting stored.

The main idea of database normalization... (More)

This refers to the logical relationships among various records that constitute the file, particularly with respect to the means of identification and access to any specific record. Storing the files in a certain order is called File Organization.

• There... (More)

A transaction is an action or series of actions that are being performed by a single user or application program, which reads or updates the contents of the database.

Properties of Transaction

1.Consistency

The database must remain in a... (More)

The given normalisation forms help us to eradicate the different types of anamoalies and prevent the data duplicates that preserve the consistency of the database. The types of Normal forms are discussed below

First Normal Form

▪ A relation is... (More)