Relational Data Model and Relational Algebra

Video Lessons & Revision Notes

Relational Data Model
Relational Data Model
1. Relational Data Model
In this 27 mins Video Lesson
Introduction, Degree / Arity, Domain, Domain Constraint, Key Constraint, Entity Constraint, Referntial Integrity, Integrity Constriants, and other topics.
Relational Algebra - Selection, Projection and Set Operations
Relational Algebra - Selection, Projection and Set Operations
2. Relational Algebra - Selection, Projection and Set Operations
In this 33 mins Video Lesson
Introduction, Select Operator, Project Operator, Set Operations, Union Operator, Intersection Operator, Set Difference Operator, and other topics.
Relational Algebra - Rename, Joins, Assignment and Division Operator
Relational Algebra - Rename, Joins, Assignment and Division Operator
3. Relational Algebra - Rename, Joins, Assignment and Division Operator
In this 42 mins Video Lesson
Introduction, Rename , Cartesian Product, Natural Join, Outer Joins, Assignment Operator, Division Operator, and other topics.
Generalized Projection, Aggregate Functions, DB Modifications and Views
Generalized Projection, Aggregate Functions, DB Modifications and Views
4. Generalized Projection, Aggregate Functions, DB Modifications and Views
In this 40 mins Video Lesson
Introduction, Generalized Projection, Aggregate Functions, Database Modification, Deletion, Insertion, Updation, Views, and other topics.

Revision Notes

Basic concepts, Attributes and Domains, Relational Integrity: Domain, Entity, Referential Integrities, Enterprise Constraints, Views, Schema Diagram

Relational Algebra

Member's Zone