BOYCE CODD NORMAL FORM (BCNF) IN NORMALIZATION || NORMAL FORMS || 1NF, 2NF, 3NF, BCNF, 4NF, 5NF,DBMS

  Рет қаралды 30,331

Sundeep Saradhi Kanthety

Sundeep Saradhi Kanthety

Күн бұрын

INTRODUCTION TO NORMALIZATION
1. 1NF - FIRST NORMAL FORM
2. 2NF - SECOND NORMAL FORM
3. 3NF - THIRD NORMAL FORM
4. BCNF - BOYCE CODD NORMAL FORM
5. 4NF - FOURTH NORMAL FORM
6. 5NF - FIFTH NORMAL FORM
-------------------------------------------------------------------------------------
DATABASE MANAGEMENT SYSTEM
• DATABASE MANAGEMENT SY...
HOW TO DOWNLOAD & INSTALL MySQL IN WINDOWS 10
• HOW TO DOWNLOAD & INST...
PYTHON PROGRAMS
• PYTHON PROGRAMS
C PROGRAMMING
• 01 - VARIABLES & CONST...
CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS
• CORE JAVA TUTORIAL FOR...
HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS
• HTML TUTORIALS WITH IM...
LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS
• LEARN CSS IN 3 HOURS |...
JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT
• JAVA SCRIPT FOR BEGINN...
PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)
• Learn Python from Scra...
PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)
• PYTHON - OOPS CONCEPTS...
PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU
• PYTHON NUMPY TUTORIAL ...
PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE
• PYTHON PANDAS TUTORIAL...
MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)
• MATPLOTLIB LIBRARY - P...
PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL
• PYTHON DATABASE CONNEC...
DATA STRUCTURES USING PYTHON (ENGLISH)
• DATA STRUCTURES USING ...
----------------------------------------------------------------------------------------------
Instagram : / sundeepsaradhikanthety

Пікірлер: 24
@pavankalyandevarakonda5028
@pavankalyandevarakonda5028 2 ай бұрын
Thanks you very much sir while preparing for interview i saw your entire DBMS and OS playlist which gave me a coonfidence that helps in crack TCS INTERVIEW 🎉❤
@anonymous-xc2cv
@anonymous-xc2cv Жыл бұрын
In the given question relations : s,c ---> t s,t ----> c t ---> c for the last 2 relations it satisfies the partial dependency , and it should not be the 2nf then how can it would be the 3nf ?
@bhanudevi2402
@bhanudevi2402 2 жыл бұрын
Please continue other topics in DBMS sir , we are thankful to you sir .
@abhisheksalokhe8962
@abhisheksalokhe8962 2 жыл бұрын
Sir Please 🙏Upload This Topics Also : Database Transaction Management, NoSql Database, Adavance in Database That Will Help Us Lot in Exam My University Exams Are There and Your Videos Help a lot Not Only For DBMS For Every Subject
@globallivingbeing
@globallivingbeing 2 жыл бұрын
Is this series completed, or will you start further topic i.e. transaction control?
@bokinalavijay6876
@bokinalavijay6876 2 жыл бұрын
We are always supports you sir.
@yethishchintu3571
@yethishchintu3571 Жыл бұрын
Sir What about 4NF and 5NF classes should we ignore it ???
@vinaybavaraju4145
@vinaybavaraju4145 2 жыл бұрын
sir can we divide the table as our wish? or is there any procedure for it?
@sigmakings7285
@sigmakings7285 2 жыл бұрын
Same doubt bro
@lokeshone8678
@lokeshone8678 2 жыл бұрын
SIR IT NOT SATISFING THE CONDITIONS OF 2NF ( PARTIAL FUNCTIONAL DEPENDANCY RULE VOILATING) CAN YOU PLEASE CHECK.......
@sesharaoparitala8333
@sesharaoparitala8333 2 жыл бұрын
No, this is a perfect BCNF example, how do you say that it is violating 2NF when it satisfied 3 NF too
@krishnamurali1702
@krishnamurali1702 Жыл бұрын
@@sesharaoparitala8333 s, t -> c is partial dependency. 2NF is not satisfied.
@Yashkyk
@Yashkyk 10 ай бұрын
No bro here t is proper subset of ck but on right side u can see a prime attribute so it is in 2nf
@KolluruManojKumar
@KolluruManojKumar 2 ай бұрын
​​@@krishnamurali1702yes bro 2 NF is not satisfied In relation S,T -> C T-> C is F.D. Therefore the relation is in Partially Functional Dependent. At 2NF conversion - we can get the BCNF result of new Sub relations. What's the use of doing BCNF then
@fog2640
@fog2640 Жыл бұрын
finished watching
@udaysagarreddy4839
@udaysagarreddy4839 Жыл бұрын
C depends on T kada sir... Meru reverse chepthunaru anti.. ?
@anonymous-xc2cv
@anonymous-xc2cv Жыл бұрын
ala vaadu bro endhuku antey 101 lo python ki saradhi undhi and 102 python ki satwik undhi andhey c ---> t avvaledhu
@jarpulavenkatesh9278
@jarpulavenkatesh9278 2 жыл бұрын
Sir power bi explain cheyyandi
@PoojithaPatel-d4h
@PoojithaPatel-d4h Жыл бұрын
Sir iam unable to find 4nf,5nf videos of urs
@nadipudisimhachalam8005
@nadipudisimhachalam8005 Жыл бұрын
Sir normalization 1nf, 2nf, 3nf bcnf telugu lo vedios cheyyandi sir
@udaysagarreddy4839
@udaysagarreddy4839 Жыл бұрын
Unnai bro already
@findyourtreasure6024
@findyourtreasure6024 2 жыл бұрын
Bcnf @14:30
@bokinalavijay6876
@bokinalavijay6876 2 жыл бұрын
Plz sir continue ur lectures
@DnyaneshwarPanchaldsp
@DnyaneshwarPanchaldsp 11 ай бұрын
Some what complex
SQL TUTORIALS FOR BEGINNERS IN 4.5 HOURS || STRUCTURED QUERY LANGUAGE TUTORIALS || DBMS
4:35:50
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Decomplexify
Рет қаралды 2,2 МЛН
GIANT Gummy Worm #shorts
0:42
Mr DegrEE
Рет қаралды 152 МЛН
Caleb Pressley Shows TSA How It’s Done
0:28
Barstool Sports
Рет қаралды 60 МЛН
Vampire SUCKS Human Energy 🧛🏻‍♂️🪫 (ft. @StevenHe )
0:34
Alan Chikin Chow
Рет қаралды 138 МЛН
Lec 13: BCNF in DBMS | Boyce Codd Normal Form | Normalization in DBMS
23:53
Jenny's Lectures CS IT
Рет қаралды 331 М.
I Spent 100 Hours Inside The Pyramids!
21:43
MrBeast
Рет қаралды 10 МЛН
Boyce Codd Normal Form | BCNF | Normalization | DBMS
8:48
making IT simple
Рет қаралды 13 М.
Database Normalization 1NF 2NF 3NF
10:26
Jesper Lowgren
Рет қаралды 193 М.
Boyce-Codd Normal Form (BCNF) | Database Normalization | DBMS
4:42
Studytonight with Abhishek
Рет қаралды 803 М.
GIANT Gummy Worm #shorts
0:42
Mr DegrEE
Рет қаралды 152 МЛН