Exam 4: Entity Relationship Er Modeling

_____ not only helps database designers to stay on track during the design process, it also enables them to pick up the design thread when the time comes to modify the design.

A composite identifier is a primary key composed of more than one attribute.

Relationships between entities always operate in one direction.

The conceptual model can handle _____ relationships and multivalued attributes.

A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

A(n) _____ relationship is also known as an identifying relationship.

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

When indicating cardinality, the first value represents the _____ number of associated entities.

Explain recursive relationships with the help of an example.

The _____ notation of entity-relationship modelling can be used for both conceptual and implementation modelling.

The first step in building an entity-relationship diagram (ERD) is _____.

An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity occurrence.

Software vendors have adopted the Chen representation because of its compact representation.

In the entity relationship model, a table row corresponds to an entity instance.

A(n) _____ attribute is an attribute that must have a value.

The Crow's Foot notation easily identifies multivalued attributes.

A _____ attribute can be further subdivided to yield additional attributes.

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

_____ are characteristics of entities.

A relationship is an association between _____.