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 :(