Answer: CARDINALITY RATIO AND PARTICIPATION
ADVANTAGE
CARDINALITY RATIO
(THEY ARE USED TO SIMPLIFY DESIGNS)
DISADVANTAGE OF CARDINALITY RATIO IS THAT
(YOU CAN NOT SPECIFY A GIVEN NUMBER TO BE MAXIMUM)
ADVANTAGE OF PARTICIPATION CONSTRAINT IS THAT
(IT SHOWS WETHER THE EXISTENCE OF AN ENTITY IS DEPENDENT ON ITS RELATIONSHIPS WITH ANOTHER ENTITY)
DISADVANTAGE OF PARTICIPATION CONSTRAINT
(IT IS A COSTLY AFFAIR USING BOTH MODELS TO EXPRESEE RELATIONSHIPS).
Explanation:CARDINALITY RATIO specifies that maximum number of relationships an entity can engage itself in.
Participation constraint is a constraint that
Specifies whether the existence of an entity depends on its Relationships to another entity, it specifies the the minimum number of relationship instances that an entity can participate in
It is also minimum cardinality constraint,it has two types named as Total participation and partial participation.
The two alternatives for specifying structural constraints on relationship types are :
Cardinality ratio is a simple way of specifying designs, it is specifies the maximum number of relationship a body/entity can be engaged in.
Advantage of Cardinality ratio
It is used to simply complex designs
Disadvantage of cardinality ratio
No specific number can be said to be maximum
Participation constraint specifies the dependency of an entity on another entity based on the relationships existing between the entities
Advantage of participation constraint
It specifies the minimum number of relationship an entity can engage
It shows the dependency of an entity on another
Disadvantage
It is a more expensive alternative
Hence we can conclude that The two alternatives for specifying structural constraints on relationship types are : Cardinality ratio and
and Participation constraint
Learn more about structural constraints : https://brainly.com/question/26553340
