902 views
0 0 votes

I have a problem in identifying the key constraints of the Entity set. 
 

As in the relation, the key constraint should be from M-side. 

But here, in this case, according to me Father is the key constraint.
So for this, the relation is 1:M. In this case, it doesn't satisfy Father to be the key constraint.

2 Answers

0 0 votes
HERE Father is not key as in relation of relationship (has)

as

father son

f1       a1

f1       a2

f2       b1

f2       b2

as attribute father not uniquely determine relation (has)

but son attribute uniquely determine relation
0 0 votes
There are some properties that you should keep in mind:

1. a key attribute should be unique, it should not repeat itself. FOr eg, an aadhar no. is unique as it identifies a particular person

           father           son

            f1                 a1

             f1                 a2

             f2                b1

             f2                 b2

this is wrong for f1, f2 to be key attributes as f1, f2 are repeating.

2. an attribute cannot be multivalued, for eg.  

            father            son

              f1                 a1, a2

             f2                 b1, b2

this is wrong.

conclusion: there is no way in which you can write write f1, f2 once and uniquely identify their children without making it multivalued.
Position:
Show:

Related questions

2 2 votes
1 answers 1 answer
3.9k
3.9k views
Arjun Kumar 1 asked Jul 31, 2017
3,856 views
how to represent foreign key in er diagram
2 2 votes
3 3 answers
2.5k
2.5k views
daksirp asked Apr 23, 2022
2,482 views
What is the cardinality of this relationship? is m-n cardinality correct? if not, why?
6 6 votes
2 2 answers
17.3k
17.3k views
Ashish Sharma 3 asked Nov 24, 2017
17,338 views
I am confused whether we need to have 2 tables or a single table when 2 strong entities are in 1:1 relationship with one having complete participation.Ex: How is it possi...
1 1 vote
1 1 answer
700
700 views
Athul 1 asked Jan 5, 2025
700 views
 Can someone help me out in giving example for each, For Example 1:N Both Mandatory : Person->No of Classes Attended, This can be (PersonName,ClassName) but how is the nu...