edited by
1,319 views
0 votes
0 votes

Please Clear My Doubts here:-

1. In one to one Cardinality if we have Total Participation on One Side or Total Participation on both sides Then only 1 Table is Required. In that table the primary key will be of Entity with total participation.?

2. In one to one cardinality with No Participation Constraint then 2 tables only for entities are Required?

3.What about this total and No participation in case of many to one and many to many cases for deciding number of tables?

 

And How to decide the number of tables for satisfying the Normalization Construct?

like in this Question https://gateoverflow.in/86626/database-systems-1 . I understood why 2 is answer but i didn't get part for normalization and allowing or not allowing NULL values Please DO HIGHLIGHT THIS POINT.  

Question like minimum number of tables so that it satisfy 1NF ? https://gateoverflow.in/143186/minimum-number-of-tables-to-represent-er-diagram

How to solve such questions. Plz hep me out here :(

edited by

2 Answers

2 votes
2 votes

 

this may help to you..let me know 

Related questions

1 votes
1 votes
0 answers
1
Mk Utkarsh asked Sep 23, 2018
663 views
Tables needed for ER diagram
15 votes
15 votes
13 answers
2
targate2018 asked Aug 12, 2017
8,579 views
How many minimum relations required for given ER diagram ?
11 votes
11 votes
4 answers
3
targate2018 asked Aug 11, 2017
11,485 views
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.