Download Database Management System (DBMS) & SQL : Complete Pack-2023 Course for Free

Types of keys

Primary Key

Alternate Key

Candidate Key

Super Key

Foreign Key

Introduction

Attribute Single and Multi-valued Attributes & Stored and Derived Attributes

Relationship Introduction, Weak Relationship

Attribute Key attribute, Simple and Composite Attributes

Entity Strong and Weak Entity

Relationship Degree - Unary, Binary, Ternary and n-ary Relationships

Relationship Cardinality-One One(1 1),One Many(1 M),Many One(M 1),Many Many(M M)

Example 1,2 Min,Max Cardinality, Partial & Total Participation, Relationship

Relationship Partial and Total Participation & Cardinality Ratio

Types of Functional Dependencies Trivial and Non-Trivial FD's

Functional Dependency Introduction, Examples

FD Example

Inference Rules

Attribute Closure Example 2

Attribute Closure Example 4

Attribute Closure Example 3

Application 1 Finding additional FD's

Application 2 Finding keys in a relation - Example 3 & 4

Applications of Attribute Closure

Application 2 Finding keys in a relation - Example 1 & 2

Application 2 Finding keys in a relation - Example 7 & 8

Application 2 Finding keys in a relation - Example 5 & 6

Application 2 Finding keys in a relation - Example 9 & 10

Application 2 Finding keys in a relation - Example 11 & 12

Application 2 Finding keys in a relation - Example 13 & 14

Application 3 Equivalence of Functional Dependencies - Example 2

Application 3 Equivalence of Functional Dependencies - Example 3

Application 3 Equivalence of Functional Dependencies - Example 1

Application 3 Equivalence of Functional Dependencies - Example 4

Application 4 Irreducible set - Example 2

Application 4 Irreducible set and Algorithm

Application 4 Irreducible set - Example 1

Partial Functional Dependency and Full Functional Dependency

Anomalies Update, Deletion and Insertion Anomaly

First Normal Form (1NF)

Normalization Introduction and types

NF Examples - 1, 2, 3, 4 and NOTE

Second Normal Form ( 2NF)

NF Examples - 1, 2

Third Normal Form ( 3NF)

NF Example - 3

NF Example - 4

Boyce Codd Normal Form ( BCNF)

DISTINCT keyword in SELECT clause

WHERE clause Introduction

SELECT statement structure and evaluation order

SELECT clause Syntax and examples

WHERE clause Operators

WHERE clause Logical Operators - AND, OR, NOT

WHERE clause AND, OR, NOT - Together

ORDER BY clause ASC, DESC

LIKE and Wildcard Operators

Aggregate Functions SUM(), AVG(), MIN(), MAX()

NULL values and IS NULL & IS NOT NULL

Aggregate Functions COUNT()

GROUP BY clause Multiple columns

Set Manipulation Operators Rules

HAVING clause and rules

GROUP BY clause

Joins Introduction, Cross Join

Joins Theta Join Conditional Join

Set Manipulation Operators UNION, INTERSECTION, MINUS

Joins Equi Join

Outer Join Introduction

Joins Self Join

Joins Left Outer Join

Joins Right Outer Join

Joins Full Outer Join

Joins Natural Join