- Relational Algebra – Degree, Cardinality, Domain, Union Compatibility and Operators
- Cartesian Product
- Join Operators in DBMS
- Join Conditions – Natural Join, On Condition, Using Attribute
- Join Types – inner, left outer, right outer and outer join
- Types of Functional Dependencies in Normalization
- Super Key, Candidate Key and Primary Key
- How to find attribute closure using Functional Dependency
- Procedure to determine Candidate key using attribute closure
- Prime and Non Prime Attributes
- Normal Forms
- Procedure to decompose a given relation in BCNF – BCNF Algorithm
Data Science Duniya 