Register

NO of tables

334 views

1 Answer

0 votes
0 votes

It is an example of extended ER model where we have a collection of entity sets and relationship set as a single set..So in this case , we have " Projects - Sponsors - Department " as a single entity.

Rest we need 1 table each for "monitors" relationship set and "employee" entity set..

So overall we need 3 tables in the context of extended ER diagram concept.

User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
0 answers
2
Rishav Kumar Singh asked Jan 1, 2019
433 views
No. Of tables
The number of tables required in SELF-REFERENTIAL relation when different mappings(1: M, M:1, 1:1, M: N) are used with different participation (Partial Participation at both sides, Total Participation at both sides and partial participation at one side).
The number of tables required in SELF-REFERENTIAL relation when different mappings(1: M, M:1, 1:1, M: N) are used with different participation (Partial Participation at b...
User Avatar
2 votes
2 votes
2 answers
3
srestha asked Jan 24, 2018
565 views
No. of Tables
Plz check this Ans given 5 and I was getting 3 Which one correct??
Plz check this Ans given 5 and I was getting 3Which one correct??
User Avatar
0 votes
0 votes
1 answer
4
aditya kuppa 1 asked Dec 5, 2017
1,092 views
No. of tables for ER diagram
How many minimum tables are required for this er diagram consisting of a many - many relation and total participation of one of the entities.? Can't i merge relation R and entity B? why?
How many minimum tables are required for this er diagram consisting of a many - many relation and total participation of one of the entities.? Can't i merge relation R an...
User Avatar
Link Copied!