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
89
Questions
Question Type Legends

Easy

Medium

Difficult

Multiple Choice Questions for Entity Relationship Model

  • 1 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

  • 2 “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

  • 3 Synonym and Homonym are problems that can arise while
    1. Enterprise key
    2. Normalizing
    3. Integrating relations
    4. all of the above

  • 4 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

  • 5 An entity type that is not existence-dependent on some other entity type is:
    1. strong
    2. weak
    3. both
    4. none

  • 6 Which of the following integrity constraint apply to all instances of the database.
    1. Domain
    2. Multiplicity
    3. General
    4. Entity

  • 7 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

  • 8 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

  • 9 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

  • 10 Which of the following is a top down database design technique?
    1. Entity Relationship Modeling
    2. Functional Dependencies
    3. Specialization
    4. None

  • 11 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

Contact Us

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

Subject Expert

Learn and Evaluate

Follow Us
© 2020 - Subject Expert