Section 5 Quiz
(Answer all questions in this section)
1. Relationships can be Redundant. True or False? Mark for Review
(1) Points
True (*)
False
2. If two entities have two relationships between them, these relationships can be either _____________ or _____________ . Mark for Review
(1) Points
Redundant and Replicated
Resourced and Really Good
Redundant or Required (*)
Replicated or Required
3. What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE" Mark for Review
(1) Points
One to One Optional (*)
Many to Many Mandatory
One to Many Mandatory
One to Many Optional
4. What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER" Mark for Review
(1) Points
One to Many (*)
Many to Many
Many to More
One to One
5. If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
Replicated
Redundant (*)
Removable
Resourceful
6. A non-transferable relationship is represented by which of the following symbols? Mark for Review
(1) Points
Diamond (*)
Heart
Triangle
Circle
7. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Mandatory
Non-Transferable (*)
Optional
Transferable
8. Every ERD must have at least one non-transferable relationship. True or False? Mark for Review
(1) Points
True
False (*)
9. Non-transferable relationships can only be mandatory, not optional. True or False? Mark for Review
(1) Points
True
False (*)
10. Which of the following is an example of a non-transferable relationship Mark for Review
(1) Points
PERSON to BIRTH PLACE (*)
EMPLOYEE to DEPARTMENT
TEACHER to SCHOOL
STUDENT to COURSE
11. When you resolve a M:M by creating an intersection entity, this new entity will always inherit: Mark for Review
(1) Points
The attributes of both related entities.
The UID's from the entities in the original M:M.
Nothing is inherited from the original entities and relationship.
A relationship to each entity from the original M:M. (*)
12. What do you call the entity created when you resolve a M:M relationship? Mark for Review
(1) Points
M:M entity
Intersection entity (*)
Inclusion entity
Recursive entity
13. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review
(1) Points
True (*)
False
14. When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False? Mark for Review
(1) Points
True
False (*)
15. A relationship on an ERD can have attributes. True or False? Mark for Review
(1) Points
True
False (*)
1. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Non-Transferable (*)
Optional
Transferable
Mandatory
2. Every ERD must have at least one non-transferable relationship. True or False? Mark for Review
(1) Points
True
False (*)
3. If a relationship can be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Recursive
Committed
Implicit
Transferable (*)
4. Non-transferable relationships can only be mandatory, not optional. True or False? Mark for Review
(1) Points
True
False (*)
5. A non-transferable relationship means the relationship is manatory at both sides. True or False? Mark for Review
(1) Points
True
False (*)
6. If two entities have two relationships between them, these relationships can be either _____________ or _____________ . Mark for Review
(1) Points
Replicated or Required
Redundant or Required (*)
Redundant and Replicated
Resourced and Really Good
7. If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
Removable
Replicated
Resourceful
Redundant (*)
8. Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship? Mark for Review
(1) Points
TEACHER and SUBJECT AREA
TREE and BRANCH
PERSON and FINGERPRINT (*)
CAR and WHEEL
9. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
(1) Points
TREE and BRANCH
TEACHER and SUBJECT AREA (*)
CAR and WHEEL
PERSON and FINGERPRINT
10. One to many relationships are the most uncommon type of relationships in an ERD. True or False? Mark for Review
(1) Points
True
False (*)
11. When you resolve a M:M by creating an intersection entity, this new entity will always inherit: Mark for Review
(1) Points
The attributes of both related entities.
The UID's from the entities in the original M:M.
Nothing is inherited from the original entities and relationship.
A relationship to each entity from the original M:M. (*)
12. A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship. True or False? Mark for Review
(1) Points
True (*)
False
13. Many to many relationships between entities usually hide what? Mark for Review
(1) Points
More attributes
Uniqueness
Another relationship
Another entity (*)
14. If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by Mark for Review
(1) Points
Creating new attributes.
Barring the relationships to the original entities. (*)
Placing the UID attributes from the original entities into the intersection entity.
None of the above.
15. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review
(1) Points
True (*)
False
1. Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False? Mark for Review
(1) Points
True
False (*)
2. What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER" Mark for Review
(1) Points
Many to Many
Many to More
One to One
One to Many (*)
3. If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
Redundant (*)
Resourceful
Removable
Replicated
4. One to many relationships are the most uncommon type of relationships in an ERD. True or False? Mark for Review
(1) Points
True
False (*)
5. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
(1) Points
CAR and WHEEL
TREE and BRANCH
PERSON and FINGERPRINT
TEACHER and SUBJECT AREA (*)
6. A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False? Mark for Review
(1) Points
True (*)
False
7. Every ERD must have at least one non-transferable relationship. True or False? Mark for Review
(1) Points
True
False (*)
8. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Optional
Mandatory
Non-Transferable (*)
Transferable
9. The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False? Mark for Review
(1) Points
True (*)
False
10. If a relationship can be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Recursive
Implicit
Transferable (*)
Committed
11. If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by Mark for Review
(1) Points
Creating new attributes.
Barring the relationships to the original entities. (*)
Placing the UID attributes from the original entities into the intersection entity.
None of the above.
12. When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False? Mark for Review
(1) Points
True
False (*)
13. Many to many relationships between entities usually hide what? Mark for Review
(1) Points
More attributes
Another relationship
Uniqueness
Another entity (*)
14. A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship. True or False? Mark for Review
(1) Points
True (*)
False
15. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review
(1) Points
True (*)
False
1. When you resolve a M:M by creating an intersection entity, this new entity will always inherit: Mark for Review
(1) Points
A relationship to each entity from the original M:M. (*)
The attributes of both related entities.
The UID's from the entities in the original M:M.
Nothing is inherited from the original entities and relationship.
2. What do you call the entity created when you resolve a M:M relationship? Mark for Review
(1) Points
M:M entity
Inclusion entity
Intersection entity (*)
Recursive entity
3. Many to many relationships between entities usually hide what? Mark for Review
(1) Points
Uniqueness
Another relationship
Another entity (*)
More attributes
4. A relationship on an ERD can have attributes. True or False? Mark for Review
(1) Points
True
False (*)
5. If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by Mark for Review
(1) Points
Creating new attributes.
Barring the relationships to the original entities. (*)
Placing the UID attributes from the original entities into the intersection entity.
None of the above.
6. A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False? Mark for Review
(1) Points
True (*)
False
7. Non-transferable relationships can only be mandatory, not optional. True or False? Mark for Review
(1) Points
True
False (*)
8. The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False? Mark for Review
(1) Points
True (*)
False
9. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Non-Transferable (*)
Optional
Transferable
Mandatory
10. A non-transferable relationship means the relationship is manatory at both sides. True or False? Mark for Review
(1) Points
True
False (*)
11. Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship? Mark for Review
(1) Points
PERSON and FINGERPRINT (*)
CAR and WHEEL
TEACHER and SUBJECT AREA
TREE and BRANCH
12. What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE" Mark for Review
(1) Points
One to One Optional (*)
One to Many Mandatory
Many to Many Mandatory
One to Many Optional
13. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
(1) Points
TREE and BRANCH
PERSON and FINGERPRINT
CAR and WHEEL
TEACHER and SUBJECT AREA (*)
14. What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER" Mark for Review
(1) Points
One to Many (*)
One to One
Many to More
Many to Many
15. Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False? Mark for Review
(1) Points
True
False (*)
(Answer all questions in this section)
1. Relationships can be Redundant. True or False? Mark for Review
(1) Points
True (*)
False
2. If two entities have two relationships between them, these relationships can be either _____________ or _____________ . Mark for Review
(1) Points
Redundant and Replicated
Resourced and Really Good
Redundant or Required (*)
Replicated or Required
3. What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE" Mark for Review
(1) Points
One to One Optional (*)
Many to Many Mandatory
One to Many Mandatory
One to Many Optional
4. What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER" Mark for Review
(1) Points
One to Many (*)
Many to Many
Many to More
One to One
5. If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
Replicated
Redundant (*)
Removable
Resourceful
6. A non-transferable relationship is represented by which of the following symbols? Mark for Review
(1) Points
Diamond (*)
Heart
Triangle
Circle
7. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Mandatory
Non-Transferable (*)
Optional
Transferable
8. Every ERD must have at least one non-transferable relationship. True or False? Mark for Review
(1) Points
True
False (*)
9. Non-transferable relationships can only be mandatory, not optional. True or False? Mark for Review
(1) Points
True
False (*)
10. Which of the following is an example of a non-transferable relationship Mark for Review
(1) Points
PERSON to BIRTH PLACE (*)
EMPLOYEE to DEPARTMENT
TEACHER to SCHOOL
STUDENT to COURSE
11. When you resolve a M:M by creating an intersection entity, this new entity will always inherit: Mark for Review
(1) Points
The attributes of both related entities.
The UID's from the entities in the original M:M.
Nothing is inherited from the original entities and relationship.
A relationship to each entity from the original M:M. (*)
12. What do you call the entity created when you resolve a M:M relationship? Mark for Review
(1) Points
M:M entity
Intersection entity (*)
Inclusion entity
Recursive entity
13. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review
(1) Points
True (*)
False
14. When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False? Mark for Review
(1) Points
True
False (*)
15. A relationship on an ERD can have attributes. True or False? Mark for Review
(1) Points
True
False (*)
1. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Non-Transferable (*)
Optional
Transferable
Mandatory
2. Every ERD must have at least one non-transferable relationship. True or False? Mark for Review
(1) Points
True
False (*)
3. If a relationship can be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Recursive
Committed
Implicit
Transferable (*)
4. Non-transferable relationships can only be mandatory, not optional. True or False? Mark for Review
(1) Points
True
False (*)
5. A non-transferable relationship means the relationship is manatory at both sides. True or False? Mark for Review
(1) Points
True
False (*)
6. If two entities have two relationships between them, these relationships can be either _____________ or _____________ . Mark for Review
(1) Points
Replicated or Required
Redundant or Required (*)
Redundant and Replicated
Resourced and Really Good
7. If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
Removable
Replicated
Resourceful
Redundant (*)
8. Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship? Mark for Review
(1) Points
TEACHER and SUBJECT AREA
TREE and BRANCH
PERSON and FINGERPRINT (*)
CAR and WHEEL
9. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
(1) Points
TREE and BRANCH
TEACHER and SUBJECT AREA (*)
CAR and WHEEL
PERSON and FINGERPRINT
10. One to many relationships are the most uncommon type of relationships in an ERD. True or False? Mark for Review
(1) Points
True
False (*)
11. When you resolve a M:M by creating an intersection entity, this new entity will always inherit: Mark for Review
(1) Points
The attributes of both related entities.
The UID's from the entities in the original M:M.
Nothing is inherited from the original entities and relationship.
A relationship to each entity from the original M:M. (*)
12. A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship. True or False? Mark for Review
(1) Points
True (*)
False
13. Many to many relationships between entities usually hide what? Mark for Review
(1) Points
More attributes
Uniqueness
Another relationship
Another entity (*)
14. If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by Mark for Review
(1) Points
Creating new attributes.
Barring the relationships to the original entities. (*)
Placing the UID attributes from the original entities into the intersection entity.
None of the above.
15. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review
(1) Points
True (*)
False
1. Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False? Mark for Review
(1) Points
True
False (*)
2. What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER" Mark for Review
(1) Points
Many to Many
Many to More
One to One
One to Many (*)
3. If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
Redundant (*)
Resourceful
Removable
Replicated
4. One to many relationships are the most uncommon type of relationships in an ERD. True or False? Mark for Review
(1) Points
True
False (*)
5. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
(1) Points
CAR and WHEEL
TREE and BRANCH
PERSON and FINGERPRINT
TEACHER and SUBJECT AREA (*)
6. A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False? Mark for Review
(1) Points
True (*)
False
7. Every ERD must have at least one non-transferable relationship. True or False? Mark for Review
(1) Points
True
False (*)
8. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Optional
Mandatory
Non-Transferable (*)
Transferable
9. The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False? Mark for Review
(1) Points
True (*)
False
10. If a relationship can be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Recursive
Implicit
Transferable (*)
Committed
11. If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by Mark for Review
(1) Points
Creating new attributes.
Barring the relationships to the original entities. (*)
Placing the UID attributes from the original entities into the intersection entity.
None of the above.
12. When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False? Mark for Review
(1) Points
True
False (*)
13. Many to many relationships between entities usually hide what? Mark for Review
(1) Points
More attributes
Another relationship
Uniqueness
Another entity (*)
14. A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship. True or False? Mark for Review
(1) Points
True (*)
False
15. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review
(1) Points
True (*)
False
1. When you resolve a M:M by creating an intersection entity, this new entity will always inherit: Mark for Review
(1) Points
A relationship to each entity from the original M:M. (*)
The attributes of both related entities.
The UID's from the entities in the original M:M.
Nothing is inherited from the original entities and relationship.
2. What do you call the entity created when you resolve a M:M relationship? Mark for Review
(1) Points
M:M entity
Inclusion entity
Intersection entity (*)
Recursive entity
3. Many to many relationships between entities usually hide what? Mark for Review
(1) Points
Uniqueness
Another relationship
Another entity (*)
More attributes
4. A relationship on an ERD can have attributes. True or False? Mark for Review
(1) Points
True
False (*)
5. If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by Mark for Review
(1) Points
Creating new attributes.
Barring the relationships to the original entities. (*)
Placing the UID attributes from the original entities into the intersection entity.
None of the above.
6. A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False? Mark for Review
(1) Points
True (*)
False
7. Non-transferable relationships can only be mandatory, not optional. True or False? Mark for Review
(1) Points
True
False (*)
8. The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False? Mark for Review
(1) Points
True (*)
False
9. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Non-Transferable (*)
Optional
Transferable
Mandatory
10. A non-transferable relationship means the relationship is manatory at both sides. True or False? Mark for Review
(1) Points
True
False (*)
11. Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship? Mark for Review
(1) Points
PERSON and FINGERPRINT (*)
CAR and WHEEL
TEACHER and SUBJECT AREA
TREE and BRANCH
12. What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE" Mark for Review
(1) Points
One to One Optional (*)
One to Many Mandatory
Many to Many Mandatory
One to Many Optional
13. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
(1) Points
TREE and BRANCH
PERSON and FINGERPRINT
CAR and WHEEL
TEACHER and SUBJECT AREA (*)
14. What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER" Mark for Review
(1) Points
One to Many (*)
One to One
Many to More
Many to Many
15. Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False? Mark for Review
(1) Points
True
False (*)
1. Non-transferable relationships can only be mandatory, not optional. True or False?
True
False
False
2. A non-transferable relationship is represented by which of the following symbols? M
Heart
Diamond
Circle
Triangle
Diamond
Circle
Triangle
3. If a relationship can be moved between instances of the entities it connects, it is said to be:
Implicit
Transferrable
Committed
Recursive
Transferrable
Committed
Recursive
Test: Quiz: Relationship Types
1. 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”
One to Many Optional
One to Many Mandatory
Many to Many Optional
Many to Many Mandatory
One to Many Mandatory
Many to Many Optional
Many to Many Mandatory
2. Many to many relationships between entities usually hide what?
Another relationship
Another entity
More attributes
Uniqueness
Another entity
More attributes
Uniqueness
3. When resolving an M:M relationship, the new relationships will always be __________ on the many side.
optional
recursive
mandatory
redundant
recursive
mandatory
redundant
4. Which of the following are relationship types? (Choose Two)
One to Some
Many to Many
One to Many
One to Another
Many to Many
One to Many
One to Another
5. If the same relationship is represented twice in an Entity Relationship Model, it is said to be:
Replicated
Removable
Redundant
Resourceful
Removable
Redundant
Resourceful
6. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? (Choose Two)
STUDENT and CLASS
TREE and SEEDLING
PHONE NUMBER and SIM CARD
CAR and DRIVER
TREE and SEEDLING
PHONE NUMBER and SIM CARD
CAR and DRIVER
7. When are relationships unnecessary?
When you can derive the relationship from other relationships in the model
When they have the same visual structure but different meaning
When the information does not relate to the model
When the relationships connect 2 entities and they each have distinct meanings
When they have the same visual structure but different meaning
When the information does not relate to the model
When the relationships connect 2 entities and they each have distinct meanings
Test: Quiz: Resolving Many to Many Relationships
1. 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?
True
False
False
2. When you resolve a M-M by creating an intersection entity, this new entity will always inherit:
The attributes of both related entities.
A relationship to each entity from the original M-M.
The UID’s from the entities in the original M-M.
Nothing is inherited from the original entities and relationship.
A relationship to each entity from the original M-M.
The UID’s from the entities in the original M-M.
Nothing is inherited from the original entities and relationship.
3. If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by
Creating new attributes.
Barring the relationships to the original entities.
Placing the UID attributes from the original entities into the intersection entity.
None of the above.
Barring the relationships to the original entities.
Placing the UID attributes from the original entities into the intersection entity.
None of the above.
Comments
Post a Comment