Question

37.          Entity-Relationship diagram is developed in _________________.

                                A. Conceptual Data Model                                                                           B. Logistical Database Design

                                C. Physical Database Design                                                                         D. Implementation

38.          Which of the following database models only expresses a 1:M relationship?

                                A. Hierarchical model

                                B. Relational model

                                C. Objected-oriented model

                                D. Network model

39.          The subtype discriminator is a simple attribute when there is a(n):

                                A. overlap rule                                                                   B. disjoint rule

                                C. no specialization                                                          D. None of the above

40.          A relation that contains minimal redundancy and allows easy use is considered to be:

                                A. Clean                                                                               B. Simple

                                C. Well-maintained                                                         D. Well-structured

41.          Which of the following is NOT a requirement for a table to qualify as a relation?

                                A. It should have unique name

                                B. Its attributes should have unique names

                                C. Every attribute must be atomic

                                D. Columns and rows must be ordered

42.          Relationship between brothers and sisters is an example of __________ relationship

                                A. one-to-one                                                                   B. one-to-many

                                C. many-to-many                                                             D. none of the above

Answer 1

37)A. Conceptual Data Model

38)D. Network model

39)    B. disjoint rule

40) C. Well-maintained

41) D. Columns and rows must be ordered ( correct answer: Columns and rows must be irrelevent)

42) C. many-to-many