406,032 views
42 votes
42 votes
Consider the following relation with functional dependencies as shown below.R{sno,sname,age,cno,cname,group}

R(A,B,C,D,E,F)
A-B,C
C-F
D-E
which normal form is the relation R is in?

User Lepix
by
2.8k points

1 Answer

17 votes
17 votes

Answer:

First Normal Form

Step-by-step explanation:

The correct answer is - First Normal Form

Reason -

Given that,

A-B,C

C-F

D-E

Here the key is AD

The two partial Functional dependencies are -

A-B,C

D-E

So,

They are not in Second Normal Form, but they are in First Normal Form.

User Enot
by
3.2k points