Entity Relationship Model - Basic Concepts
Loading Video Lesson
If you dont see the Video even after 10 seconds,
then please download and Install the Flash Player
In this 33 mins Lesson you will Learn about following concepts.
Introduction, Entity, Entity Set, Entity Type, Attributes, Null Values, Relationships, and related Topics.
Related Video Lessons in this Series
Entity Relationship Model - Basic Concepts
33 mins Video LessonIntroduction, 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 LessonSuper 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 LessonER 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 LessonIntroduction, 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 LessonAggregation, EER Model to tables, Specialization, Category to tables, and other topics.
SQL - Basic Concepts and Queries
56 mins Video LessonIntroduction, 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 LessonTable 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 LessonIntroduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.
