Home

Communicator
Tools
Profile Settings
Loading, please wait ...
Open its course - Database Systems

Entity Relationship Model

  • Entity Relationship Model
  • Terminologies for ER Model
  • Example of ER Diagram
  • Attributes in ER...
    View Complete Description
    ×

    Topic Summary

    • Entity Relationship Model
    • Terminologies for ER Model
    • Example of ER Diagram
    • Attributes in ER Diagram
    • Refine ER Diagram
    • ER Diagrams Guidelines
    • Connection Traps
      • FAN Trap
      • Chasm Trap
Topic Questions:
92
MCQs T/F FiB SQ
36 21 28 7
Question Type Legends

Easy

Medium

Difficult
MCQs T/F FiB Short Qs
Open its course - Database Systems

Multiple Choice Questions for Entity Relationship Model

  • ×

    Hidden Questions!

    Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.

  • 1 Order of attributes has ________ in a table.
    1. no significance
    2. significance
    3. may be significance
    4. none of them
  • 2 _________ uniquely identifies each tuple in a relation.
    1. Relational Schema
    2. DBMS
    3. Relational keys
    4. All of the above
  • 3 An attribute that holds a single value for each occurrence of an entity type is called
    1. Single-valued attribute
    2. Multi-valued attribute
    3. both them
    4. non of them
  • 4 An attribute that holds multiple values for each occurrence of an entity type is called
    1. Single-valued attribute
    2. Multi-valued attribute
    3. both them
    4. non of them
  • 5 An attribute composed of multiple components, each with an independent existence is called?:
    1. Simple attribute
    2. Composite attribute
    3. Derived attribute
    4. non of them
  • 6 An attribute composed of a single component with an independent existence is called:
    1. Derived attribute
    2. Composite attribute
    3. Simple attribute
    4. non of them
  • 7 In entity diagrams, Considering binary relationships, possible cardinality ratios are:
    1. one : one
    2. 1:N
    3. M:N
    4. All of above
  • 8 Type of diagram in which operations are specified on objects is considered as:
    1. functional diagrams
    2. class diagrams
    3. attribute diagrams
    4. entity diagrams
  • 9 The attribute AGE is calculated from DATE_OF_BIRTH . The attribute AGE is:
    1. single valued
    2. multi valued
    3. composite
    4. derived
  • 10 An _____ is a set of entities of the same type that share the same properties, or attributes.
    1. entity set
    2. attribute set
    3. relation set
    4. entity model
  • 11 ______have state and behavior
    1. entities
    2. objects
    3. methods
  • 12 Set of meaningful associations among the entity types is:
    1. degree of the relationship
    2. relationship type
    3. degree
    4. entity
  • 13 If a member of Staff can manage maximum one Branch, but each branch can have exactly one member of staff, what will be the participation constraint of the Branch entity type?
    1. Mandatory
    2. Optional
    3. None of above
    4. Both a & b
  • 14 “A department may offer number of projects, but a project must belong to at least one department” what is the cardinality ratio from department to project?
    1. One-to-one
    2. One-to-many
    3. Many-to-one
    4. Many-to-many
  • 15 Synonym and Homonym are problems that can arise while
    1. Enterprise key
    2. Normalizing
    3. Integrating relations
    4. all of the above
  • 16 The number of participating entity types in a relationship is called:
    1. Degree
    2. Degree of Relationship Type
    3. Cardinality
    4. Cardinality of Relationship Type
  • 17 An entity type that is not existence-dependent on some other entity type is:
    1. strong
    2. weak
    3. both
    4. none
  • 18 Which of the following integrity constraint apply to all instances of the database.
    1. Domain
    2. Multiplicity
    3. General
    4. Entity
  • 19 One goal to eliminate various anomalies in relational database is to:
    1. reduce attributes
    2. increase data
    3. reduce table
    4. reduce storage space
  • 20 Value of the primary key can be:
    1. Null
    2. Repeating
    3. Zero
    4. None
  • 21 A recursive relationship is a relationship between an entity and with which of the following?
    1. itself
    2. sub-type entity
    3. super-type entity
    4. weak entity
  • 22 Generally the type of relationship between entities TEACHER and STUDENT is:
    1. One-to-Many
    2. Many-to-One
    3. Many-to-Many
    4. None
  • 23 An entity type that is not existence dependent on some other entity type is:
    1. Weak Entity
    2. Strong Entity
    3. Associative entity
    4. Relationship type
  • 24 Which of the following is a top down database design technique?
    1. Entity Relationship Modeling
    2. Functional Dependencies
    3. Specialization
    4. None
  • 25 Which of the following is not a perspective to determine the quality of the ER diagram can be found?
    1. Conceptual Correctness
    2. Logical Correctness
    3. Conceptual completeness
    4. Enterprise awareness
About Us
Who we are Privacy Policy Terms of Use
Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn, Evaluate and Optimize

Products / Utilites
Attendance Mapper Industry Liason Cell (ILC) Smart Secretary
Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert