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
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.