Advantage of SQL

Multiple Granularity Let’s start by understanding the meaning of granularity. Granularity: It is the size of data item allowed to lock. Multiple…

Specialization Specialization is a top-down approach, and it is opposite to Generalization. In specialization, one higher level entity can be broken down…

Views in SQL Views in SQL are considered as a virtual table. A view also contains rows and columns. To create the…

Indexing in DBMS Indexing is used to optimize the performance of a database by minimizing the number of disk accesses required when…

Multivalued Dependency Multivalued dependency occurs when two attributes in a table are independent of each other but, both depend on a third…

SQL Aggregate Functions SQL aggregation function is used to perform the calculations on multiple rows of a single column of a table.…

States of Transaction In a database, the transaction can be in one of the following states – Active state The active state…

Normalization A large database defined as a single relation may result in data duplication. This repetition of data may result in: Making…

SQL Clauses The following are the various SQL clauses: 1. GROUP BY SQL GROUP BY statement is used to arrange identical data…

Static Hashing In static hashing, the resultant data bucket address will always be the same. That means if we generate an address…