[Minty]

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

[shabbir]

Its already in the NF form

[Minty]

how !! i made my erd then re !!

[shabbir]

Quote:

Originally Posted by Minty

how !! i made my erd then re !!

As looking into the system you just need to be removing some un-necessary id's

envelope(ENID, ENDPTNAME, ENRECIVEDATE,

evaluation(EVID, EVDATE, EVENDDATE)

report(RID, RDEPT, RDATE)

Just need to change the following.