2,234 views
1 votes
1 votes

What are minimum number of tables required for the following given ER models such that they satisfy 1NF ?

 

 

6 Answers

0 votes
0 votes
As Relationship (1:M or 1:1 or 1:N) we require only 2 tables, but there is condition that no multi valued attribute is attached with any entity.

But in (M:N) relationship we require 3 tables same condition also holds then it is true.

Related questions

0 votes
0 votes
2 answers
1
Balaji Jegan asked Nov 4, 2018
2,197 views
How many minimum number of tables needed for this Quaternary Relationship?
15 votes
15 votes
13 answers
2
targate2018 asked Aug 12, 2017
8,578 views
How many minimum relations required for given ER diagram ?
11 votes
11 votes
4 answers
3
targate2018 asked Aug 11, 2017
11,483 views
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.
0 votes
0 votes
2 answers
4
sushmita asked Jan 31, 2017
1,103 views
while converting one to one relationship from ER diagram to RDMS, without total participation on either side, we can represent the relationship using primary- foreign key...