Relational algebra in DBMS

Relational algebra in DBMS Relational algebra is a procedural query language used to retrieve the data from a database in a different way. It works on the relational model.It performs various operations such as insert, delete, update, and many other operations in the...

Cardinality in DBMS

Cardinality in DBMS Cardinality is the relationship between two or more entities (table). It shows how all the entities are connected. In DBMS, all the entities and tables are interconnected with each other. Here we will see the relation among one entity to another...

DBMS MCQ (Multiple Choice Questions)

DBMS MCQs In this section, we are going to cover some of the basic questions based on DBMS, which are frequently asked during an interview. Here we will try to cover almost all the topics related to DBMS. 1) Relational database is a collection of Table Field Record or...

Generalization in DBMS

Generalization in DBMS In the database management system, generalization is a concept combining the common attributes of two or more lower-level entity and form a new higher level with the common attributes. In this DBMS concept, we can also combine the generalized...

Data Models in DBMS

Data Models in DBMS Data models are the models explaining the logical structure of the database systems. They describe the entities, attributes, and the relationship among the data elements of the specified database. Data models organize the description and...

Specialization in DBMS

Specialization in DBMS In the database management system, specialization breaks the higher-level entity into two or more than two lower entities. The main motive of this concept is to share the common attributes or properties between the entities in the same database....

Disadvantages of DBMS

Disadvantages of DBMS With the vast list of advantages, there are some following disadvantages or limitations of the database management system. 1. High Cost The high cost of software and hardware is the main disadvantage of the database management system. Database...

Advantages of DBMS

Advantages of DBMS A Database Management System (DBMS) is a collection of programs which lets the end-users to manage and control the database. Database systems use query language for accessing, storing, and maintaining the data in the databases. DBMS is a layer...

Super Key in DBMS

Super Key in DBMS: The super key is a column or a set of columns in the database table, which uniquely identifies the tuple or row of the same table. It is a type of key, which is the superset of the candidate key. We are describing this concept with the following...

Trigger in DBMS

Trigger in DBMS: A trigger is a procedure of SQL statements, which is automatically fired when the DML statements are executed on the table of the database. Triggers are the event-driven procedures, which are managed and stored by the database management system....

Pin It on Pinterest