2,015 views
0 votes
0 votes
If a relation has no functional dependency than what is the normal form of this relation???

2 Answers

5 votes
5 votes

A relation have always  trivial functional dependency. 

A trivial functional dependency always is in BCNF.

Example

R(ABC)

AB--->B like

0 votes
0 votes

1>trivial dependencies is like,

sid---->sid

sname---->sname

cid------>cid

the meaning fo trivial dependencies is self-depending,i can be determined by itself,

 

#non_trivial_FD- 

sid------>sname

sid_cid---->sname 
 

 

#semi_non_trivial_fd

AB---->BC

C------>AC

 

If a relation has no functional dependency than what is the normal form of this relation???

for_example lets take a table

      x       y       
     5        7
     5         7 
      6         4
      6         4

 Now from above table we can say "x---->y"

and according to your question ''If a relation has no functional dependency'' its mean that we have only 

        x
       5
       5
       6
       8

#NORMALIZATION- is used to reduce redundancy in the database relations, and redundancy occurs if 2 or more relation stored in a single database, and can not use fds here  bczz we have only one row in the table,so how can we think about normal forms 

Related questions

2 votes
2 votes
1 answer
1
0 votes
0 votes
0 answers
2
ayush201 asked Dec 7, 2018
1,039 views
Q.47. How many minimum relation tables are required which satisfy 1NF? A 2, 2, and 1 respectivelyB 2, 2, and 2 respectivelyC 1, 2, and 1 respectivelyD 1, 1, and 1 respect...
1 votes
1 votes
0 answers
3
Balaji Jegan asked Oct 23, 2018
301 views