Question: Given the relation: REL ( h , i , j , k , l , m , n , o , p ) It has

Given the relation:
REL(h,i,j,k,l,m,n,o,p)
It has been determined that the relation is qualifies as 1NF, and the following dependencies are known:
i, k, m ---> h, j, l, p
i, k ---> n, o
j ---> p
Which of the following statements are correct?
The relation is definitely not in 2 NF
The relation is definitely in 2NF
The relation may be in 3NF, but insufficient information to make determination
The relation is definitely not in 3NF
Given the relation: REL ( h , i , j , k , l , m ,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!