1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Normalization Help Urgent

Discussion in 'Database' started by Minty, Oct 30, 2007.

  1. Minty

    Minty New Member

    Joined:
    Oct 30, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    hi i need an urgent response to this thread plz... !!

    very few hours are left for my assignment submission... !! i need help to get this relational aljebra in 1NF , 2NF and 3NF

    here it is ::

    _______________________________________________

    survey(SID, SDATE, STIME)
    surveypeople(SPID, SPNAME, SPEMAIL, SPPHONE)
    survey-surveypeople(SID,SPID)

    envelope(ENID, SID, ENDPTNAME, ENRECIVEDATE,

    teacher(TID, TNAME, TPHONE,TEMAIL, TADDRESS)
    evaluation(EVID, TID, EVDATE, EVENDDATE)

    record(REID, REDATE, RSTATUS)
    report(RID, REID, RDEPT, RDATE)

    ________________________________________________

    PLEASE SHOW ME STEP BY STEP 1NF , 2NF AND 3NF

    comon help me dudes
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    Its already in the NF form
     
  3. Minty

    Minty New Member

    Joined:
    Oct 30, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    how !! i made my erd then re !!
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    As looking into the system you just need to be removing some un-necessary id's

    Code:
    envelope(ENID, ENDPTNAME, ENRECIVEDATE,
    
    evaluation(EVID, EVDATE, EVENDDATE)
    
    report(RID, RDEPT, RDATE)
    Just need to change the following.
     

Share This Page