390 views
0 votes
0 votes
What are the parameters or procedure to follow to find out minimum no. of tables for given ER Diagram type of questions?

1 Answer

0 votes
0 votes

1.Only Partial participations-

  • One-One:2 Tables, Merge Relation to any of the side.
  • Many-One or One-Many:2 Tables, Merge Relation to Many side.
  • Many-Many:3 tables (separate table for relation)

2. Any one of the  side has full participation-

  • Full participation on Many Side: 2 Tables
  • Full Participation on one side: 1 Table

3.Both Side full participation-

  • Always one table irrespective of Cardinality.

Related questions

0 votes
0 votes
0 answers
1
Crackca asked Oct 19, 2021
411 views
Can anyone verify this?What is the minimum number of tables required in the given situation?Assume there are two entities E1 containing attributes A1 and A2 and E2 contai...
1 votes
1 votes
6 answers
2
Abbas2131 asked Jul 30, 2018
2,234 views
What are minimum number of tables required for the following given ER models such that they satisfy 1NF ?
0 votes
0 votes
0 answers
3
Asutosh asked Jul 7, 2018
209 views
For the relations:A(pid, cid)B(pid, pname, powner)C(cid, cname, cdesciption)How will the query be executed :SELECT pname, cname FROM A, B, CWHERE B.powner = $somevalueAND...
0 votes
0 votes
0 answers
4
iarnav asked Dec 5, 2017
191 views
Kindly explain Check Constraint in SQL with a small example!