BIT කරන අය එන්න මෙතෙන්ට

simpleboy

Member
Mar 8, 2015
1,641
109
0
හෙනයා;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:):yes: godak issthuthiyi.:)
 

හෙනයා

Well-known member
  • May 23, 2014
    16,875
    17,086
    113
    Kottawa
    ela macho supiri pahadili kirimak:):yes: godak issthuthiyi.:)

    11.gif
     

    pranathlcp

    Well-known member
  • Jul 19, 2009
    5,839
    1,293
    113
    Hogwarts School of Witchcraft and Wizardry
    SEM 2 admisison dala. mata kawruhari COLOMBO ST. PETER'S COLLEGE, ekata yana widiya kiyanawada kotuwe idala??

    කොටුවෙන් පානදුරට/මොරටුවට වගේ යන බස් එකක් ගන්න..ඕක Duplication Road එකේ ගිහින් වැල්ලවත්තෙන් හරවනවා Galle Road ඒකට..ඒ හරවපු ගමන්ම බැහැල, ආපහු කොළඹ පැත්තට මීටර් 100 ක් විතර පයින් එන්න (Galle Road එකේ)..එතකොට තියෙනවා St. Peters එක...
     

    BadBlueGenius

    Well-known member
  • Jun 11, 2014
    5,550
    6,534
    113
    කොටුවෙන් පානදුරට/මොරටුවට වගේ යන බස් එකක් ගන්න..ඕක Duplication Road එකේ ගිහින් වැල්ලවත්තෙන් හරවනවා Galle Road ඒකට..ඒ හරවපු ගමන්ම බැහැල, ආපහු කොළඹ පැත්තට මීටර් 100 ක් විතර පයින් එන්න (Galle Road එකේ)..එතකොට තියෙනවා St. Peters එක...

    thanks machan
     

    VPS09

    Well-known member
  • Sep 13, 2014
    6,729
    2,139
    113
    maharagama
    Machanla SLIATE HNDIT giya awrudde karapu, 1ka subject ekak vitarak repeat liyala Next month result enna tiyena yaluwek innawa,

    ENGLISH subject eka thamai repeat wela tiyenne. eka giya sem eke karala NOV result enakam BIT apply karanna barida ?? Ilaga awrudda wenakam ina wenawada ?

    1ka subject ekaka vitarak result pending tiyala Moratuwa BIT exemption apply karanna bari da ? :oo:
     

    VPS09

    Well-known member
  • Sep 13, 2014
    6,729
    2,139
    113
    maharagama
    Anit prasne thamai SLIATE HNDIT karapu kenekta 1 and Half year BIT karanna wenawada ?

    natnm 3rd year eka vitarada karanna one BIT wala ??
     

    VPS09

    Well-known member
  • Sep 13, 2014
    6,729
    2,139
    113
    maharagama
    Machanla SLIATE HNDIT giya awrudde karapu, 1ka subject ekak vitarak repeat liyala Next month result enna tiyena yaluwek innawa,

    ENGLISH subject eka thamai repeat wela tiyenne. eka giya sem eke karala NOV result enakam BIT apply karanna barida ?? Ilaga awrudda wenakam ina wenawada ?

    1ka subject ekaka vitarak result pending tiyala Moratuwa BIT exemption apply karanna bari da ? :oo:

    kaurut danne nadda