Author - Pulkit Wadhwa

DBMS

SQL Recovery

Transaction recovery The database management system allows as a method to manage the data tables and it’s related information. Adata table set of records...

DBMS

SQL Security

Control consideration The database is shared between multiple users so need to secure the data to unauthorized user full stop the database is controlled with a...

DBMS

SQL Support

SQL Support The SQL provides a method for commit or roll back the data item into the database which is called as SQL support. Commit->It is a command that...

DBMS

SQL Commands List

Join Operations SQL allows as a method to a combine more than one tables for processing the field we can update view and delete the information for...

DBMS

SQL Operators and Commands

SQL Operators The operator is used to control the processing of queries of database SQL support different operator to relate the expression and control...

DBMS

SQL Basics

SQL SQL is a structured query language. It is a non-procedure language that allows built-in function and command for controlling the database and its...

DBMS

Relational Algebra In Dbms

Relational algebra Relational algebra is used for processer. query language to manipulate the data with a different operator. It consists of the set...

DBMS

Normalization In Dbms

Normalization Normalization is a process to control the database records and manage the data records in simplest format. It allows to manage the relationship...

DBMS

Dbms Codd’s 12 Rules

CODD’s RULE There are 12 rules developed by EF-Codd for RDBMS in 1970. An RDBMS maintain least 6 rules follow. Information representation-> It is...