normalization 6

This is one whole quiz. It is based the attached table. I didn’t well on it. Can someone explain them to me.

Does this table follow “the golden rule of normalization”?

A)No -null values and redundant data.

B)Yes -each row is unique.

C))Yes -primary key present.

D)No- null values absent and complementary data.

Given the data in the table a possible natural primary key for this table would be:

A) there is none

B)student, email, and instructor

C)student, email, and class

D)student, email, and day

E)instructor, phone

Given the data in the table what may be the most pragmatic way to group the data into entities?

A)Entity1(student,email) Entity2(class,days,time) Entity3(instructor,phone)

B)Entity1(student, email, class) Entity2(days,time) Entity3(instructor,phone)

C)Entity1(student,email) Entity2(class,days,time,instructor,phone)

D)Entity1(student) Entity2(email) Entity3(class) Entity4(days) Entity5(time) Entity6(instructor) Entity7(phone)

Given the data in the table which way of grouping the data into entities would provide the highest degree of normalization?

A)Entity1(student) Entity2(email) Entity3(class) Entity4(days) Entity5(time) Entity6(instructor) Entity7(phone)

B)Entity1(student, email, class) Entity2(days,time) Entity3(instructor,phone)

C)Entity1(student,email) Entity2(class,days,time,instructor,phone)

D)Entity1(student,email) Entity2(class,days,time) Entity3(instructor,phone)

Given the data in the table the best surrogate primary key for this table would be:

A)none of the listed attributes

B)student, email, and instructor

C)student, email, and class

D) student, email, and day

E)instructor, phone

Given the data in the table which attributes are possibly not atomic?

A)instructor, student

B)day, time

C)day, course

D)email, phone

E)none of the listed attributes.