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

හෙනයා

Well-known member
  • May 23, 2014
    16,875
    17,086
    113
    Kottawa
    baha ehema karanna ba....

    oya ethana return katranne....if( i == 0) return i kiyanne if eke {} athule thmai oya return karanne.....

    ethakota aththatama methoid eken enna one return eka nemei out put eka widiyata ehhen.....

    ekai return error ekak enne.....

    mama liyala thiyena widiya thmai hari widiya......​

    මට මොකුත් print කරගනන් නෙමෙයි ඕනේ.. වෙන විදිහයි දැනගන්න ඕනේ..

    එතකොට අර IF එක ඇතුලේ තියෙන එක return උනාම එක කොහෙටද යන්නේ?

    IF එක ඇතුලේ එකයි method එක අන්තිමට එකයි දැම්මම compile වෙනවා.. හැබැයි වෙන්නේ මොකක්ද කියල තේරුම් ගන්න ඕනේ.. :dull::dull::dull:
     

    Bataya01

    Well-known member
  • Sep 7, 2013
    1,639
    122
    63
    හෙනයා;20768062 said:
    na bn. IF eka athule thiyena return ekata mokada wenne kiyala danaganna one :nerd::nerd::nerd:

    Method eke return type eka int ne ban.ithin umbe body eke hatiyata int ekak return wenne i==0 welawata witharai.
    Eth aththatama method ekak call wunama umba deela thiyana returm type eke value ekak hama welema return wenna one ban.eka wela nathi nisai oya awula.e kiyanne i kiyana value eka 0ta asamana wena kisima welawaka oken value ekak return wenne nane.
     

    KingCM

    Well-known member
  • Jul 23, 2013
    6,920
    948
    113
    www.biogen.lk
    හෙනයා;20768024 said:
    මට මොකුත් print කරගනන් නෙමෙයි ඕනේ.. වෙන විදිහයි දැනගන්න ඕනේ..

    එතකොට අර IF එක ඇතුලේ තියෙන එක return උනාම එක කොහෙටද යන්නේ?

    IF එක ඇතුලේ එකයි method එක අන්තිමට එකයි දැම්මම compile වෙනවා.. හැබැයි වෙන්නේ මොකක්ද කියල තේරුම් ගන්න ඕනේ.. :dull::dull::dull:

    ube method eke return type eka int ne.....

    e kiyanne hama welawema int value ekak reslt eka widiyata yanawanna one.....

    return value eka return wenna one mathod bosy eken.....if else athule...ho for loop athule witrharak thibila madi machan.....

    method body eken final result eka thmai machan anthimata return wenna one....

    if else walin karanne ubata one logic process karala ubata return karanna one karana final result eka generate e karagannawa......

    uba code eka liyala thiyena widiyata if eka athule thiiyena logic eka true unoth witharai result ekak return karanne.....

    ehema ba machan......

    method eken hama welawema final result ekak illanawa.......eka nisa aniwa uba final result ekak yawanna one....

    eth uba eka return karanne if eketrue unoith witharai.......

    ethakota error enewa.....​
     

    simpleboy

    Member
    Mar 8, 2015
    1,641
    109
    0
    2015 DB past paper

    Consider the relation R1 (A, B, C, D, E) with the given Functional Dependencies to answer
    Questions from 26 to 27.
    D→ EF, CD → A, A → B

    26) What is/are the candidate key(s) of the relation R1?
    (a). (C, E)

    (b). (C, A)

    (c). (C, D)

    (d). D

    (e). C

    27) Which of the following statements is/are true?
    (a) The Functional dependency C→ A violates 1 NF.
    (b) The best normal form of the relation R1 satisfies is 1 NF.
    (c) The Functional dependency A→ B violates 2 NF.
    (d) The best normal form of the relation R1 satisfies is 2 NF.
    (e) The Functional dependency A→ B violates 3 NF.



    mekata answer eka ganne kohomada machanla plz help!!!
     
    Last edited:

    හෙනයා

    Well-known member
  • May 23, 2014
    16,875
    17,086
    113
    Kottawa
    ube method eke return type eka int ne.....

    e kiyanne hama welawema int value ekak reslt eka widiyata yanawanna one.....

    return value eka return wenna one mathod bosy eken.....if else athule...ho for loop athule witrharak thibila madi machan.....

    method body eken final result eka thmai machan anthimata return wenna one....

    if else walin karanne ubata one logic process karala ubata return karanna one karana final result eka generate e karagannawa......

    uba code eka liyala thiyena widiyata if eka athule thiiyena logic eka true unoth witharai result ekak return karanne.....

    ehema ba machan......

    method eken hama welawema final result ekak illanawa.......eka nisa aniwa uba final result ekak yawanna one....

    eth uba eka return karanne if eketrue unoith witharai.......

    ethakota error enewa.....​

    :rolleyes::rolleyes::rolleyes: එල එල තැන්ක්ස්.. :cool::cool:
     

    හෙනයා

    Well-known member
  • May 23, 2014
    16,875
    17,086
    113
    Kottawa
    2015 DB past paper

    Consider the relation R1 (A, B, C, D, E) with the given Functional Dependencies to answer
    Questions from 26 to 27.
    D→ EF, CD → A, A → B

    26) What is/are the candidate key(s) of the relation R1?
    (a). (C, E)

    (b). (C, A)

    (c). (C, D)

    (d). D

    (e). C

    27) Which of the following statements is/are true?
    (a) The Functional dependency C→ A violates 1 NF.
    (b) The best normal form of the relation R1 satisfies is 1 NF.
    (c) The Functional dependency A→ B violates 2 NF.
    (d) The best normal form of the relation R1 satisfies is 2 NF.
    (e) The Functional dependency A→ B violates 3 NF.



    mekata answer eka ganne kohomada machanla plz help!!!

    Normalization poddak wath meter nadda bn? eka sahenna loku padamak neh :confused::confused:
     

    simpleboy

    Member
    Mar 8, 2015
    1,641
    109
    0
    හෙනයා;20778107 said:
    Normalization poddak wath meter nadda bn? eka sahenna loku padamak neh :confused::confused:

    Normalization gana idea ekak thiyenawa machan. eth me prassne kiyala thiyena de mata therenne na:( ethala walin kiyanne functional dependency kiyana ekane 1NF,2NF,3NF rules dannawa. eth patalali sahagathayi bn me nikan English letter dapu ekayi awla waguwak wage thibu nanam idea ekak enawa.
     

    හෙනයා

    Well-known member
  • May 23, 2014
    16,875
    17,086
    113
    Kottawa
    Normalization gana idea ekak thiyenawa machan. eth me prassne kiyala thiyena de mata therenne na:( ethala walin kiyanne functional dependency kiyana ekane 1NF,2NF,3NF rules dannawa. eth patalali sahagathayi bn me nikan English letter dapu ekayi awla waguwak wage thibu nanam idea ekak enawa.

    dila tiyena functional dependencies walin candidate key eka hoyanna dannawada? :confused::confused:
     

    simpleboy

    Member
    Mar 8, 2015
    1,641
    109
    0
    හෙනයා;20778362 said:
    dila tiyena functional dependencies walin candidate key eka hoyanna dannawada? :confused::confused:

    D→ EF, CD → A, A → B

    meke machan b , A mathath a ,CD mathath functional dependnt wenawane EF , D matha depend wenawane etha kota okkotama podu wela thienne CD da? eka candidate key ekak kiwwata composite key ekak wage neda ? CD walin pennane column dekakda?
     

    හෙනයා

    Well-known member
  • May 23, 2014
    16,875
    17,086
    113
    Kottawa
    D→ EF, CD → A, A → B

    meke machan b , A mathath a ,CD mathath functional dependnt wenawane EF , D matha depend wenawane etha kota okkotama podu wela thienne CD da? eka candidate key ekak kiwwata composite key ekak wage neda ? CD walin pennane column dekakda?

    ow column dekak thama bn. eth eka candidate key ekak wenawa bn.
     

    හෙනයා

    Well-known member
  • May 23, 2014
    16,875
    17,086
    113
    Kottawa
    D→ EF, CD → A, A → B

    meke machan b , A mathath a ,CD mathath functional dependnt wenawane EF , D matha depend wenawane etha kota okkotama podu wela thienne CD da? eka candidate key ekak kiwwata composite key ekak wage neda ? CD walin pennane column dekakda?

    oya widihata CK hoyanna lesida? lesi nam awlak na. naththam keti kramayak tiyenawa..
     

    simpleboy

    Member
    Mar 8, 2015
    1,641
    109
    0
    හෙනයා;20778466 said:
    oya widihata CK hoyanna lesida? lesi nam awlak na. naththam keti kramayak tiyenawa..

    mokadda machan keti krame ? ethakota ara anik prasneta uththere ganne kohomada?
     

    deshanl

    Junior member
  • Dec 16, 2015
    72
    1
    18
    අලුතෙන් ඇඩිමිෂන් දෙන්නේ කවද්ද,කියලා දන්නේ,නැද්ද බන්
     

    හෙනයා

    Well-known member
  • May 23, 2014
    16,875
    17,086
    113
    Kottawa
    mokadda machan keti krame ? ethakota ara anik prasneta uththere ganne kohomada?

    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