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