Exam 4: Entity Relationship Ermodeling

When using the Crow's Foot notation,the associative entity is indicated by relationship lines between the parents and the associative entity.

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

Ideally,an entity identifier is composed of attribute(s).

A weak entity must be -dependent.

The process of database design is a sequential process.

A(n)is the set of possible values for a given attribute.

If an entity can exist apart from all of its related entities,then it is existence-independent,and it is referred to as a(n)entity.

The Crow's Foot notation easily identifies multivalued attributes.

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

If an employee within an EMPLOYEE entity has a relationship with itself,that relationship is known as a relationship.

The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.

The Crow's foot symbol with two vertical parallel lines indicates cardinality.

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

In implementation terms,an entity is existence-dependent if it has a mandatory primary key.

What is a ternary relationship? Provide some business rules examples that specify the need for a ternary or higher- order relationship.

The decision to store attributes in database tables depends on the processing requirements and the constraints placed on a particular application.

The conceptual model can handle relationships and multivalued attributes.

When the specific cardinalities are not included on the diagram in Crow's Foot notation,cardinality is implied by the use of _____.

A attribute can be further subdivided to yield additional attributes.

A derived attribute is indicated in the Chen notation by a that connects the attribute and an entity.