Thanks for watching :) Timestamps : 1. Intension and Extension in Database- 00:00:00 2. What is RDBMS- 00:06:11 3. Normalisation- 00:09:53 4. Denormalisation- 00:27:43 5. Functional Dependency and its Type- 00:34:09 6. Attribute closure- 00:55:00 7. Finding super key using attribute closure- 01:02:56 8. Finding candidate key using attribute closure- 01:16:33 9. First Normal Form (1NF)- 01:35:00 10. Second Normal Form(2NF)-01:44:55 11. Third Normal Form(3NF) - 01:57:43 12. Boyce Codd Normal Form(BCNF) - 02:07:24 13. Lossy and Lossless Decomposition - 02:10:49 14. Dependency Preserving Decomposition -02:21:13 15. Fourth Normal Form(4NF) - 02:26:43 16. Fifth Normal Form(4NF) - 02:29:09 17. How to find the highest Normal Form - 02:32:09 18. How to Normalize a table - 02:40:39 19. Equivalence of Functional Dependency - 02:48:52 20. Minimal Set of Functional Dependency- 02:56:00
Thanks for watching :)
Timestamps :
1. Intension and Extension in Database- 00:00:00
2. What is RDBMS- 00:06:11
3. Normalisation- 00:09:53
4. Denormalisation- 00:27:43
5. Functional Dependency and its Type- 00:34:09
6. Attribute closure- 00:55:00
7. Finding super key using attribute closure- 01:02:56
8. Finding candidate key using attribute closure- 01:16:33
9. First Normal Form (1NF)- 01:35:00
10. Second Normal Form(2NF)-01:44:55
11. Third Normal Form(3NF) - 01:57:43
12. Boyce Codd Normal Form(BCNF) - 02:07:24
13. Lossy and Lossless Decomposition - 02:10:49
14. Dependency Preserving Decomposition -02:21:13
15. Fourth Normal Form(4NF) - 02:26:43
16. Fifth Normal Form(4NF) - 02:29:09
17. How to find the highest Normal Form - 02:32:09
18. How to Normalize a table - 02:40:39
19. Equivalence of Functional Dependency - 02:48:52
20. Minimal Set of Functional Dependency- 02:56:00
amazing explanation
It's useful ❣️
this is amazing
1:02:00 should not we take ab+ ,ac+, ad+, ae+ closure as well....?
TANQ MAM😇
if attribute closure of b doesnot contain all the realtion then it will be candidate key or not at 2:36:31
Very interested chapter RDBMS
❤