1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,283
    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,283
    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