1. A many to many relationships between two entities usually results in how many tables?
(A) One
(B) Two
(C) Three
(D) Four
2. An ________ is a set of entities of the same type that share the same properties, or attributes.
(A) Entity model
(B) Attribute set
(C) Relation set
(D) Entity set
3. Entity is a _________.
(A) Thing in real world
(B) Present working model
(C) Object of relation
(D) Model of relation
4. Every weak entity set can be converted into a strong entity set by:
(A) using generalization
(B) using aggregation
(C) adding appropriate attributes
(D) none of the above
5. E-R modeling technique is a ______.
(A) Left-right approach
(B) Bottom-up approach
(C) Top-down approach
(D) None of the above
6. In ER model the details of the entities are hidden from the user. This process is called:
(A) Abstraction
(B) Specialization
(C) Generalization
(D) none of these above
7. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
(A) Single valued
(B) Derived
(C) Composite
(D) Multi valued
8. Which of the following can be a multivalued attribute?
(A) All of the mentioned
(B) Name
(C) Date_of_birth
(D) Phone_number
9. Which of the following is a single valued attribute?
(A) SUBJECT_TAKEN
(B) Address
(C) Register_number
(D) Reference
10. The relationship between the entities is represented graphically by using_____.
(A) Data Flow Diagram
(B) ER Diagram
(C) Flowcharts
(D) Decision Tables
11. Which of following represents entity?
(A) Student
(B) Teacher
(C) All of these
(D) Train
12. In an ER diagram, entities are represented by _______.
(A) Circles
(B) Diamond shaped box
(C) Rectangles
(D) Ellipse
13. A collection of entities that have common attributes is called
(A) Entity type
(B) Both a and b
(C) Entity Set
(D) Entity Class
14. The characteristics of an entity are called_____.
(A) Entity Set
(B) Entity Class
(C) Entity Attributes
(D) Entity properties
15. In a relational database model, the number of records in a table is called
(A) Modality
(B) Degree of relation
(C) Cardinality
(D) All of these
16. Strong entity is also called
(A) Dependent Entity
(B) Subordinate Entity
(C) Parent Entity
(D) Child Entity
17. The process of defining one or more subtype of a supertype is called_____.
(A) Generalization
(B) Identifier
(C) Cardinality
(D) Specialization
18. The entity types Car and Truck can be generalized into the entity type___.
(A) Train
(B) Engine
(C) Bus
(D) Vehicle