Here is a table for classes at a college, with numbered time periods in each day
ID: 3837420 • Letter: H
Question
Here is a table for classes at a college, with numbered time periods in each day:
Name
Department
Room
Period
Java 1
CS
100
5
Java 2
CS
110
4
Data Structures
CS
100
6
Calc 1
Math
350
6
Calc 2
Math
390
6
Linear Algebra
Math
350
4
a.Find a functional dependency (FD) with one attribute (other than Name) on each side that holds for this instance.
b. Disprove the proposed FD “department period -> room”
c. Find a single-column key and a multi-column key that hold for this instance
Name
Department
Room
Period
Java 1
CS
100
5
Java 2
CS
110
4
Data Structures
CS
100
6
Calc 1
Math
350
6
Calc 2
Math
390
6
Linear Algebra
Math
350
4
Explanation / Answer
b) period -> room doesnt satisfy FD property as
one room is not assign to one single period
as room 100 assign to period 5 and 6
and room 350 to 4 and 6
a) department -> room
if room is 100 then there is only one department cs to that room and if room is 350 then Math is only department there
c)
single column key is JAVA
multi column key there are multiple option
1) NAme department and room