Question: a . The GROUP _ MEMBER table below has the functional dependency Last _ Name - - > Group# but has no other additional functional

a. The GROUP_MEMBER table below has the functional dependency Last_Name--> Group# but has no other additional functional dependencies, which of the statements about data normal forms is correct?GROUP_MEMBER (First Name, Last Name, Group#) The MEMBER table is in 3NF.
The MEMBER table is in 1NF but not in 2NF.
The MEMBER table is in 2NF but not in 3NF.
The MEMBER table is not in 1NF.
b.Consider the PRODUCT table in the clothing store database on that handout: If it has the functional dependency Price-Discount but has no other additional functional dependencies, which of the statements about data normal forms is correct?
The PRODUCT table is in 3NF.
The PRODUCT table is not in 1NF.
The PRODUCT table is in 2NF but not in 3N
The PRODUCT table is in 1NF but not in 2NF.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!