SQL Notes

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

DBMS stands for Database Management System. This is a program which is used to control them. It is like a File Manager that manages data in a database rather than saving it in file systems. Database management system is an interface between the database and the user. It makes the data retrieval, data access easier. … Read more

A Database is an organized form of data. The database is the electronic system which makes data access, data manipulation, data retrieval, data storing and data management very easy and structured. Almost every organization uses the database for storing the data due to its easily accessible and high operational ease. The database provides perfect access … Read more