Question

4. Examine the table shown below and the set of functional dependency on its attributes: Course RmAlloc (CourseId, CourseName, Year, Lecturer, Enrollment, RoomId, RoomCapacity, Day, Time) FD= {CourseId -> CourseName, CourseId, Year -> Lecturer, RoomId -> RoomCapacity, CourseName -> CourseId, CourseId, Year -> Enrollment, RoomId, Year, Day, Time -> CourseId, CS3402 Database Systems Tutorials Courseld, Year, Day, Time -> RoomId} (a) Find all candidate keys of this table. (b) Decompose this table into a design into BCNF. Answer: (a) There are three candidate keys in this table: (Year, Day, Time, CourseId) (Year, Day, Time, CourseName) (Year, Day, Time, RoomId) (b) This table can be decomposed into the following in BCNF (so also in 3NF): Course Teaching (CourseId, Year, Lecturer, Enrollment) Room (RoomId, RoomCapacity) Course RoomAlloc (CourseId, Year, Day, Time, RoomId) Course (CourseId, CourseName)

          4. Examine the table shown below and the set of functional dependency on its
attributes:
Course RmAlloc (CourseId, CourseName, Year, Lecturer, Enrollment, RoomId,
RoomCapacity, Day, Time)
FD= {CourseId -> CourseName,
CourseId, Year -> Lecturer,
RoomId -> RoomCapacity,
CourseName -> CourseId,
CourseId, Year -> Enrollment,
RoomId, Year, Day, Time -> CourseId,
CS3402
Database Systems
Tutorials
Courseld, Year, Day, Time -> RoomId}
(a) Find all candidate keys of this table.
(b) Decompose this table into a design into BCNF.
Answer:
(a) There are three candidate keys in this table:
(Year, Day, Time, CourseId)
(Year, Day, Time, CourseName)
(Year, Day, Time, RoomId)
(b) This table can be decomposed into the following in BCNF (so also in 3NF):
Course Teaching (CourseId, Year, Lecturer, Enrollment)
Room (RoomId, RoomCapacity)
Course RoomAlloc (CourseId, Year, Day, Time, RoomId)
Course (CourseId, CourseName)

4. Examine the table shown below and the set of functional dependency on its
attributes:
Course RmAlloc (CourseId, CourseName, Year, Lecturer, Enrollment, RoomId,
RoomCapacity, Day, Time)
FD= CourseId -> CourseName,
CourseId, Year -> Lecturer,
RoomId -> RoomCapacity,
CourseName -> CourseId,
CourseId, Year -> Enrollment,
RoomId, Year, Day, Time -> CourseId,
CS3402
Database Systems
Tutorials
Courseld, Year, Day, Time -> RoomId
(a) Find all candidate keys of this table.
(b) Decompose this table into a design into BCNF.
Answer:
(a) There are three candidate keys in this table:
(Year, Day, Time, CourseId)
(Year, Day, Time, CourseName)
(Year, Day, Time, RoomId)
(b) This table can be decomposed into the following in BCNF (so also in 3NF):
Course Teaching (CourseId, Year, Lecturer, Enrollment)
Room (RoomId, RoomCapacity)
Course RoomAlloc (CourseId, Year, Day, Time, RoomId)
Course (CourseId, CourseName)

Added by Rickey M.

Question

Please give Ace some feedback