Answer Section 5 Quiz Database Design 2019 Learner - English

Section 5

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

                                                                               

                                               

                The UID's from the entities in the original M:M.

                                               

                The attributes of both related entities.

       

                                        

                Nothing is inherited from the original entities and relationship.

                                               

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

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? 

                                                                               

                                               

                True

                                               

                False (*)

                                                                               

A relationship on an ERD can have attributes. True or False?    

                                               

                True

                                               

                False (*)

                                                                               

Many to many relationships between entities usually hide what?  

                                               

                Another entity (*)

                                               

                Another relationship

                                               

                Uniqueness

                                               

                More attributes

                                                                               

Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False?                            

                                               

                True (*)

                                               

                False

Which of the following pairs of entities is most likely to be modeled as a M:M relationship?                                                    

                                               

                CAR and WHEEL

                                               

                PERSON and FINGERPRINT

                                               

                TREE and BRANCH

                                               

                TEACHER and SUBJECT AREA (*)

                                                                               

One to many relationships are the most uncommon type of relationships in an ERD. True or False?                                                              

                                               

                True

                                               

                False (*)

                                                                               

If two entities have two relationships between them, these relationships can be either _____________ or _____________ .                                

                                               

                Replicated or Required

                                               

                Resourced and Really Good

                                               

                Redundant and Replicated

                                               

                Redundant or Required (*)

                                                                               

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

                                               

                Resourceful

                                               

                Removable

                                               

                Redundant (*)

                                               

                Replicated

                                                                               

Relationships can be Redundant. True or False? 

                                               

                True (*)

                                               

                False

The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False?                  

                                               

                True (*)

                                               

                False

                                                                               

A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False?                                                                         

                                               

                True (*)

                                               

                False

                                                                               

Every ERD must have at least one non-transferable relationship. True or False? 

                                               

                True

                                               

                False (*)

                                                                               

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

                                               

                Transferable (*)

                                               

                Committed

                                               

                Implicit

                                               

                Recursive

                                                                               

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

                                               

                Circle

                                               

                Triangle

                                               

                Heart

                                               

                Diamond (*)