Introduction
- Important Tip
- Introduction
- Data model and its types
Basics of ER model
- Entity, Relationship and Attribute Explained
- Database Designer's perspective
- ER Model and Relational Model - Advantages and Disadvantages
- Basic Idea of Attributes of relationship
- Simple vs Composite Attributes, Single valued vs Multi-valued Attributes
- Stored vs Derived Attributes
- Complex Attributes
Relationship - Terminologies and Types
- Degree of a relationship and Cardinality Ratio
- Cardinality Ratio Explained with example
- Types of Participation - Total vs Partial Participation
- Example to illustrate Total and Partial Participation
- More Examples on Maximum and Minimum Cardinality
- Types of Relationships
- Recursive Relationship
- Example on finding the type of relationship
Relational Model
- Tuple, Field, Domain and Entity vs Entity types
- How Relational Model is derived from Discrete Math
- Degree of a relation, state of a relation, Intention vs Extension
- Important Rules in Relational Model
Constraints of Relational Model
- Types of Constraints, Domain Constraints Explained
- Key Constraints - Intro
Keys, Super Keys, Candidate Keys, Primary Keys
- Super Key Explained with example
- More Points on Super Key
- Key Explained with example
- Example to illustrate the difference between Key and Super Key
- Super Key vs Key vs Candidate Key vs Primary Key
- Finding the number of Super Keys
- Finding the number of Super Keys - 2
- Finding the number of Super Keys - 3
Constraints of Relational Model Revisited
- Key Constraints
- Entity Integrity Constraints
- Foreign Key Explained with example
- Example on Foreign Key
- Difference between Foreign Key and Primary Key
- Referential Integrity Constraints
- Constraints violated by Insertion
- Constraints violated by Deletion
- Constraints violated by Updation and Viewing
- Steps taken by DBMS in case of constraint violation
- Problem on ON-DELETE CASCADE
- Problem on Referential Integrity Constraint
More on Finding the Number of Super Keys
- Problem 1 on finding the number of Super Keys
- Finding Number of Super Keys using Venn Diagram 1
- Finding Number of Super Keys using Venn Diagram 2
- Important Observation
- Finding Number of Super Keys using Venn Diagram 3
- Finding Number of Super Keys using Venn Diagram 4
Conversion of ER Model to Relational Model
- Conversion of Entities, Attributes, Prime Attribute and Composite Attributes
- Conversion of one-to-many relationship
- Example for conversion of one-to-many relationship
- Conversion of One-to-one relationship
- Conversion of Many-to-many relationship
- A good approach to follow but not a rule
- Problem on Multivalued attributes
- Problem on finding minimum number of tables needed for conversion
- Problem on finding maximum number of tables needed for conversion
- Special Case : One-to-one relationship with total participation on both sides
- Lecture 60 continued
- Weak vs Strong Entity - Differences
- Example to illustrate Weak Entity and their conversion to Relational model
- N-ary relationships
- Identifying Relationships
- Important Notations Revisit
- Problem 1
- Attributes to relationship : one to many relationship
- Attributes to relationship : one-to-one relationship
- Attributes to relationship : many-to-many relationship
- Problem
Functional Dependencies
- Introduction to Functional Dependencies
- Examples on Functional Dependency
- Important Point to note
- More Examples on Functional Dependency
- Trivial Functional Dependency
- Non Trivial Functional Dependency
- Semi Trivial Functional Dependency
- Important Point to Note
- Closure set of an attribute 1
- Closure set of an attribute 2
- Closure set of an attribute 3
- Example on finding Closure Set
- Applications of Closure operation
Finding the Keys using Closure Operation
- Problem 1 on finding keys using Closure Operation
- Problem 2 on finding keys using Closure Operation
- Problem 3 on finding keys using Closure Operation
- Problem 4 on finding keys using Closure Operation
- Problem 4 on finding keys using Closure Operation - continued
