Chapter 8 Entity Relationship (E-R) Modeling MCQs 18 min Score: 0 Attempted: 0/18 Subscribe 1. A many to many relationships between two entities usually results in how many tables? (A) One (B) Two (C) Three (D) FourShow All Answers 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 setShow All Answers 3. Entity is a _________. (A) Thing in real world (B) Present working model (C) Object of relation (D) Model of relationShow All Answers 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 aboveShow All Answers 5. E-R modeling technique is a ______. (A) Left-right approach (B) Bottom-up approach (C) Top-down approach (D) None of the aboveShow All Answers 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 aboveShow All Answers 7. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is (A) Single valued (B) Derived (C) Composite (D) Multi valuedShow All Answers 8. Which of the following can be a multivalued attribute? (A) All of the mentioned (B) Name (C) Date_of_birth (D) Phone_numberShow All Answers 9. Which of the following is a single valued attribute? (A) SUBJECT_TAKEN (B) Address (C) Register_number (D) ReferenceShow All Answers 10. The relationship between the entities is represented graphically by using_____. (A) Data Flow Diagram (B) ER Diagram (C) Flowcharts (D) Decision TablesShow All Answers 11. Which of following represents entity? (A) Student (B) Teacher (C) All of these (D) TrainShow All Answers 12. In an ER diagram, entities are represented by _______. (A) Circles (B) Diamond shaped box (C) Rectangles (D) EllipseShow All Answers 13. A collection of entities that have common attributes is called (A) Entity type (B) Both a and b (C) Entity Set (D) Entity ClassShow All Answers 14. The characteristics of an entity are called_____. (A) Entity Set (B) Entity Class (C) Entity Attributes (D) Entity propertiesShow All Answers 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 theseShow All Answers 16. Strong entity is also called (A) Dependent Entity (B) Subordinate Entity (C) Parent Entity (D) Child EntityShow All Answers 17. The process of defining one or more subtype of a supertype is called_____. (A) Generalization (B) Identifier (C) Cardinality (D) SpecializationShow All Answers 18. The entity types Car and Truck can be generalized into the entity type___. (A) Train (B) Engine (C) Bus (D) VehicleShow All Answers