Loading Revision Notes. Please Wait, it may take upto a minute
Introduction, Entity, Entity Set, Entity Type, Attributes, Null Values, Relationships, and related Topics.
Introduction, Entity, Entity Set, Entity Type, Attributes, Null Values, Relationships, and other topics.
Super keys, Candidiate Keys, Primary Keys, Weak Entity Set, Partial Key / Discriminator, Constraints On Relationships, and other topics.
ER Notations, ER Model to Tables, Strong Entity Set (Including Multivalued and Composite Attr.), Weak Entity Set, Relationship Set, and other topics.
Introduction, Specialization, Generalization, Constraints on Specialization, Hierarchies and Lattice, Categories and Unions, and other topics.
Aggregation, EER Model to tables, Specialization, Category to tables, and other topics.
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.
Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.
Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.