Exam 4: Entity Relationship Ermodeling

The existence of a(n)entity indicates that its minimum cardinality is zero.

Knowing the minimum and maximum number of occurrences is very helpful at the application software level.

Connectivities and cardinalities are established by concise statements known as business rules.

A attribute is one that cannot be subdivided.

In organizations that generate large number of transactions,are often a top priority in database design.

expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

The concept of relationship strength is based on how the of a related entity is defined.

A relationship is difficult to establish if only one side of the relationship is known.

In a 1:M relationship,to avoid the possibility of referential integrity errors,the data of the "1" side must be loaded first.

A relationship is an association between .

In the entity relationship diagram (ERD),cardinality is indicated using the notation,where max is the maximum number of associated entities and min represents the minimum number of associated entities.

Composite attributes make it easier to facilitate detailed queries.

are underlined in an ER diagram.

Referential integrity and participation are both bidirectional,meaning that they must be addressed in both directions along a relationship.

An entity in the entity relationship model corresponds to a table in the relational environment.