Relational Data Model and Relational Algebra
Video Lessons & Revision Notes
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.
Introduction, Degree / Arity, Domain, Domain Constraint, Key Constraint, Entity Constraint, Referntial Integrity, Integrity Constriants, and other topics.
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.
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
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.
Introduction, Rename , Cartesian Product, Natural Join, Outer Joins, Assignment Operator, Division Operator, and other topics.
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.
Introduction, Generalized Projection, Aggregate Functions, Database Modification, Deletion, Insertion, Updation, Views, and other topics.
Revision Notes
Relational Algebra
(2.07 Mb)
Relational Data Model
(1.16 Mb)
Basic concepts, Attributes and Domains, Relational Integrity: Domain, Entity, Referential Integrities, Enterprise Constraints, Views, Schema Diagram
Relational Algebra