Normal Forms - Complete Summary & GATE PYQs | 1NF, 2NF, 3NF, BCNF | ALL In One | DBMS | Deepak

[@SK-qn5ry]

0:50 prime and non-prime atrribute 9:50 full&partial FD 23:16 misconception of partial FD 27:22 normal forms starts 42:53 2NF def.1 59:11 2NF def.2 1:31:14 3NF Def1 1:36:06 3NF def2 2:03:07 BCNF normal form 2:34:45 pyq, imp results 3:16:52 imp result

[@GOClassesforGATECS]

Thank you so much SK for this.

[@vighneshpm3452]

crystal clear and easy-to-understand summary of the database normalization forms, keeping it precise. 3.5 hours went very fast

[@sasikumarr7726]

Deepak sir is GOAT 🔥🔥🔥

[@GOClassesforGATECS]

00:00:41 - Prime attribute of a relation scheme, Non-prime attribute 00:09:29 - Partial Dependency, Full Functional Dependency in Relational Model 02:34:53 - GATE IT 2008 - relational schema BCNF, 3NF, 2NF gateoverflow.in/3372/gate-it-2008-question-62 02:45:23 - GATE CSE 2004 - highest normal form of this relation scheme gateoverflow.in/1046/gate-cse-2004-question-50 02:55:00 - GATE IT 2004 - relation Emptdt1, 3NF, 2NF, BCNF 1NF gateoverflow.in/3719/gate-it-2004-question-75

[@mehreenhashmi142]

sir please upload the summary videos for indexes and transactions also

[@YASHKUMARPANSE19BCE728]

Sir , Will you upload the summary videos for decomposition and transactions also?

[@GOClassesforGATECS]

Yes. Coming soon. Find DBMS Summary & GATE PYQs playlist link in the description.

[@GOClassesforGATECS]

DBMS Summary & GATE PYQs: kzbin.info/aero/PLIPZ2_p3RNHh3otU-TnAK-GkqrvvOO33C&feature=shared

[@mehreenhashmi142]

@@GOClassesforGATECS what about magnetic disk?

[@shreyanshlodha1220]

It's a humble request sir Please upload a revision lecture for File indexing and transaction concurrency control

[@Dettol_Vodka]

Thanks a ton for this, to the whole GO team.

[@thanuj2720]

sir, will you upload summary for file organization and indexing ? and thank you deepak sir.

[@mohitrola9665]

Deepak Sir is All Rounder of GATE : ) Thank You Sir.

[@siddharajmali2307]

Respect++ , just amazing :)

[@mathswalaguru5543]

1:58:00 There is one more candidate key BCD, means the C is a prime attribute and Relation 3NF me h tell me if i am wrong

[@GOClassesforGATECS]

01:58:00, BCD is not a candidate key, because BD is a candidate key. Proper superset of a candidate key is never a candidate key.

[@kartikahluwalia152]

Thankyou sirji it was a great recap Can u please make a similar one shot for sql and relational algebra as well before gate would help a lot sir Thankyou once again

[@GOClassesforGATECS]

Already made SQL, Relational Algebra Complete Summary.. Link in description

[@kartikahluwalia152]

Ok sir thankyou👍

[@GOClassesforGATECS]

DBMS Complete Summary & GATE PYQs - kzbin.info/aero/PLIPZ2_p3RNHh3otU-TnAK-GkqrvvOO33C&feature=shared

[@avirup_01]

Sir, if possible, kindly share the link for the proof also for the corollary following the relation to be in 3NF but not in BCNF.

[@GOClassesforGATECS]

Proof of the Theorem at 03:16:49 can be found here (See Deepak Poonia's Answer, it contains the Proof): gateoverflow.in/150945/3nf-with-no-overlapping-candidate-keys-is-in-bcnf?show=435687#a435687

[@avirup_01]

@ Thank you for everything GoClasses and Deepak bhaiya.

[@Kyurious18]

go classes ko digital board m shift ho jana chahiye ab to, hum students ko aur acha experience milta

[@GOClassesforGATECS]

Annotated Notes of this lecture: vcdn.spayee.in/spees/w/o/60e975430cf20278db21ff30/v/678267e9c5ff941561d648d3/u/60f992c50cf2de5e291c3afd/p/assets/pdfs/2025/01/11/678267e9c5ff941561d648d3/678267e9c5ff941561d648d3_original.pdf?Expires=1736605557&Signature=YSWgOR0B5GNw4bbP-5jegyotyxfnxkBZhn0-Two03gnQxbychiF515pI4Tax-9JeZvM~VGSqTYq2NDg5Aa1bp~ok-WjJuyHfQueNfX8oafbFbuVfKY7ebdWoUowXfuzhCy4c5T-QLZ~LYLvQ~inppPhneGWAQs2JkQOJkFQZhSSjgzsKK8jA-HcXOd~SCiwCd-ry0eAD-fqbNWJOWL-Q2F7GPieRokEoVunNqr9EsEJDfEcbtbIlrlrfks43j06Ku-prV8Mt5bHxcYS8RajRdA896ve-kGNQktRYuK3fgRlU69e3jfXmX52BlzSj6ZLR-eQ4wu8GkU4fbJ7uSSNecw__&Key-Pair-Id=APKAW3MHMK54TM3QKYNH

[@GOClassesforGATECS]

DBMS Complete Summary & GATE PYQs - kzbin.info/aero/PLIPZ2_p3RNHh3otU-TnAK-GkqrvvOO33C&feature=shared

[@GOClassesforGATECS]

Annotated Notes of this lecture: shorturl.at/eQmV4

[@GOClassesforGATECS]

DBMS Complete Summary & GATE PYQs - kzbin.info/aero/PLIPZ2_p3RNHh3otU-TnAK-GkqrvvOO33C&feature=shared

[@arpitbisen9419]

C and data structure good practice questions session pls sir

[@VivekVijayan-fu4yp]

Sir, Kindly upload the annotated notes of this session.

[@GOClassesforGATECS]

Annotated Notes of this lecture: vcdn.spayee.in/spees/w/o/60e975430cf20278db21ff30/v/678267e9c5ff941561d648d3/u/60f992c50cf2de5e291c3afd/p/assets/pdfs/2025/01/11/678267e9c5ff941561d648d3/678267e9c5ff941561d648d3_original.pdf?Expires=1736605557&Signature=YSWgOR0B5GNw4bbP-5jegyotyxfnxkBZhn0-Two03gnQxbychiF515pI4Tax-9JeZvM~VGSqTYq2NDg5Aa1bp~ok-WjJuyHfQueNfX8oafbFbuVfKY7ebdWoUowXfuzhCy4c5T-QLZ~LYLvQ~inppPhneGWAQs2JkQOJkFQZhSSjgzsKK8jA-HcXOd~SCiwCd-ry0eAD-fqbNWJOWL-Q2F7GPieRokEoVunNqr9EsEJDfEcbtbIlrlrfks43j06Ku-prV8Mt5bHxcYS8RajRdA896ve-kGNQktRYuK3fgRlU69e3jfXmX52BlzSj6ZLR-eQ4wu8GkU4fbJ7uSSNecw__&Key-Pair-Id=APKAW3MHMK54TM3QKYNH

[@prasannakumar423]

sir please provide annotated notes

[@GOClassesforGATECS]

Annotated Notes of this lecture: vcdn.spayee.in/spees/w/o/60e975430cf20278db21ff30/v/678267e9c5ff941561d648d3/u/60f992c50cf2de5e291c3afd/p/assets/pdfs/2025/01/11/678267e9c5ff941561d648d3/678267e9c5ff941561d648d3_original.pdf?Expires=1736605557&Signature=YSWgOR0B5GNw4bbP-5jegyotyxfnxkBZhn0-Two03gnQxbychiF515pI4Tax-9JeZvM~VGSqTYq2NDg5Aa1bp~ok-WjJuyHfQueNfX8oafbFbuVfKY7ebdWoUowXfuzhCy4c5T-QLZ~LYLvQ~inppPhneGWAQs2JkQOJkFQZhSSjgzsKK8jA-HcXOd~SCiwCd-ry0eAD-fqbNWJOWL-Q2F7GPieRokEoVunNqr9EsEJDfEcbtbIlrlrfks43j06Ku-prV8Mt5bHxcYS8RajRdA896ve-kGNQktRYuK3fgRlU69e3jfXmX52BlzSj6ZLR-eQ4wu8GkU4fbJ7uSSNecw__&Key-Pair-Id=APKAW3MHMK54TM3QKYNH

[@aspirant0491]

please upload AN sir

[@GOClassesforGATECS]

Annotated Notes of this lecture: vcdn.spayee.in/spees/w/o/60e975430cf20278db21ff30/v/678267e9c5ff941561d648d3/u/60f992c50cf2de5e291c3afd/p/assets/pdfs/2025/01/11/678267e9c5ff941561d648d3/678267e9c5ff941561d648d3_original.pdf?Expires=1736605557&Signature=YSWgOR0B5GNw4bbP-5jegyotyxfnxkBZhn0-Two03gnQxbychiF515pI4Tax-9JeZvM~VGSqTYq2NDg5Aa1bp~ok-WjJuyHfQueNfX8oafbFbuVfKY7ebdWoUowXfuzhCy4c5T-QLZ~LYLvQ~inppPhneGWAQs2JkQOJkFQZhSSjgzsKK8jA-HcXOd~SCiwCd-ry0eAD-fqbNWJOWL-Q2F7GPieRokEoVunNqr9EsEJDfEcbtbIlrlrfks43j06Ku-prV8Mt5bHxcYS8RajRdA896ve-kGNQktRYuK3fgRlU69e3jfXmX52BlzSj6ZLR-eQ4wu8GkU4fbJ7uSSNecw__&Key-Pair-Id=APKAW3MHMK54TM3QKYNH

[@rahulchukka704]

Please upload the ann notes for this session.

[@GOClassesforGATECS]

Annotated Notes of this lecture: vcdn.spayee.in/spees/w/o/60e975430cf20278db21ff30/v/678267e9c5ff941561d648d3/u/60f992c50cf2de5e291c3afd/p/assets/pdfs/2025/01/11/678267e9c5ff941561d648d3/678267e9c5ff941561d648d3_original.pdf?Expires=1736605557&Signature=YSWgOR0B5GNw4bbP-5jegyotyxfnxkBZhn0-Two03gnQxbychiF515pI4Tax-9JeZvM~VGSqTYq2NDg5Aa1bp~ok-WjJuyHfQueNfX8oafbFbuVfKY7ebdWoUowXfuzhCy4c5T-QLZ~LYLvQ~inppPhneGWAQs2JkQOJkFQZhSSjgzsKK8jA-HcXOd~SCiwCd-ry0eAD-fqbNWJOWL-Q2F7GPieRokEoVunNqr9EsEJDfEcbtbIlrlrfks43j06Ku-prV8Mt5bHxcYS8RajRdA896ve-kGNQktRYuK3fgRlU69e3jfXmX52BlzSj6ZLR-eQ4wu8GkU4fbJ7uSSNecw__&Key-Pair-Id=APKAW3MHMK54TM3QKYNH

[@KaranSuthar_28]

Where are the slides of the lecture (annotated notes). Please provide

[@GOClassesforGATECS]

Annotated Notes of this lecture: vcdn.spayee.in/spees/w/o/60e975430cf20278db21ff30/v/678267e9c5ff941561d648d3/u/60f992c50cf2de5e291c3afd/p/assets/pdfs/2025/01/11/678267e9c5ff941561d648d3/678267e9c5ff941561d648d3_original.pdf?Expires=1736605557&Signature=YSWgOR0B5GNw4bbP-5jegyotyxfnxkBZhn0-Two03gnQxbychiF515pI4Tax-9JeZvM~VGSqTYq2NDg5Aa1bp~ok-WjJuyHfQueNfX8oafbFbuVfKY7ebdWoUowXfuzhCy4c5T-QLZ~LYLvQ~inppPhneGWAQs2JkQOJkFQZhSSjgzsKK8jA-HcXOd~SCiwCd-ry0eAD-fqbNWJOWL-Q2F7GPieRokEoVunNqr9EsEJDfEcbtbIlrlrfks43j06Ku-prV8Mt5bHxcYS8RajRdA896ve-kGNQktRYuK3fgRlU69e3jfXmX52BlzSj6ZLR-eQ4wu8GkU4fbJ7uSSNecw__&Key-Pair-Id=APKAW3MHMK54TM3QKYNH

[@chomskyinequality]

sir notes link please!

[@GOClassesforGATECS]

Annotated Notes of this lecture: vcdn.spayee.in/spees/w/o/60e975430cf20278db21ff30/v/678267e9c5ff941561d648d3/u/60f992c50cf2de5e291c3afd/p/assets/pdfs/2025/01/11/678267e9c5ff941561d648d3/678267e9c5ff941561d648d3_original.pdf?Expires=1736605557&Signature=YSWgOR0B5GNw4bbP-5jegyotyxfnxkBZhn0-Two03gnQxbychiF515pI4Tax-9JeZvM~VGSqTYq2NDg5Aa1bp~ok-WjJuyHfQueNfX8oafbFbuVfKY7ebdWoUowXfuzhCy4c5T-QLZ~LYLvQ~inppPhneGWAQs2JkQOJkFQZhSSjgzsKK8jA-HcXOd~SCiwCd-ry0eAD-fqbNWJOWL-Q2F7GPieRokEoVunNqr9EsEJDfEcbtbIlrlrfks43j06Ku-prV8Mt5bHxcYS8RajRdA896ve-kGNQktRYuK3fgRlU69e3jfXmX52BlzSj6ZLR-eQ4wu8GkU4fbJ7uSSNecw__&Key-Pair-Id=APKAW3MHMK54TM3QKYNH

[@itz_me_imraan02]

Undecidability summary lectures plz ?

[@GOClassesforGATECS]

Already available on Goclasses KZbin channel.