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}$

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