MyQuestionIcon

1

You visited us 1 times! Enjoying our articles? Unlock Full Access!

An ER model o...

Question

An ER model of a database consists of entity type A and B. These are connected by a relationship R which does not have its own attribute. Under which one of the following conditions, can the relational table for R be merged with that of A?

Open in App

Solution

Entity sets A, B
Relationship set R
Relation R merges with that of A.

Many to one relationship set can merge towards entity set 'A'.

Partipation towards A side can be total / partial.

Suggest Corrections

thumbs-up

0

Similar questions

Q. Consider the following entity relationship diagram (ERD), where two entities E1 and E2 have a relation R of cardinality 1 : m

The attributes of E1 and A11, A12 and A13 where A11 is the key attribute. The attributes of E2 are A21, A22 and A23 where A21 is the key attribute and A23 is a multi-valued attribute.
Relation R does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF) is designed from the above ERD. The number of tables in the database is

Join BYJU'S Learning Program

similar_icon

Related Videos

lock

More Chalukyas

Watch in App

Join BYJU'S Learning Program

CrossIcon