DataBase Management System

DBMS Data Models

⛪ Computer Science and Engineering > DataBase Management System

The overall database design and implementation process starts with requirements gathering and specifications. Once the requirements of the user have been specified, the next step is to construct an abstract or conceptual model of a database based on the requirements of the user. This phase is known as conceptual modeling or semantic modeling. ➲ DBMS Data Models - Quiz

Q 1: Which of the following phases of database design is the E-R model related to?

  • A Conceptual database design
  • B Logical database design
  • C Requirement analysis
  • D None of these

Q 2: If an entity as a conceptual existence, it is termed as

  • A Concrete entity
  • B Abstract entity
  • C Entity type
  • D None of these

Q 3: Which of these statements describes an entity correctly?

  • A An entity is a distinguishable object that has an independent existence in the real world
  • B An entity may be related to itself
  • C An entity may be related to many other entities
  • D All of these

Q 4: Which of these statements are correct for the term attributes?

  • A The attributes are the properties of an entity that characterize and describe it
  • B Each attribute has a particular value
  • C Each attribute can accept a value from a set of permitted values called the domain
  • D All of these

Q 5: The entity set that participates in a relationship

  • A None of these
  • B Is distinct
  • C Need not be distinct
  • D May or may not be distinct

Q 6: Which of the following attributes is used to uniquely identify an instance of an entity?

  • A Unique attribute
  • B Simple attribute
  • C Identifying attribute
  • D Multi-valued attribute

Q 7: Which of these attributes can be considered as the identifying attribute for an entity student?

  • A Address
  • B Roll number
  • C Marks
  • D Any of these

Q 8: The relationship that exists between a weak entity type and its identifying entity type is known as

  • A Identifying relationship
  • B Weak relationship
  • C Strong relationship
  • D Relationship type

Q 9: The relationship between two entity types is known as

  • A Two-way relationship
  • B Double relationship
  • C Binary relationship
  • D Multiple relationship

Q 10: A person has a PAN card. Which of the following relationships is correct for this condition?

  • A One-to-one
  • B One-to-many
  • C Many-to-many
  • D Many-to-one

Q 11: The strong entity type and weak entity type participates in

  • A One-to-one relationship
  • B One-to-many relationship
  • C Many-to-one relationship
  • D Many-to-many relationship

Q 12: In an E-R diagram,

  • A Square
  • B Rectangle
  • C Diamond-shaped box
  • D Ellipse

Q 13: The process of defining the subgroups of a given entity type is known as

  • A Generalization
  • B Aggregation
  • C Participation
  • D Specialization

Q 14: When common attributes of entity types are combined to form higher-level entity type, it is called

  • A Inheritance
  • B Specialization
  • C Aggregation
  • D Generalization

Q 15: Rational Rose is a popular tool used to draw

  • A E-R
  • B EER
  • C UML
  • D None of these

Q 16: UML class diagram is used to represent the

  • A Conceptual
  • B Relational
  • C Both (a) and (b)
  • D None of these