Week6 - Multi-valued Dependencies and Fourth Normal Form / Assess

The questions can come in any order, so make sure you are selecting right option for all questions.

1. Below we have a college enrolment table:

s_id	course	hobby
1	Science	Cricket
1	Maths	Hockey
2	C#	Cricket
2	Php	Hockey

Answer the following questions

Question 1
In the provided example, what are the attributes of the relation?

(a) s_id, course, hobby

Question 2
How many courses does student with s_id 1 take in the given example?

(b) Two

Question 3
How many hobbies does student with s_id 1 take in the given example?

(b) Two

Question 4
What problem arises due to the multi-valued dependency in the example?

(a) Redundancy of data

Question 5
How many records are created for a student taking two courses and having two hobbies due to the multi-valued dependency?

(d) 4

Question 6
In the table above, there is no relationship between the columns course and hobby. They are independent of each other. State True or False

(a) TRUE

Question 7
To make the above relation satify the 4th normal form, we can decompose the table into _____ tables.

(a) 2

2. In a relation R(A, B, C), if there is a multi-valued dependency between A and B, what condition should be satisfied?

(b) B and C should be independent of each other

3. How many columns should a table have to have a multi-valued dependency?

(b) At least 3 columns