Chapter 5, Problem 5.2UYK

a)

Program Plan Intro

Maximum cardinality:

It is referred as maximum number of entities that are involved in a relationship.

Three Examples of maximum cardinality:

The three examples of maximum cardinality are:

• l:N(one to Many relationship)
• 1:1(one to one relationship)
• N:M.(many to many relationship)

Minimum cardinality:

• It gives the minimum number of entities that are required for relationship.
• Controls on minimum requirements are referred as minimum cardinality.

Two Examples of minimum cardinality:

The two examples of minimum cardinality are:

• It could contain 0 relationship
• It could contain 1 relationship

Maximum cardinality of the relationship “Adviser” and “student”:

The below are the maximum cardinality for the relationship that are given:

b)

Program Plan Intro

Maximum cardinality:

It is referred as maximum number of entities that are involved in a relationship.

Three Examples of maximum cardinality:

The three examples of maximum cardinality are:

• l:N(one to Many relationship)
• 1:1(one to one relationship)
• N:M.(many to many relationship)

Minimum cardinality:

• It gives the minimum number of entities that are required for relationship.
• Controls on minimum requirements are referred as minimum cardinality.

Two Examples of minimum cardinality:

The two examples of minimum cardinality are:

• It could contain 0 relationship
• It could contain 1 relationship

Maximum cardinality of the relationship “Adviser” and “student”:

The below are the maximum cardinality for the relationship that are given:

c)

Program Plan Intro

Maximum cardinality:

It is referred as maximum number of entities that are involved in a relationship.

Three Examples of maximum cardinality:

The three examples of maximum cardinality are:

• l:N(one to Many relationship)
• 1:1(one to one relationship)
• N:M.(many to many relationship)

Minimum cardinality:

• It gives the minimum number of entities that are required for relationship.
• Controls on minimum requirements are referred as minimum cardinality.

Two Examples of minimum cardinality:

The two examples of minimum cardinality are:

• It could contain 0 relationship
• It could contain 1 relationship

Maximum cardinality of the relationship “Adviser” and “student”:

The below are the maximum cardinality for the relationship that are given:

d)

Program Plan Intro

Maximum cardinality:

It is referred as maximum number of entities that are involved in a relationship.

Three Examples of maximum cardinality:

The three examples of maximum cardinality are:

• l:N(one to Many relationship)
• 1:1(one to one relationship)
• N:M.(many to many relationship)

Minimum cardinality:

• It gives the minimum number of entities that are required for relationship.
• Controls on minimum requirements are referred as minimum cardinality.

Two Examples of minimum cardinality:

The two examples of minimum cardinality are:

• It could contain 0 relationship
• It could contain 1 relationship

Maximum cardinality of the relationship “Adviser” and “student”:

The below are the maximum cardinality for the relationship that are given: