හෙනයා;20781890 said:okata machan LMR table kiyala ekak gahaganna one. maha deyak na. column 3ka table ekak gahala wam paththe idan Left Middle Right kiyala column name widihata denna..
ita passe apita dunna kiyala hithamuko mehema relations tikak
R1(A,B,C,D,E,F)
D → EF
CD → A
A → B
dan oke wam paththe witharak thiyena column L paththata daganna. e kiwwe C, D
ita passe dakunu paththe witharakma thiyena column tika R column ekata daganna e kiwwe B, E, F
ithuru tika M column ekata danna.. ithuru wenne A
* dan oya table eke L side eke thiyena tika ANIWA CK ekak wenawa.. e kiwwe (CD)
* R side eke thiyena kisima ekak CK ekak wenna ba..
* Middle side eke thiyena ewa hariyatama kiwa nohaka. e nisa ewage closure eka aragena check karanna wenawa..
danata thiyenne A witharai neh?
A eke closure - AB witharai. anith ewa determine karanna bene. e nisa eka CK ekak wenne na.
hadisiyewath Middle eke dekak thibboth e column deka wena wenama saha ekata aragena closures check karanna wenawa okkoma columns determine karannna puluwanda kiyala.. ex - A B tibboth
A = ......
B = ......
AB = .....
thunak tibboth A B C wage
A = ...
B = ...
C = ...
AB = ...
AC = ...
BC = ...
ABC = ...
* CK eke tiyena attributes walata kiyanne Prime attributes kiyala.. anith ewata kiyanne Non Prime attributes kiyala..
dan emu ganata.
1NF eka satisfy wenna tiyena rule eka thamai table eke value tiyena kotuwe value eka atomic wenna one kiyana eka. e kiwwe values 2 3 k tiyenna ba. dan apita oka check karanna table eka dila nene. e nisa 1NF eka pass kiyala ganna wenawa. ethakota 1NF violate kiyala mokakhari magulak tibboth eka waradi kiyala mark karapan..
2NF eka satisfy wenna tiyena rule eka thamai partial dependencies tiyenna ba. e kiwwe
dan balapan oke CK eka CD neh.. e kiyanne C thaniyen wena mokakatawath functional dependencies tiyenna ba. D walatath ehema ba. thiyenawanam CD ekata inna one. dan ethakota oke D --> EF ekak thiyenawa neh. ? ethakota 2NF eka violate wenawa. ethakota apita dan hithanna wenawa me table eka danata thiyenne 1NF eke kiyala...
habai
(c) The Functional dependency A→ B violates 2 NF.
oya prakashaya waradi.. mokada 2NF eka violate wenne D --> F nisa. A→ B nisa nemei
ganna puluwan ekama uththara
(b) The best normal form of the relation R1 satisfies is 1 NF.
(e) The Functional dependency A→ B violates 3 NF.
ahh (e) eka pahadili karoth 3NF violate wenawa Non Prime Attributes athara functional dependencies tibboth. dan oke A B dekama non prime neh? e nisa e deka athara FD tiyenna ba. e nisa 3NF violate wenawa. e nisa ekath hari
ela macho supiri pahadili kirimak

godak issthuthiyi.

