Normalization Help Urgent

Minty's Avatar, Join Date: Oct 2007
Newbie Member
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
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Its already in the NF form
0
Minty's Avatar, Join Date: Oct 2007
Newbie Member
how !! i made my erd then re !!
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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

Code:
envelope(ENID, ENDPTNAME, ENRECIVEDATE,

evaluation(EVID, EVDATE, EVENDDATE)

report(RID, RDEPT, RDATE)
Just need to change the following.