Question

Can have multivalued dependencies.

Basically has everything for AB -> C, C -> B, you'd have a table with C and A (both are keys) and another for C and B (where C is the only key).
If for FD: X -> A holding in R, then X is a superkey of R.
Options:
A. Multinormal Dependency (MND)
B. Multivalued Normal Form (MVNF)
C. Third Normal Form (3NF)
D. Multinormal Form (MNF)

Answer 1

The question relates to database normalization, specifically to Third Normal Form (3NF), where non-prime attributes must be non-transitively dependent on every superkey of the relational schema.

Step-by-step explanation:

The concept discussed in the question pertains to database normalization and the specific forms that a database schema can be organized into in order to reduce redundancy and improve data integrity. In the context provided, where an FD: X -> A holds in relational schema R and X is a superkey of R, the most relevant normal form is Third Normal Form (3NF). This normalization form requires that the schema be in Second Normal Form (2NF), and additionally, all the non-prime attributes (attributes that are not part of any candidate key) are non-transitively dependent on every superkey of R. The other options presented, such as Multivalued Normal Form (MVNF), are not standard terms used in database normalization theory.