243 views
0 votes
0 votes

How many Min and Max table are required Here E4 participation is Total?

1 Answer

1 votes
1 votes
2 Tables. As the cardinality ratio is 1:1 i.e. one record in E1 is only related to one record in E4. Hence, we need just two tables and we can store foreign key in either E1 or E4 to represent the relation.

Related questions

2 votes
2 votes
1 answer
1
1 votes
1 votes
1 answer
2
0 votes
0 votes
0 answers
4