The Table Schema STUDENT Is Replaced by the Following Two $Table1\\\begin{array}{|l|l|l|}\hline \text { NAME } & \text { AGE } & \text { MAJOR } \\\hline\end{array}$

question 69

Multiple Choice

The table schema STUDENT is replaced by the following two tables' schemas: $Table1\\\begin{array}{|l|l|l|}\hline \text { NAME } & \text { AGE } & \text { MAJOR } \\\hline\end{array}$

$Table2\\\begin{array}{|l|l|}\hline \text { MAJOR } & \text { MINOR } \\\hline\end{array}$

• A) Some information is lost in this transformation and some meaningless information is provided
• B) The new tables provide the same information as the old ones with less data duplication
• C) The new tables provide the same information as the old ones with more data duplication
• D) None of the above