Similar Topics

DSA

21.8k+ articles

GATE CS

1.5k+ articles

DBMS

1.4k+ articles

SQL

1.3k+ articles

DBMS-SQL

510+ articles

Hash

130+ articles

B-Tree

24 articles

DBMS Basics

17 articles

DBMS-Normalization

16 articles

DBMS Indexing

11 articles

dbms

37 posts

Types of Functional dependencies in DBMS

Last Updated: 12 June 2023

Prerequisite: Functional dependency and attribute closureIn a relational database management, functional dependency is a concept that specif ...read more

Technical Scripter 2020

Cosine Similarity

Last Updated: 15 July 2023

Prerequisite - Measures of Distance in Data Mining In Data Mining, similarity measure refers to distance with dimensions representing featur...read more

SQL Trigger | Student Database

Last Updated: 12 April 2024

A trigger is a stored procedure in a database that automatically invokes whenever a special event in the database occurs. For example, a tri...read more

Similar Topics

DSA

21.8k+ articles

GATE CS

1.5k+ articles

DBMS

1.4k+ articles

SQL

1.3k+ articles

DBMS-SQL

510+ articles

Hash

130+ articles

B-Tree

24+ articles

DBMS Basics

17+ articles

DBMS-Normalization

16+ articles

DBMS Indexing

11+ articles

Last Updated: 11 March 2024

An Inverted Index is a data structure used in information retrieval systems to efficiently retrieve documents or web pages containing a spec ...read more

Introduction of B+ Tree

Last Updated: 08 March 2024

B + Tree is a variation of the B-tree data structure. In a B + tree, data pointers are stored only at the leaf nodes of the tree. In a B+ tr...read more

Timestamp based Concurrency Control

Last Updated: 07 June 2023

Concurrency Control can be implemented in different ways. One way to implement it is by using Locks. Now, let us discuss Time Stamp Ordering...read more

File Organization in DBMS - Set 1

Last Updated: 16 November 2023

A database consists of a huge amount of data. The data is grouped within a table in RDBMS, and each table has related records. A user can se...read more

Armstrong's Axioms in Functional Dependency in DBMS

Last Updated: 19 July 2023

Prerequisite - Functional DependenciesThis article contains Armstrong's Axioms and how Armstrong's Axioms are used to decide about the funct ...read more

DROP and TRUNCATE in SQL

Last Updated: 31 October 2023

SQL commands are broadly classified into two types DDL, DML here we will be learning about DDL commands, and in DDL we will be learning abou...read more

SQL-Clauses-Operators

Lossless Join and Dependency Preserving Decomposition

Last Updated: 27 March 2024

Decomposition of a relation is done when a relation in a relational model is not in appropriate normal form. Relation R is decomposed into t ...read more

DBMS-Normalization

Indexing in Databases - Set 1

Last Updated: 07 November 2023

Indexing improves database performance by minimizing the number of disc visits required to fulfill a query. It is a data structure technique...read more

Finding Attribute Closure and Candidate Keys using Functional Dependencies

Last Updated: 28 June 2023

In this article, we will find the attribute closure and also we will find the candidate keys using the functional dependency. We will look i ...read more

Relational Model in DBMS

Last Updated: 04 February 2024

E.F. Codd proposed the relational Model to model data in the form of relations or tables. After designing the conceptual model of the Databa ...read more

DBMS-Relational Model

Inner Join vs Outer Join

Last Updated: 08 June 2023

Inner Join and Outer Join are the types of join. The inner join has the work to return the common rows between the two tables, whereas the O...read more

Delete Operation in B-Tree

Last Updated: 20 March 2024

Pre-Requisite: B-Tree | Set 1 (Introduction), B-Tree | Set 2 (Insert)B Trees is a type of data structure commonly known as a Balanced Tree t...read more

Advanced Data Structure