Java Script needs to be enabled for Video to Load.

Concept of Keys, Strong/Week Entity Sets and Relationship Constraints

Loading Video Lesson
In this 38 mins Lesson you will Learn about following concepts.
Concept of Keys, Strong/Week Entity Sets and Relationship Constraints

Super keys, Candidiate Keys, Primary Keys, Weak Entity Set, Partial Key / Discriminator, Constraints On Relationships, and related Topics.


Related Video Lessons in this Series

Entity Relationship Model - Basic Concepts

33 mins Video Lesson

Introduction, Entity, Entity Set, Entity Type, Attributes, Null Values, Relationships, and other topics.

Concept of Keys, Strong/Week Entity Sets and Relationship Constraints

38 mins Video Lesson

Super keys, Candidiate Keys, Primary Keys, Weak Entity Set, Partial Key / Discriminator, Constraints On Relationships, and other topics.

Converting ER Diagram to Tables

27 mins Video Lesson

ER Notations, ER Model to Tables, Strong Entity Set (Including Multivalued and Composite Attr.), Weak Entity Set, Relationship Set, and other topics.

Extended ER Model - Specialization, Generalization, Hierarchies, Lattices

33 mins Video Lesson

Introduction, Specialization, Generalization, Constraints on Specialization, Hierarchies and Lattice, Categories and Unions, and other topics.

Extended ER Model - Aggregation and Conversion to Tables

18 mins Video Lesson

Aggregation, EER Model to tables, Specialization, Category to tables, and other topics.

SQL - Basic Concepts and Queries

56 mins Video Lesson

Introduction, Data Types, Schema And Catalog, Select-From-Where, Cross Product, Aliasing / Rename, Star Symbol (*), SQL results as MultiSet, Set Operations, Generalized Projection - Use of Math. Ops, Order By, String Comparison - Like, and other topics.

Data Definitions, Schemas and Views

39 mins Video Lesson

Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.

NULL Comparisons, Nested and Co-related Queries

41 mins Video Lesson

Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.

Member's Zone