49.8k views
0 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 Jchl
by
5.4k points

1 Answer

3 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 Sophtware
by
5.2k points