Week #3 Quiz CIST1220-Structured Query Language-SQL
Many to many relationships between entities usually hide what? Mark for Review A) Another entity B) Another relationship C) Uniqueness D) More attributes
A) Another entity
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 B) One to Many Optional C) One to Many Mandatory D) Many to Many Optional
A) Many to Many Mandatory
If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by A) Creating new attributes. B) Barring the relationships to the original entities. C) Placing the UID attributes from the original entities into the intersection entity. D) None of the above.
B) Barring the relationships to the original entities.
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: A) Recursive B) Transferable C) Committed D) Implicit
B) Transferable
When you resolve a M:M by creating an intersection entity, this new entity will always inherit: A) The UID's from the entities in the original M:M. B) Nothing is inherited from the original entities and relationship. C) A relationship to each entity from the original M:M. D) The attributes of both related entities.
C) A relationship to each entity from the original M:M.
If the same relationship is represented twice in an Entity Relationship Model, it is said to be: A) Resourceful B) Removable C) Redundant D) Replicated
C) Redundant
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?
False
A non-transferable relationship is represented by which of the following symbols? A) Heart B) Triangle C) Circle D) Diamond
D) Diamond
When are relationships unnecessary? A) When the relationships connect 2 entities and they each have distinct meanings B) When the information does not relate to the model C) When they have the same visual structure but different meaning D) When you can derive the relationship from other relationships in the model
D) When you can derive the relationship from other relationships in the model