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