Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Normalization Help Urgent (http://www.go4expert.com/forums/normalization-help-urgent-t7119/)

Minty 30Oct2007 19:59

Normalization Help Urgent
 
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 30Oct2007 20:26

Re: Normalization Help Urgent
 
Its already in the NF form

Minty 30Oct2007 20:37

Re: Normalization Help Urgent
 
how !! i made my erd then re !!

shabbir 30Oct2007 21:52

Re: Normalization Help Urgent
 
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.


All times are GMT +5.5. The time now is 01:25.