391 views
0 votes
0 votes

1 Answer

Best answer
0 votes
0 votes
in first case you can join E1R(A,C,B) key will be AC

but you cant join on E2 side as it has partial participation so some attributes of E2 must not be related to anything on E1 side so for those attrbute value of E2,E1 value will ne null so our key constraint will be violated i.e primary key values can't be null.

But in case 3 as both side total participation you can join all into single table no key constraints would be violated.

take example and check.!

I will show you how to solve these type of qsn no rules whatso ever required just use your concepts wisely

loook in first case

E1(A,B)                    R(A,C)[AC is primary key]                       E2(C,D)

a1                               a1 c1                                                   c1

a2                               a1 c2                                                   c2

a3                               a2 c3                                                   c3

                                   a3  c2                                                   c4

(total participation)                                                           (partial participation)

you can join R on E1 side only so as to have primary key in table and its constraints to be preserved you cant join it further with E2 becz there will c4 tuple for which A value would be null i.e   NULL  c4(this will occur when you join E2 too) but due to this our primary key constraint gets violated i.e PK value cant be null....so its not possible to store this table in DBMS.  So you need 2 tables for this case E1R and E2.

 

In second case similarly you try by taking exmple as i took you will get it for sure..in second case you will see E1E2R can be joined in single table and keeping all constaints preserved i.e total particpation of both entity set,M:N relationship between two entity sets and even primary key constarint also remains preserved.!
selected by

Related questions

1 votes
1 votes
1 answer
1
aditi19 asked Jun 7, 2019
1,851 views
How to represent referential integrity constraint in ER model?pls explain with diagram
1 votes
1 votes
0 answers
2
Salazar asked Dec 27, 2017
338 views
Each Department is required to have atmost one employee as managerMy interpretation is for Department : Cardinality=1 Particiaption=0 for Employee Cardinality=1 and Parti...
2 votes
2 votes
2 answers
3
Parshu gate asked Nov 18, 2017
298 views
How is it opt D ?
0 votes
0 votes
0 answers
4
Ashutosh_17 asked Apr 13, 2023
424 views
Consider the following relation (capitalized letters are attributes and lower letters are values).X:From the given FDs find the dependencies that seems to apply on X and ...