Use the table of three columns A, B, and C and three rows of data below to answe

ID: 3597239 • Letter: U

Question

Use the table of three columns A, B, and C and three rows of data below to answer questions 3.1~3.5.

3.1 C depends on A. (True or False)

3.2 B determines A. (True or False)

3.3 A does not determine B. (True or False)

3.4 A depends on (B, C). (True or False)

3.5 Neither B nor C could be a determinant but A could. (True or False)

3.6 If A is the primary key, this table is not 3NF. (True or False)

3.7 If (B, C) is the primary key, this table is 2NF. (True or False)

3.8 If the lower left corner value 3 is changed to 2,

then A and C depend on each other. (True or False)

3.9 If the lower left corner value 3 is changed to 2,

then the primary key must be a compound key. (True or False)

3.10 If the lower left corner value 3 is changed to 2,

then we can choose (A, C) to be the primary key. (True or False

3.1 True. The reason is we can derive C from A.

3.2 False. The reason is we cannot uniquely determine A from B as the value of 2 is determining 1 as well as 3.

3.3 False. The reason is it is uniquely determining B

3.4 True. The reason is it is uniquely determining.

3.5 True as A is having unique values.

3.6 True as it is in 3NF.

3.7 True as it is in 2NF.

3.8 True as each one determines the other.

3.9 True as A and C will uniquely determine the remaining values.

3.10 True as they will uniquely determine the remaining values

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.