Draw ER diagram from the following description: Entities: Person Relationships: Person (Man) Marries Person (Woman) a. Cardinality: one-to-one b. Participation: optional participation of both Person (Man) and Person (Woman) 2. Person (Man) IsFatherOf Person (Child) a. Multiplicity: 0…1 on Person (Man) side and 0…* on Person (Child) side 3. Person (Woman) IsMotherOf Person (Child) a. Multiplicity: 0…1 on Person (Man) side and 0…* on Person (Child) side Attributes: 1. Person: cnicNo {PK}, familyNo {AK}, name (composite of firstName and lastName), dob, gender, age (derived from dob) 2. Marries: dateOfMarriage (b) Enlist the entities, relationships, and their attributes from the following ER diagram
Draw ER diagram from the following description:
Entities: Person
Relationships:
Person (Man) Marries Person (Woman)
a. Cardinality: one-to-one
b. Participation: optional participation of both Person (Man) and Person (Woman)
2. Person (Man) IsFatherOf Person (Child)
a. Multiplicity: 0…1 on Person (Man) side and 0…* on Person (Child) side
3. Person (Woman) IsMotherOf Person (Child)
a. Multiplicity: 0…1 on Person (Man) side and 0…* on Person (Child) side
Attributes:
1. Person: cnicNo {PK}, familyNo {AK}, name (composite of firstName and lastName), dob, gender, age (derived from dob)
2. Marries: dateOfMarriage
(b) Enlist the entities, relationships, and their attributes from the following ER diagram
Step by step
Solved in 2 steps with 2 images