Category: DBMS
-
DBMSFirst Normal Form (1NF)
Let’s look at the first normal form in detail from the previous lecture where we saw a brief overview of…
February 26, 2023
-
DBMSNormalization of Database
What is Database Normalization? A database design technique called normalization reduces data duplication and gets rid of undesirable traits like…
February 25, 2023
-
DBMSIntroduction to keys in DBMS
What are the Keys in DBMS? In DBMS, KEYS is an attribute or set of attributes that aid in relational…
February 24, 2023
-
DBMSER Model to Relational Model
The ER (Entity-Relationship) model is a graphical representation used to design databases. On the other hand, the relational model is…
February 23, 2023
-
DBMSRelational Calculus
A non-procedural query language called relational calculus is used to retrieve data from relational databases. Thanks to this mathematical based…
February 22, 2023
-
DBMSWhat is Relational Algebra?
Relational Algebra is a procedural query language, which takes Relation as input and generates relation as output. SQL and relational…
February 21, 2023
-
DBMSBasic Concepts of RDBMS
A relational database management system (RDBMS) is a group of tools and features that enables IT teams and other users…
February 19, 2023
-
DBMSCodd’s Rule for Relational DBMS
After conducting extensive research on the Relational Model of database systems, Dr. Edgar F. Codd developed twelve rules that, in…
February 18, 2023
-
DBMSEnhanced ER Diagram
As data complexity increases today, it is becoming increasingly difficult to apply the traditional ER paradigm for database modeling. In…
February 17, 2023
-
DBMSCreating ER Diagram
An ER diagram is a visual representation of the entities, attributes, and relationships between them in a database. Entities represent…
February 17, 2023