Answer Section 3 Quiz Database Design 2019 Learner - English

Section 3

Which of the following are true about Relationship Optionality? (Choose two) 

                                                                               

                                               

                Optionality answers "may or must". (*)

                                               

                Optionality specifies whether something is required or not. (*)

                                               

                Optionality specifies only singularity or plurality, but not a specific plural number.

                                               

                Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.

                                                                               

Which of the following are used to show Cardinality on an ERD? (Choose two)  

                                                                               

                                               

                Crow's foot. (*)

                                               

                Single toe. (*)

                                               

                Dashed line.

                                               

                Solid line.

One Relationship can be mandatory in one direction and optional in the other direction. True or False? 

                                               

                True (*)

                                               

                False

                                                                               

Which of the following are true about Cardinality? (Choose two)   

                                               

                Cardinality specifies only singularity or plurality, but not a specific plural number. (*)

                                               

                Cardinality specifies whether something is required or not.

                                               

                Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.

                                               

                Cardinality tells "how many". (*)

                                                                               

Relationships always exist between    

                                                                               

                                               

                2 entities (or one entity and itself) (*)

                                               

                3 or more entities

                                               

                2 attributes

                                               

                3 or more attributes

Relationship Cardinality is important. True or False?

                                               

                True (*)

                                               

                False

When reading a relationship between 2 entities, the relationship is read both from left to right and right to left. True or False? 

                                                                               

                                               

                True (*)

                                               

                False

                                                                               

When reading the relationships in an ERD, you are said to be speaking: 

                                                                               

                                               

                Relationship-ish

                                               

                ERDish (*)

                                               

                Gibberish

                                               

                Entity-ish

                                                                               

Which of the following are used to show a relationship on an ERD? (Choose Three)     

                                                                               

                                               

                Dashed line. (*)

                                               

                Solid line. (*)

                                               

                # symbol.

                                               

                Crow's foot. (*)

                                                                               

ERDish describes a relationship in words. True or False? 

                                               

                True (*)

                                               

                False

Matrix Diagrams are developed BEFORE the ERD. True or False?             

                                               

                True (*)

                                               

                False

                                                                               

Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False?                                           

                                               

                True (*)

                                               

                False

                                                                               

Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?                                            

                                               

                True

                                               

                False (*)

                                                                               

Entity boxes are drawn as     

             

                                               

                Normal Circles

                                               

                Hard Boxes

                                               

                Soft Boxes (*)

                                               

                Bold Circles

                                                                               

To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False?                                           

                                               

                True (*)

                                               

                False