Exam 4: Entity Relationship Ermodeling

A person's Social Security number would be an example of a(n)attribute.

In the original Chen notation,each attribute is represented by an oval with the attribute name connected to an entity rectangle with a line.

To simplify the conceptual design,most higher-order relationships are decomposed into appropriate equivalent relationships whenever possible.

A relationship exists when three entities are associated.

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

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

In the Chen and Crow's Foot notations,an entity is represented with a rectangle containing the entity's name.

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

What is a weak relationship? Provide an example.

A relationship exists when an association is maintained within a single entity.

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

Relationships between entities always operate in one direction.

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

The entity relationship model (ERM)is dependent on the database type.

A(n)process is based on repetition of processes and procedures.

Participation is if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

Explain mandatory participation in an entity relationship.

If Tiny College has some departments that are classified as "research only" and do not offer courses,the COURSE entity of the college database would be the DEPARTMENT entity.

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 relationship indicates the number of entities or participants associated with a relationship.