Hello everyone,
can any one please help me...
having this table and ask as to normalized
Sign(MemberID, MemberName, ActivityID, ActivityName, SessionID, CoachID, CoachName, Day, From, To)
and this is the Scenario
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.
functional dependencies and non-trivial dependencies
My answer was
definition of functional dependencies (FD)
SessionId->From, and SessionId->To
mambId->mambName
ActivityId->ActivityName
coachId->CoachName, activityName
all candidate keys for the relation Sign and choose a primary key
candidate keys membId , activityId , coachId .
the highest normal form to which the relation Sign conforms and Why
this relation is in first Normal Form
Normalize the relation Sign to the next higher normal form. And why?
3NF
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 ..?
Post #1215990
can any one please help me...
having this table and ask as to normalized
Sign(MemberID, MemberName, ActivityID, ActivityName, SessionID, CoachID, CoachName, Day, From, To)
and this is the Scenario
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.
functional dependencies and non-trivial dependencies
My answer was
definition of functional dependencies (FD)
SessionId->From, and SessionId->To
mambId->mambName
ActivityId->ActivityName
coachId->CoachName, activityName
all candidate keys for the relation Sign and choose a primary key
candidate keys membId , activityId , coachId .
the highest normal form to which the relation Sign conforms and Why
this relation is in first Normal Form
Normalize the relation Sign to the next higher normal form. And why?
3NF
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 ..?
Post #1215990
