smiley4080 0 Newbie Poster

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-trivial dependencies

•what is all candidate keys for the relation Sign and choose a primary key

•What is the highest normal form to which the relation Sign conforms? Why?


•Normalize the relation Sign to the next higher normal form. Indicate to which normal form(s) the resulting relations now conform? And why?


My answer was

definition of functional dependencies (FD)

SessionId->From, and SessionId->To

mambId->mambName

ActivityId->ActivityName

coachId->CoachName, activityName

candidate keys membId , activityId , coachId .

and this relation is in first Normal Form
and this what i did Is this correct

Sign(MemberID, ActivityID, SessionID, CoachID )
Member (MemberID, MemberName)
Activity (ActivityID, ActivityName, Description)
ActivitySession ([sessionID, ActivityID)
Session (SessionID, Day, From, To)
Coach (CoahID, Coach Name)


Can any Body help me to understood this problem..?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.