1nf normalization example | Decomposition | DBMS | Lec-49 | Bhanu Priya

Data base management Systems ( DBMS )
normalisation 1nf understanding and applying first normal form decomposition

Class Notes ( pdf )

Complete DBMS Course Playlist :

[sukanchoudhary]

if you are using primary key on student id then you can not use duplicate value on student id like you are using 123, 123, 124, 124 . because student id is primary key.

[artworkofficial]

Normalisaton is explained very nicely. Great madam....

[deusamor]

Thank you so much madam. Your lectures helped me to clear my exam today.... loads of loves and hugs to you 🤗❤💖💕💗💓

[shehrazatta]

Yeah this video is also helpful for me like others videos thanks for your help in study

[janapatimanikanta]

if studentid is primary key then duplicate values are not allowed

[maxinteltech]

Confusing to me. The normalized table had redundancy not the original one!

[PeterParker-sbrq]

In decomposition first point 6:04, new table or new tuple?

[Atul_Saraswat]

A lot of thanks to u
I don't know who's and about u
But whomever u r, u r doing well
And keep it on, u also helped me a lot by your provided videos
One thing which is very clear to all that no one is perfect in their respective field may be he/she has good knowledge but no one is perfect but whatever u r doing
It's appreciable
One thing which I like most in your answers that is your answer in the form of points which helped alot to get good marks
Becoz points are easy to read and learn than theory
So, finally I will say thanks to u
And best of luck👍👍

[ShivamGupta-puks]

thanks for the videos
this was very useful for me
thanks again education 4u

[shahidparvez]

How you take the st-id as primary key because p.k should not repeate in a column.

[sridhardurairaj]

Thank mam for uploading this video. I think It will help to my exams

[memefulland]

whats the primary key in 1st example, wrong hai 1st example

[najiaibrahim]

Mam pls tell me the repeated qstns in final exam

[hharitha]

Mam ur super I always search for ur videos only tq so much mam .

[ShwetaSingh-gzds]

Ur first example was already normalised

[ShwetaSingh-gzds]

Course cant b primary key now. It is repetitive