In exam I acquired this can any body explain it in my experience....

Sign(MemberID, MemberName, ActivityID, ActivityName, SessionID, CoachID, CoachName, Day, From, To)

The table Sign record the enrolment information of sports club people in sporting activities. The data recorded would be the the member title, member id, the game title, the game id, a session id that's unique inside the same activity, your day, start and finish occasions from the activity session enrolled, and also the id and title from the coach supervisory the game session. Each session should be supervised by just one coach and also the amount of all activity periods is a hour.

  • what's functional dependencies that covers all of the non-trivial dependencies

  • what's all candidate secrets for that relation Sign and select a primary key

  • What's the greatest normal form that the relation Register adjusts? Why?

  • Normalize the relation Register to another greater normal form. Indicate that normal form(s) the resulting relations now conform? And why?

My answer was

meaning of functional dependencies (FD)

mambId->mambName

ActivityId->ActivityName

ActivityId->SessionId, Day

ActivityId->from, to

coachId->CoachName

coachId->activityName

Coach->Session, day

couach->from,to

candidate secrets membId , activityId , coachId .

anmd this relation is within Dirst Normal Form

Can any Body assist me to to understood this issue..?

ActivityId->SessionId, Day

I believe this really is wrong, but it is just a little difficult to tell from that which you published.

The data recorded are ... the game id, a session id that's unique inside the same activity, your day, start and finish occasions from the activity session enrolled, ...

I'd interpret that to mean a task (like "soccer") has multiple periods. Let us the activity "soccer" has 12 periods. Maybe 5 seem to be on Monday, 5 take presctiption Wednesday, and a pair of take presctiption Friday. If that is the situation, SessionId->Day, but ActivityId doesn't.

From that, the result is that SessionId->From, and SessionId->To.

But either you and your professor needs to inform us how you can interpret what you've written. We can not really go any more not understanding this.