retagged by
2,484 views
8 votes
8 votes

$X$ is an entity set. $E$ and $F$ are multivalued attributes.

  1. How many minimum tables which satisfy 1NF ?
  2. How many minimum tables which satisfy 2NF ?
  3. How many minimum tables which satisfy 3NF ?
  4. How many minimum tables which satisfy BCNF ?
  5. How many minimum tables which satisfy 4NF ?
retagged by

2 Answers

5 votes
5 votes

lets start from scratch..
first deal with the multivalued attributes E and F
we need a separate table for them with either A or B ...means ABCD and AEF or BEF
now we are in 1NF with 2 tables

move towards 2NF...now from hereon we need FDs to further divide the tables..but since they are not mentioned we cant do anything and these 2 tables are by default in 2NF and BCNF too,,,

what if FDs were given?
then we need to check..but then also ABCD is in 2NF since A and B are 2 single attributes...there cant be any partial dependency...for 3NF there shouldnt be any FD like C->D or D->C else decompose...

for BCNF u shouldnt have any dependency like C->A or C->B or D->A or D->B...rest fine

so for ur question since no FDs were given finally u'll have 2 tables for 1NF,2NF,3NF,BCNF....else even if FDs were given it was in 2NF atleast rest u need to check for..

for 4NF...just split E and F also in 2 separate tables...

1 votes
1 votes

R1={ABCD}

R2={AEF} OR R2={BFF}

Related questions

0 votes
0 votes
1 answer
1
3 votes
3 votes
2 answers
2
Parshu gate asked Nov 19, 2017
3,540 views
How is it option D??
3 votes
3 votes
4 answers
3
2 votes
2 votes
1 answer
4
Rakesh K asked Dec 9, 2016
1,294 views