1,358 views
1 votes
1 votes

The number of minimum Relations which satisfy 1NF _________. (Partial participation between E1 and R should not lost in RDBMS design).

Please explain every point in detail i am weak in ER Diagram to table conversion Please

1 Answer

1 votes
1 votes

Relation means Table. Three tables will be formed: two for entities and one for M:N relationship. 

1NF requires attributes to be atomic.

Relation is a set of tuples and that's why it can't have duplicate tuples/rows because sets don't allow duplicates. Thus, all relations are in 1NF because each tuple of a relation is unique.

This means all the three tables are in 1NF.

But if we go into language implementation, like SQL, then the answer would be language specific. For example, in SQL we would have 0 as answer because duplicate tuples are allowed in SQL. Go through this:

https://stackoverflow.com/questions/30767562/why-does-sql-standard-allow-duplicate-rows

Related questions

0 votes
0 votes
0 answers
1
Na462 asked Oct 12, 2018
1,128 views
Consider ER Diagram Identify the Minimum number of relation satisfying 2nf ?A. 1B. 2C. 3D. 4
1 votes
1 votes
0 answers
2
Mk Utkarsh asked Sep 23, 2018
663 views
Tables needed for ER diagram
15 votes
15 votes
13 answers
4
targate2018 asked Aug 12, 2017
8,610 views
How many minimum relations required for given ER diagram ?