The Gateway to Computer Science Excellence

+3 votes

0

can you please write down all the tables with all attributes,bcz I am not getting how to represent the relationship among all.

0

@ Prashant, we can merge two table only if one-one and total participation on both sides na??...

you are merging even when only one side has total participation, due to this there will several tupples of E4 for which there will 'NULL' values under 'A' and 'B' attribute..

A B E F

1 2 1 2

2 3 4 5

null null 5 6

null null 7 8

now according to merging 'AE' should be key of this table, but AE could not be key since prime attribute(A) is NULL....

you are merging even when only one side has total participation, due to this there will several tupples of E4 for which there will 'NULL' values under 'A' and 'B' attribute..

A B E F

1 2 1 2

2 3 4 5

null null 5 6

null null 7 8

now according to merging 'AE' should be key of this table, but AE could not be key since prime attribute(A) is NULL....

0

Yes here 3 tables are minimum require.

1 table for E2

1 table for E3

1 table for (R E4 )

1:1 with only single side total participation we always take 1 table.

so in total 3 tables require here.

1 table for E2

1 table for E3

1 table for (R E4 )

1:1 with only single side total participation we always take 1 table.

so in total 3 tables require here.

0

yes sorry, i had not seen it.. but still it is not good practice to merge relations with total participation on one side since there will many null values in a table..

0

but still it is not good practice to merge relations with total participation on one side since there will many null values in a table

yes that's true.

0

in this diagram there is a mistake , see

for total participation Notation we use = means double line , but in this question use <= a extra arrow they used , which is completely wrong .

Arrow is only used in 1:1 or 1:N relationship , see this snap from korth

Though we ignore this arrow here but it is wrong notation to represent total participation.

And this ER diagram need minimum 3 tables for conversion to relational model.

0

arrow is not correct, i discussed this issue with others and also check DBMS book from korth to navathe , no where arrow is used to represent total participation.

Even you see my snap, it also says without arrow.

"=" represent total participation. no arrow needed , this decision is based on standard books.

To represent 1:1 or 1:N this should be mention explicitly on lines .

Only ME and ACE questions i find this kind of arrow even NO Gate question use arrow to represent 1:1 with total participation. As gate question don't support we say it is wrong notation.

Even you see my snap, it also says without arrow.

"=" represent total participation. no arrow needed , this decision is based on standard books.

To represent 1:1 or 1:N this should be mention explicitly on lines .

Only ME and ACE questions i find this kind of arrow even NO Gate question use arrow to represent 1:1 with total participation. As gate question don't support we say it is wrong notation.

0

sir, you are saying "=" represent 1:1 with total partition (without arrow)..

than how to represent total participation with many-one or many-many...either we have to exlicitly mention cardinality ratio nos on lines or we have to use arrow

than how to represent total participation with many-one or many-many...either we have to exlicitly mention cardinality ratio nos on lines or we have to use arrow

0

Okay sir,

It means,If we want to represent total participation with "one" or "many" then,always it must explicitly mentioned in the model,Am i right sir?

It means,If we want to represent total participation with "one" or "many" then,always it must explicitly mentioned in the model,Am i right sir?

+1

yes , we need to use cardinality ratio explicitly to represent that .

Because " = " represent total participation . This is standard notation.

And no book use arrow with = to represent 1:1 with total participation , even no gate papers i found which use this arrow notation , you check all gate questions on this conversion topic .. if you don't believe my words and check any standard books ...so based on ME or ACE question we should not believe it right ?

Because " = " represent total participation . This is standard notation.

And no book use arrow with = to represent 1:1 with total participation , even no gate papers i found which use this arrow notation , you check all gate questions on this conversion topic .. if you don't believe my words and check any standard books ...so based on ME or ACE question we should not believe it right ?

0

Why you believe my words ?

Check all gate questions on this topic, just a single search in GO will do that .. then see the diagrams and notations they use !!

i discussed this topic with people , at the end i conclude that no arrow is correct diagram . I did checked gate papers and books too .. no where arrow is used.

check navathe , korth and settle the answer !!

Check all gate questions on this topic, just a single search in GO will do that .. then see the diagrams and notations they use !!

i discussed this topic with people , at the end i conclude that no arrow is correct diagram . I did checked gate papers and books too .. no where arrow is used.

check navathe , korth and settle the answer !!

- All categories
- General Aptitude 1.9k
- Engineering Mathematics 7.5k
- Digital Logic 2.9k
- Programming and DS 4.9k
- Algorithms 4.4k
- Theory of Computation 6.2k
- Compiler Design 2.1k
- Databases 4.1k
- CO and Architecture 3.4k
- Computer Networks 4.2k
- Non GATE 1.4k
- Others 1.4k
- Admissions 595
- Exam Queries 573
- Tier 1 Placement Questions 23
- Job Queries 72
- Projects 18

50,737 questions

57,306 answers

198,321 comments

105,014 users