CIST1220 QUIZ 3

What uncommon relationship is described by the statements: "Each LINE must consist of many POINTS and each POINT must be a part of many LINES"

A) Many to Many Mandatory

Many-to-Many relationships are perfectly acceptable in a finished ERD. There is no need to do any more work on them. True or False?

B) False

Non-transferable relationships can only be mandatory, not optional. True or False?

B) False

If a relationship can be moved between instances of the entities it connects, it is said to be:

B) Transferable

When you resolve a M:M by creating an intersection entity, this new entity will always inherit:

C) A relationship to each entity from the original M:M.

When resolving a M:M relationship, the new relationships will always be __________ on the many side.

C) Mandatory

If the same relationship is represented twice in an Entity Relationship Model, it is said to be:

C) Redundant

A non-transferable relationship is represented by which of the following symbols?

D) Diamond

When are relationships unnecessary?

D) When you can derive the relationship from other relationships in the model

Many to many relationships between entities usually hide what? Mark for Review

A) Another entity