Member Avatar for thompsonSensibl

I'm having trouble identifying the functional dependencies!

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

What are the functional dependencies for:

  1. The same course is always taught by the same teacher?

  2. Different courses can never be taught in the same room at the same time?

  3. The same lecturer can never teach in different rooms at the same time?

Cheers.

  • 2 Contributors
  • 1 Reply
  • 110 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by Divyab
Member Avatar for Divyab

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

Be a part of the DaniWeb community

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