Course
DBMS
20 lessons47 min total
-
Overview-Database management system
What is Data? Data is nothing more than raw, unfiltered facts and statistics that are stored or freely…
-
Components of DBMS
A database management system (DBMS) is a software system designed to manage the storage, retrieval, and manipulation of…
-
DBMS Architecture
The architecture of the DBMS affects how it is designed. When dealing with a sizable number of PCs,…
-
Data Models – DBMS
What are Data Models in DBMS? In database management systems (DBMS), a data model is a conceptual representation…
-
Basic Concepts of ER Model
The ER (Entity-Relationship) model is a conceptual data model used in database design. It represents the data in…
-
Creating ER Diagram
An ER diagram is a visual representation of the entities, attributes, and relationships between them in a database.…
-
Enhanced ER Diagram
As data complexity increases today, it is becoming increasingly difficult to apply the traditional ER paradigm for database…
-
Codd’s Rule for Relational DBMS
After conducting extensive research on the Relational Model of database systems, Dr. Edgar F. Codd developed twelve rules…
-
Basic Concepts of RDBMS
A relational database management system (RDBMS) is a group of tools and features that enables IT teams and…
-
What is Relational Algebra?
Relational Algebra is a procedural query language, which takes Relation as input and generates relation as output. SQL…
-
Relational Calculus
A non-procedural query language called relational calculus is used to retrieve data from relational databases. Thanks to this…
-
ER Model to Relational Model
The ER (Entity-Relationship) model is a graphical representation used to design databases. On the other hand, the relational…
-
Introduction to keys in DBMS
What are the Keys in DBMS? In DBMS, KEYS is an attribute or set of attributes that aid…
-
Normalization of Database
What is Database Normalization? A database design technique called normalization reduces data duplication and gets rid of undesirable…
-
First Normal Form (1NF)
Let’s look at the first normal form in detail from the previous lecture where we saw a brief…
-
Second Normal Form(2NF)
What is 2NF? The second step in Normalization is 2NF. A table must meet two requirements to be…
-
Third Normal Form(3NF)
What is Third Normal Form? The third step in Normalization is 3NF. For a table to be in…
-
Boyce–Codd Normal Form
What is BCNF? The Boyce-Codd Normal Form also referred to as the 3.5 Normal Form, is an extension…
-
Fourth Normal Form (4NF)
What is 4NF? A level of database normalisation known as the fourth normal form (4NF) is one in…
-
Fifth Normal Form (5NF)
What is 5NF? The fifth normal form, or 5NF, is also called the project-join normal form. If a…