Back to course home
0% completed
Vote For New Content
Quiz
Question 1
Which functional dependency rule states that if A → B and B → C, then A → C?
A
Augmentation
B
Transitivity
C
Reflexivity
D
Union
Question 2
Which of the following determines the closure of an attribute set?
A
Functional dependencies that apply to the attribute set.
B
Primary keys of the table.
C
Relationships between entities.
D
Multivalued attributes in the table.
Question 3
Consider the following relation:
Student_ID | Student_Name | Course_ID | Instructor |
---|---|---|---|
101 | Alice | C101 | Dr. Smith |
102 | Bob | C101 | Dr. Smith |
103 | Charlie | C102 | Dr. Brown |
Which of the following is a valid functional dependency?
Choose all correct options
Student_ID → Student_Name
Course_ID → Student_ID
Student_ID → Instructor
Course_ID → Instructor
Question 4
If
A → B
and B → C
, what is the closure of {A}
?A
{A, B}
B
{A, C}
C
{A, B, C}
D
{A}
Question 5
Which of the following is a trivial functional dependency?
A
A → B
B
{A, B} → C
C
{A, B} → B
D
A → A
Question 6
Given the following relation:
Emp_ID | Dept | Dept_Location |
---|---|---|
1 | HR | New York |
2 | IT | Chicago |
3 | HR | New York |
Identify the functional dependency.
Choose all correct options
Emp_ID → Dept
Dept → Dept_Location
Dept → Emp_ID
Emp_ID → Dept_Location
.....
.....
.....
Like the course? Get enrolled and start learning!
Table of Contents
Contents are not accessible
Contents are not accessible
Contents are not accessible
Contents are not accessible
Contents are not accessible