December 4, 2011 at 10:00 am
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
My answer was
definition of functional dependencies (FD)
SessionId->From, and SessionId->To
mambId->mambName
ActivityId->ActivityName
coachId->CoachName, activityName
•what is all candidate keys for the relation Sign and choose a primary key
candidate keys membId , activityId , coachId .
•What is the highest normal form to which the relation Sign conforms? Why?
this relation is in first Normal Form
•Normalize the relation Sign to the next higher normal form. Indicate to which normal form(s) the resulting relations now conform? 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 to check it ..?
December 15, 2011 at 10:21 am
selinaalba89 (12/15/2011)
Actually i don't know about this but i think you have to use Google for this to get best answer.
reported as spam
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply