Q#1: ER Model stands for:
(A) Entity-Relation Model
(B) Entity-Relationship Model
(C) Extended Relational Model
(D) External Relation Model
Answer: (B) Entity-Relationship Model
Q#2: The ER model was introduced by:
(A) E. F. Codd
(B) Peter Chen
(C) Alan Turing
(D) Charles Babbage
Answer: (B) Peter Chen
Q#3: In an ER diagram, an entity is represented by a:
(A) Oval
(B) Rectangle
(C) Diamond
(D) Triangle
Answer: (B) Rectangle
Q#4: In an ER diagram, a relationship is represented by a:
(A) Rectangle
(B) Oval
(C) Diamond
(D) Circle
Answer: (C) Diamond
Q#5: Attributes in an ER diagram are represented by:
(A) Rectangle
(B) Oval
(C) Diamond
(D) Line
Answer: (B) Oval
Q#6: Which of the following is a type of attribute?
(A) Simple
(B) Complex
(C) Network
(D) Physical
Answer: (A) Simple
Q#7: An attribute that cannot be divided further is called:
(A) Composite attribute
(B) Derived attribute
(C) Simple attribute
(D) Multivalued attribute
Answer: (C) Simple attribute
Q#8: An attribute that can be divided into smaller parts is called:
(A) Composite attribute
(B) Derived attribute
(C) Single attribute
(D) Key attribute
Answer: (A) Composite attribute
Q#9: An attribute that has multiple values for a single entity is called:
(A) Simple attribute
(B) Derived attribute
(C) Multivalued attribute
(D) Composite attribute
Answer: (C) Multivalued attribute
Q#10: A derived attribute is one that:
(A) Is stored permanently
(B) Is calculated from other attributes
(C) Has multiple values
(D) Is a primary key
Answer: (B) Is calculated from other attributes
Q#11: The key attribute is used to:
(A) Represent relationships
(B) Uniquely identify an entity
(C) Store multiple values
(D) Define composite attributes
Answer: (B) Uniquely identify an entity
Q#12: A weak entity is one that:
(A) Has a primary key
(B) Depends on another entity
(C) Has no attributes
(D) Is independent
Answer: (B) Depends on another entity
Q#13: Weak entities are represented by:
(A) Single rectangle
(B) Double rectangle
(C) Double oval
(D) Double diamond
Answer: (B) Double rectangle
Q#14: The relationship of a weak entity is represented by:
(A) Single diamond
(B) Double diamond
(C) Oval
(D) Rectangle
Answer: (B) Double diamond
Q#15: Cardinality ratio specifies:
(A) Number of attributes
(B) Number of entities
(C) Number of relationships between entities
(D) Type of key
Answer: (C) Number of relationships between entities
Q#16: One-to-many relationship is denoted as:
(A) 1:1
(B) 1:N
(C) M:N
(D) N:1
Answer: (B) 1:N
Q#17: Many-to-many relationship is denoted as:
(A) 1:1
(B) 1:N
(C) M:N
(D) N:1
Answer: (C) M:N
Q#18: Participation constraint specifies:
(A) Minimum and maximum participation of entities
(B) Number of attributes
(C) Type of key
(D) Storage size
Answer: (A) Minimum and maximum participation of entities
Q#19: Total participation is represented by:
(A) Single line
(B) Double line
(C) Dotted line
(D) Arrow
Answer: (B) Double line
Q#20: Partial participation is represented by:
(A) Single line
(B) Double line
(C) Dotted oval
(D) Double diamond
Answer: (A) Single line
Q#21: An entity set is a collection of:
(A) Attributes
(B) Relationships
(C) Similar entities
(D) Keys
Answer: (C) Similar entities
Q#22: A relationship set is a collection of:
(A) Similar relationships
(B) Attributes
(C) Keys
(D) Entities only
Answer: (A) Similar relationships
Q#23: Which attribute is underlined in ER diagram?
(A) Derived attribute
(B) Multivalued attribute
(C) Key attribute
(D) Composite attribute
Answer: (C) Key attribute
Q#24: A composite attribute is represented by:
(A) Oval connected to sub-ovals
(B) Double rectangle
(C) Double diamond
(D) Dotted oval
Answer: (A) Oval connected to sub-ovals
Q#25: Multivalued attribute is represented by:
(A) Single oval
(B) Double oval
(C) Rectangle
(D) Diamond
Answer: (B) Double oval
Q#26: Derived attribute is represented by:
(A) Solid oval
(B) Double oval
(C) Dotted oval
(D) Rectangle
Answer: (C) Dotted oval
Q#27: ER model is mainly used for:
(A) Database design
(B) Data encryption
(C) Network design
(D) Hardware installation
Answer: (A) Database design
Q#28: An identifying relationship is used with:
(A) Strong entity
(B) Weak entity
(C) Attribute
(D) Key
Answer: (B) Weak entity
Q#29: A strong entity is one that:
(A) Depends on another entity
(B) Has a primary key
(C) Has no attributes
(D) Has no relationships
Answer: (B) Has a primary key
Q#30: The ER model is converted into:
(A) Network model
(B) Hierarchical model
(C) Relational model
(D) File system
Answer: (C) Relational model