Question

Name is the unique candidate key in the table STUDENTC. Each row in the table describes a different student. A student may only have one major and one minor. To each major corresponds a unique minor. Time 37 Mi STUDENTC NAME GREEN HONEY LAMPOC TAKKER YONAR AGE 26 18 33 45 28 MAJOR | MATH INFO MKTG MKTG INFO MINOR INFO MATH MGT MGT ΜΑΤΗ The table STUDENTC contains many more rows than shown. It is replaced by the following two tables with appropriate distribution of data to the new tables. Tablel NAME AGE MAJOR Tahle2 MAJOR MINOR Which of the following is true? Some information is lost in this transformation and some meaningless information is provided The new tables provide the same information as the old one with less data duplication The new tables provide the same information as the old one with more data duplication None of the above

Answer 1

Each row of STUDENTC table describes a different student.
A student may have only one major and one minor
Each mojaor corresponds a unique minor

MINOR is dependent on MAJOR
So if the table STUDENTC is converted to 2 tables :
Table 1 containing NAME, AGE and MAJOR
Table 2 containing MAJOR and MINOR

The new tables will provide the same information as the old one with less data duplication.
Since MINOR is dependent on MAJOR and not on other fields of STUDENTC, so we can remove the fields MAJOR and MINOR from STUDENTC and create a new table, Table 2, with fields MAJOR and MINOR where MAJOR is the primary key of Table 2 and foreign key in Table 1. So no information will be lost.
Data duplication will be less since the data for MINOR will not be duplicated for every record in STUDENTC instead it will be defined only in table Table 2 for each entry of MAJOR and it can be referenced for every row of Table 1 using the reference key MAJOR in Table 1 and Table 2.

Answer - The new tables will provide the same information as the old one with less data duplication.