Тёмный

Questions On Second Normal Form(2NF) 

Javatpoint
Подписаться 180 тыс.
Просмотров 11 тыс.
50% 1

How to identify 2NF in Relational Schema

Опубликовано:

 

18 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 11   
@mnaresh3382
@mnaresh3382 5 месяцев назад
I think the answer is not 6 but instead 5, since we don't really need a separate table for R(WY) bcz it is not violating the rule of 2NF, we can just add these attributes to the table R(PSVW XY) this is going to introduce any issue since PS is the candidate key of this relation and it can uniquely identify all other attributes of that relation and w->y is not partially depended on the candidate key PS, so the correct answer should be "NO & 5"
@tushaamagrawal3072
@tushaamagrawal3072 5 месяцев назад
But W itself is determining Y...This is also case of partial dependency since Y is dependent on a non prime attribute which is not even a part of Candidate key. It should have been dependent on PQS. Hence we would need to make a seperate table for it too.
@mnaresh3382
@mnaresh3382 5 месяцев назад
I agree the fact that we still have to separate the table, as you said W is not a prime attribute, but it is determining some other non prime attribute, this does not violate 2NF condition but violates 3NF condition, 2NF speaks only for partial dependency but this is a transitive dependency.
@EnglsihCommByNawaz
@EnglsihCommByNawaz 2 года назад
Thanks Sir! Learn alot from this video!
@premkumarreddy6893
@premkumarreddy6893 26 дней назад
thanks
@varshaeluru9816
@varshaeluru9816 10 месяцев назад
Thank you so much sir
@Karma-nc3kg
@Karma-nc3kg 9 месяцев назад
hello bro in last sloved problem i have a doubt
@samandeepkaur6112
@samandeepkaur6112 11 месяцев назад
Thank you
@b-43-pawankadwadkar96
@b-43-pawankadwadkar96 Год назад
Thanks a lot ❤
@EnglsihCommByNawaz
@EnglsihCommByNawaz 2 года назад
Thanks sir
@manasvi4586
@manasvi4586 2 года назад
thankyou sir
Далее
Questions To Identify 3NF
11:12
Просмотров 6 тыс.
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Database Normalisation: Second Normal Form
9:21
Просмотров 156 тыс.
Veri Tabanı Normalizasyon (Nomal Form'lar) Ek Video
25:33
Keys in RDBMS
22:49
Просмотров 331 тыс.
BCNF in Normalization
8:51
Просмотров 3,2 тыс.
4.7 How to Decompose a relation into 2NF
15:47
Просмотров 363 тыс.
Normalization - 1NF, 2NF, 3NF and 4NF
19:02
Просмотров 2,2 млн