Halaman

Tuesday, August 6, 2019

Answer Section 7 Quiz Database Design 2019 Learner - English


Section 7
Arcs model an Exclusive OR constraint. True or False?  
                                               
                True (*)

                                               
                False


                                                                               
Which of the following would best be represented by an arc? 
                                               
                PARENT (Girl, Bob)

                                               
                DELIVERY ADDRESS (Home, Office) (*)

                                               
                STUDENT (Grade A student, Average Student)

                                               
                TEACHER (Female, Bob)

                                                                               
All relationships participating in an arc must be mandatory. True or False?     
                                                                               
                                               
                True

                                               
                False (*)

                                                                               
Every business has restrictions on which attribute values and which relationships are allowed. These are known as:                                                   
                                               
                Entities.

                                               
                Attributes

                                               
                Constraints. (*)

                                               
                Relationships

                                                                               
Which of the following can be added to a relationship?
                                               
                An optional attribute can be created

                                               
                An attribute

                                               
                An arc can be assigned (*)

                                               
                A composite attribute

Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?                                                                       
                                               
                True

                                               
                False (*)

                                                                               
To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. 
                                                                               
                                               
                Attribute

                                               
                Relationship

                                               
                UID

                                               
                Arc (*)

                                                                               
Arcs are used to visually represent _________ between two or more relationships in an ERD.                                                           
                                               
                Sameness

                                               
                Inheritance

                                               
                Differences

                                               
                Exclusivity (*)

                                                                               
A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False? 
                                               
                True (*)

                                               
                False

                                                                               
 A single relationship can be both Recursive and Hierarchical at the same time. True or False?                                                         
                                               
                True

                                               
                False (*)

Cascading UIDs are a feature often found in what type of Relationship? 
                                               
                General Relationship

                                               
                Recursive Relationship

                                               
                Invalid Relationship

                                               
                Heirarchical Relationship (*)

Business organizational charts are often modeled as a Hierarchical relationship. True or False?   
                                               
                True (*)

                                               
                False

A Recursive Relationship is represented on an ERD by a/an:   
                                               
                Pig's Ear (*)

                                               
                Crow's Foot

                                               
                Single Toe

                                               
                Dog's Tail

                                                                               
 A recursive relationship must be Mandatory at both ends. True or False?   
                                               
                True

                                               
                False (*)

                                                                               
A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?                                 
                                               
                True (*)

                                               
                False

No comments:

Post a Comment

Final Exam Java Programming 2019 Learner - English

Final Exam