DBMS
- Relational Model
- Normalization & Normal Forms
- 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
- Transactions and Concurrency control
Data Science Duniya 