Question

MySQL:

Consider the following abstract relational schema: (A, B, C, D, E, F)

Now assume the following functional dependencies:

A -> B, C, D, E, F

C -> B

Note: This implies that A is a key. Is this database in 1NF, 2NF, 3NF, or BCNF? Why?

Answer 1

******************************************************************************************
Please Upvote the answer as it matters to me a lot :)
*****************************************************************************************
As per HomeworkLib expert answering guidelines,Experts are supposed to answer only certain number of questions/sub-parts in a post.Please raise the remaining as a new question as per HomeworkLib guidelines.
******************************************************************************************

since there are no composite attributes it's in 1NF

we know that A is the key, A is the only prime attribute

there is no partial dependency, so it's in 2NF

its not in 3NF because there is transitive dependency

A-> C

C-> B

it's not in BCNF because C->B C is not a super key