finding Functional Dependencies!

I'm having trouble identifying the functional dependencies!

relation schema is
SCHEDULE = {course, teacher, time, room}

What are the functional dependencies for:

The same course is always taught by the same teacher?
Different courses can never be taught in the same room at the same time?
The same lecturer can never teach in different rooms at the same time?

Cheers.

2

Contributors

1

Reply

2 Weeks

Discussion Span

1 Year Ago

Last Updated

2

Views

thompsonSensibl

Light Poster

36 posts since Apr 2010

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

1 Year Ago

0

The same course is always taught by the same teacher?
0ne Course is taught by one teacher so Course is dependent on the teacher, so u get one dependency

Rest you can resolve

Divyab

Newbie Poster

10 posts since Dec 2009

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

finding Functional Dependencies!

This article has been dead for over three months: Start a new discussion instead