Based on the attributes described, am I going down the right path to identifying

Question

Based on the attributes described, am I going down the right path to identifying the determinants?

relation provided: COURSE(CourseNumber, CourseName, CourseSection, TeacherName, ScheduledDay, ScheduledHour, ClassRoom, StudentNumber, StudentName, Grade)

The attributes can be described as There are certain functional dependencies are known.

Each class has a unique teacher

My conclusion: class determines teacher

Only one course can meet in a given scheduled hour in a particular room

My conclusion (Room, hour) determine course

A teacher can be in only one room at a given hour

My conclusion: (Room, hour) determines teacher

A student can be in only one room at a given hour

My conclusion: (Room, hour) determine student

A student only gets one grade in a course

My conclusion: (Student, Course) determine grade

Assume that TeacherName is unique. That is, no two teachers have the same name.

Explanation / Answer

Well, this is clear and given relations are absolutely sufficient to identify the determinats.

Each class has unique teacher. So based on the class attribute we can identify who(teacher) is currently in the class.

Example:class 8 determines teacher Alice which is unique.

Class Room and the hour determines course in the class.

Example: Room 10B and time(hour) gives or identifies the course 'History';

So based on this we can determines teacher(History teacher) who is teaching the students in the class 8 and in the Room 10B at 2 in the afternoon.

This is really a well-defined relatinal database scheme.

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.