How To normlization?

S

sikisajko

New Member
In exam I got this Question can any body explain it to me....Sign(MemberID, MemberName, ActivityID, ActivityName, SessionID, CoachID, CoachName, Day, From, To)The table Sign record the enrolment information of sports club members in sports activities. The information recorded are the the member name, member id, the activity name, the activity id, a session id that is unique within the same activity, the day, start and end times of the activity session enrolled, and the id and name of the coach supervising the activity session. Each session must be supervised by only one coach and the duration of all activity sessions is one hour.
  • what is functional dependencies that covers all the non-trivialdependencies
  • what is all candidate keys for the relation Sign and choose aprimary key
  • What is the highest normal form to which the relation Signupconforms? Why?
  • Normalize the relation Signup to the next higher normal form. Indicate to which normal form(s) the resulting relations nowconform? And why?
My answer was definition of functional dependencies (FD)mambId->mambNameActivityId->ActivityNameActivityId->SessionId, DayActivityId->from, tocoachId->CoachNamecoachId->activityNameCoach->Session, daycouach->from,tocandidate keysmembId , activityId , coachId .anmd this relation is in Dirst Normal Form Can any Body help me to understood this problem..?
 
You must log in or register to reply here.
Back
Top