Skip to main content

SQL
0 followers
0 questions
14 posts

Article/ Blog
DatabaseMysqlSQL

NORMALISATION in DBMS

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)

Article/ Blog
DatabaseMysqlSQL

File Management

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)

Article/ Blog
DatabaseMysqlSQL

Transaction

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)

Article/ Blog
DatabaseMysqlSQL

Normalisation Forms

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)