Quiz

Relational Database Design and Modeling for Software Engineers

0% completed

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!