Entity Relationship Model Objective Questions and Answers - Database Management System MCQs

6 Choose the most appropriate choice with respect to conceptual design.
A Conceptual design is a documentation technique. Once the relation schemes are defined one can draw E-R diagrams from the relation schemes for documentation
B Conceptual design needs data volumn and processing frequencies to determine the size of the database
C Output of any conceptual design is an E-R diagram
D Conceptual design involves modeling the data requirements independent of the DBMS, operating system and the hardware.

Answer: Option [D]
7 E-R modeling technique is a :
A Top-down approach
B Bottom-up approach
C Left-right approach
D None of the above

Answer: Option [A]
8 In an E-R model Oval represents :
A entity sets
B attributes
C relationships
D links

Answer: Option [B]
9 The number of entities to which another entity can be associated via a relationship set is expressed as :
A Entity
B Cardinality
C Schema
D Attributes

Answer: Option [B]
10 Every weak entity set can be converted to a strong entity set by :
A Simply adding appropriate attribute
B Using generalization
C Using aggregation
D Repeating the entity set several times

Answer: Option [B]


Useful Computer Science EBooks