priya

The major disadvantages are: The occurrence of redundant terms in the database which causes the waste of the space in the disk. Due to redundant terms inconsistency may also occur id any change will be made in the data of one table but not made in the same data of another table then inconsistency will … Read more

Normalization is mainly used to add, delete or modify a field that can be made in a single table. The primary use of Normalization is to remove redundancy and to remove the insert, delete and update distractions. Normalization breaks the table into small partitions and then link them using different relationships so that it will … Read more

Normalization is used to minimize redundancy and dependency by organizing fields and table of a database. There are some rules of database normalization which commonly known as Normal From and they are: First normal form(1NF) Second normal form(2NF) Third normal form(3NF) Boyce-Codd normal form(BCNF) Using these steps, the redundancy, anomalies, inconsistency of the data in … Read more

RDBMS stands for Relational Database Management System. It is a database management system based on a relational model. RDBMS stores the data into the collection of tables and links those table using the relational operators easily whenever required. It facilitates you to manipulate the data stored in the tables by using relational operators. Examples of … Read more

There are four types of database: Hierarchical databases (DBMS) Relational databases (RDBMS) Network databases (IDMS) Object-oriented databases RDBMS is one of the most often used databases due to its easy accessibility and supports regarding complex queries. There are several types of database management systems (DBMS), each designed for specific purposes. The main types of DBMS … Read more