recategorized by
1,085 views
2 votes
2 votes

In ER model, which of the following is TRUE about weak entity

  1. Weak entity is not always existence dependent i.e., weak entity can exist without the entity with which it has a relationship

  2. Weak entity has a primary key that is partially or totally derived from the parent entity in a relationship

 

  1. Only I

  2. Only II

  3. Both I and II

  4. Neither I nor II

recategorized by

1 Answer

0 votes
0 votes

Total participation is also called Existence Dependencies. 

Weak entity have always a total participating constraint because they cannot be identified without an owner entity. 

Hence, option 1 is simply wrong from the definition itself. 

Related questions

0 votes
0 votes
0 answers
1
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 ...
0 votes
0 votes
2 answers
3
priyanshu710 asked Sep 15, 2021
747 views
What is the minimum number of relations required to represent a one-to-many relationship having total participation on the many side?Can i have just a single table with a...
1 votes
1 votes
1 answer
4
aditi19 asked Jun 7, 2019
1,849 views
How to represent referential integrity constraint in ER model?pls explain with diagram