Solved

Figuer:
the Table STUDENTB Has the Following Meaning -The Table STUDENTB Satisfies the Following Normal Form (Choose the May

Question 5

Multiple Choice

Figuer:
The table STUDENTB has the following meaning. A student may have one major only and several minors; the choice of the major and of minors is independent of each other. Each student has a unique name. The table has only one candidate key.
STUDENTB  NAME  MAJOR  MINOR  GREEN  MATH  INFO  GREEN  MATH  MKTG  HONEY  INFO  MATH  HONEY  INFO  MGT  LAMPOC  MKTG  MGT  TAKKER  MKTG  MGT  YONA  INFO  MATH \begin{array} { | l | l | l | } \hline \text { NAME } & \text { MAJOR } & \text { MINOR } \\\hline \text { GREEN } & \text { MATH } & \text { INFO } \\\hline \text { GREEN } & \text { MATH } & \text { MKTG } \\\hline \text { HONEY } & \text { INFO } & \text { MATH } \\\hline \text { HONEY } & \text { INFO } & \text { MGT } \\\hline \text { LAMPOC } & \text { MKTG } & \text { MGT } \\\hline \text { TAKKER } & \text { MKTG } & \text { MGT } \\\hline \text { YONA } & \text { INFO } & \text { MATH } \\\hline\end{array}
-The table STUDENTB satisfies the following normal form (choose the highest NF) :


A) 1NF
B) 2NF
C) 3NF
D) 4NF

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions