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

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

Query 4

Query 1,2,3

Query 5

Query 8

Query 6, 7

Query 9

Query 11.1, 11.2, 11.3, 11.4

Query 10

Relational Algebra Introduction

RA Set Manipulation Operators(Union, Intersection, Difference)

RA Selection and Projection Operators

RA Set Manipulation Operators - INTERSECTION

RA Set Manipulation Operators - UNION

RA Cartesian Product

RA Rename Operator

RA Set Manipulation Operators - SET DIFFERENCE

RA Join introduction and Types

RA Equijoin

RA Natural Join

RA Conditional Join Theta Join

RA Outer Join

RA Left Outer Join

RA Right Outer Join

RA Full Outer Join

RA Division Operator

RA Division Operator - Example 1, 2

Schedule Serial and Concurrent Schedules - Definitions

Transaction Introduction

Last update problem Problems due to concurrency control

Problem Number of Searial and Concurrent Schedules

Dirty Read Problem Problems due to concurrency control

Unrepeatable Read Problem Problems due to concurrency control

Non-recoverable Schedules

Recoverable Schedules

Problem

Cascading Schedules

Cascadeless Schedules

Strict Schedules

Problem 3

Relation among Strict, Cascadeless and Recoverable Schedules

Problem 4

Problem 5, 6

Problem 7, 8

Problem 1, 2

Serializability Types

Classification

Serializability Number of serial and non-serial schedules

test1

test

Serializability Introduction

test2

Introduction

Storage Strategies Spanned and Unspanned Strategies

Records organization in a file

Sparse Index and Dense Index

Indexing Introduction

Indexing Primary Indexing

Indexing Cluster Index

Indexing Secondary Indexing

Indexing Primary Indexing - Numerical Problem

Indexing Secondary Indexing - Example

B-Tree Numerical problem on Order of node

B-Tree Order of Node

B-Tree Introduction

B-Tree Node structure

B+ Tree Leaf node and Internal node Split

B+ Tree Introduction - Structure, Order of Leaf and Internal Node

B-Tree Tree creation with example

B-Tree Deletion operation with example

B+ - Tree Numerical problem on Order of node

B+ Tree Insertion Operation - Tree Creation