FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Entity Relationship Ermodeling

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) unary
B) ternary
C) strong
D) weak

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 32

Essay

Review LaterAdd Note

Review Later

Explain mandatory participation in an entity relationship.

Correct Answer

verified

Mandatory participation means that one e...

View Answer

Show Answer

Question 33

Essay

Review LaterAdd Note

What is a weak relationship? Provide an example.

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

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

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

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

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

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

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

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

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.

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

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

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.

Relationships between entities always operate in one direction.

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

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

A relationship indicates the number of entities or participants associated with a relationship.

A relationship exists when three entities are associated.