Relational Database Design and Modeling for Software Engineers
Ask Author
Back to course home

0% completed

Vote For New Content
Quiz
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

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_IDStudent_NameCourse_IDInstructor
101AliceC101Dr. Smith
102BobC101Dr. Smith
103CharlieC102Dr. 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_IDDeptDept_Location
1HRNew York
2ITChicago
3HRNew 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