HomeSubjectsUniversityBlogAbout

Data Models

Topic in Databases

210 total MCQsShowing 30 with explanations10 Easy10 Medium10 Hard
Start Timed Quiz on Data ModelsBack to Databases

About This Topic

A data model is a set of concepts for describing the structure of data, its relationships and its constraints, such as the ER and relational models. Much of this area revolves around ER diagram notation: rectangles for entity sets, diamonds for relationships, ovals for attributes, underlined key attributes, double rectangles for weak entities and double lines for total participation. You should also handle cardinality ratios (1:1, 1:N, M:N), mapping an M:N relationship to a separate table, and Enhanced ER features such as specialization, generalization, disjoint versus overlapping constraints, and lattices formed by multiple inheritance. Hierarchical, network and object-based models appear occasionally for comparison.

Below are 30 practice questions from a pool of 210 Data Models MCQs, one of 17 topics in Databases. Each shows the correct answer with an explanation; when you are ready, take a timed quiz to test recall under exam conditions.

Practice Questions

Each question below shows the correct answer with a full explanation. Use these to build conceptual understanding before attempting a timed quiz.

Data ModelsEasy

Q1. Which data model organizes data in tables of rows and columns?

  1. A.Relational model✓ Correct
  2. B.Object model
  3. C.Hierarchical model
  4. D.Network model

Explanation

The relational model organizes data into tables (relations) consisting of rows and columns.

Report an error in this question

Data ModelsEasy

Q2. In the hierarchical data model, data is organized as a:

  1. A.Graph structure
  2. B.Star structure
  3. C.Tree structure✓ Correct
  4. D.Table structure

Explanation

The hierarchical model organizes data in a tree-like parent-child structure.

Report an error in this question

Data ModelsEasy

Q3. An Entity-Relationship (ER) diagram is used to:

  1. A.Design network topologies for servers
  2. B.Create application interfaces for users
  3. C.Model the conceptual design of a database✓ Correct
  4. D.Write SQL queries against stored tables

Explanation

ER diagrams are used for conceptual database design showing entities and their relationships.

Report an error in this question

Data ModelsEasy

Q4. In an ER diagram, a rectangle represents:

  1. A.An entity type✓ Correct
  2. B.A relationship
  3. C.An attribute
  4. D.A primary key

Explanation

Rectangles represent entities in an ER diagram.

Report an error in this question

Data ModelsEasy

Q5. An attribute in a data model represents:

  1. A.A constraint on records
  2. B.A property of an entity✓ Correct
  3. C.A table in the database
  4. D.A relationship between entities

Explanation

An attribute represents a property or characteristic of an entity.

Report an error in this question

Data ModelsEasy

Q6. Which symbol represents a relationship in an ER diagram?

  1. A.Ellipse
  2. B.Rectangle
  3. C.Triangle
  4. D.Diamond✓ Correct

Explanation

A diamond shape represents a relationship in an ER diagram.

Report an error in this question

Data ModelsEasy

Q7. A primary key uniquely identifies:

  1. A.A relationship instance
  2. B.A single column value
  3. C.Each record in a table✓ Correct
  4. D.An entire database schema

Explanation

A primary key uniquely identifies each record (tuple) in a table.

Report an error in this question

Data ModelsEasy

Q8. In the network data model, the relationship between records is:

  1. A.Many-to-many using sets✓ Correct
  2. B.No relationships allowed
  3. C.Hierarchical only structure
  4. D.One-to-one relationships

Explanation

The network model supports many-to-many relationships using sets (owner-member).

Report an error in this question

Data ModelsEasy

Q9. The relational data model was proposed by:

  1. A.Edgar Dijkstra
  2. B.Charles Bachman
  3. C.E.F. Codd✓ Correct
  4. D.Peter Chen

Explanation

E.F. Codd proposed the relational data model in 1970.

Report an error in this question

Data ModelsEasy

Q10. Which of these is NOT a data model?

  1. A.Relational model
  2. B.Hierarchical model
  3. C.Compiler model✓ Correct
  4. D.Network model

Explanation

There is no data model called the Compiler model.

Report an error in this question

Data ModelsMedium

Q11. In an Enhanced ER (EER) model, specialization is:

  1. A.Adding new relationships between existing entity types
  2. B.Combining multiple entity types into a single entity
  3. C.The process of defining subclasses of an entity type✓ Correct
  4. D.Removing attributes from entities during refinement

Explanation

Specialization defines subclasses of a superclass entity type based on distinguishing characteristics.

Report an error in this question

Data ModelsMedium

Q12. A weak entity in an ER diagram:

  1. A.Cannot be uniquely identified by its own attributes alone✓ Correct
  2. B.Is always fully independent of any other entity type
  3. C.Cannot have any attributes or properties defined on it
  4. D.Has a complete primary key defined on its own attributes

Explanation

A weak entity depends on an owner entity for identification as it lacks a complete primary key.

Report an error in this question

Data ModelsMedium

Q13. Total participation in an ER diagram means:

  1. A.The relationship is optional for all entities
  2. B.No entity participates in the defined relationship
  3. C.Only some entities participate in the relationship
  4. D.Every entity must participate in the relationship✓ Correct

Explanation

Total participation means every entity in the entity set must participate in the relationship.

Report an error in this question

Data ModelsMedium

Q14. A composite attribute is:

  1. A.An attribute that holds multiple values for one entity
  2. B.An attribute that serves as the key for identification
  3. C.An attribute whose value is derived from other attributes
  4. D.An attribute that can be divided into smaller sub-attributes✓ Correct

Explanation

A composite attribute can be divided into smaller meaningful sub-attributes (e.g., Name into First and Last).

Report an error in this question

Data ModelsMedium

Q15. A multivalued attribute is represented in an ER diagram by:

  1. A.A single ellipse
  2. B.A rectangle shape
  3. C.A dashed ellipse
  4. D.A double ellipse✓ Correct

Explanation

A double ellipse represents a multivalued attribute in an ER diagram.

Report an error in this question

Data ModelsMedium

Q16. In an ER diagram, a double rectangle represents:

  1. A.A weak entity✓ Correct
  2. B.An attribute
  3. C.A relationship
  4. D.A strong entity

Explanation

A double rectangle represents a weak entity in an ER diagram.

Report an error in this question

Data ModelsMedium

Q17. Generalization in EER modeling is:

  1. A.Adding new attributes to an existing entity class
  2. B.Removing a class entirely from the ER model
  3. C.Splitting a single class into multiple subclasses
  4. D.Combining subclasses into a generalized superclass✓ Correct

Explanation

Generalization combines common features of subclasses into a generalized superclass.

Report an error in this question

Data ModelsMedium

Q18. A derived attribute is one whose value:

  1. A.Must be entered manually by users
  2. B.Cannot change once it is set initially
  3. C.Is always NULL in every record stored
  4. D.Can be computed from other attributes✓ Correct

Explanation

A derived attribute's value can be computed from other stored attributes (e.g., age from date of birth).

Report an error in this question

Data ModelsMedium

Q19. The cardinality ratio in an ER model specifies:

  1. A.The overall size of the database measured in stored records
  2. B.The number of attributes defined on a single entity type
  3. C.The total number of entities present in the entire ER model
  4. D.The number of relationship instances an entity can participate in✓ Correct

Explanation

Cardinality ratio specifies the maximum number of relationship instances an entity can participate in.

Report an error in this question

Data ModelsMedium

Q20. An object-oriented data model supports:

  1. A.Only tree structures and parent-child links
  2. B.Only tables, rows, and column structures
  3. C.Only flat files and sequential access paths
  4. D.Encapsulation, inheritance, and polymorphism✓ Correct

Explanation

The object-oriented data model supports OOP concepts like encapsulation, inheritance, and polymorphism.

Report an error in this question

Data ModelsHard

Q21. In the EER model, an overlapping specialization means:

  1. A.An entity can belong to multiple subclasses✓ Correct
  2. B.No entity can be specialized at all
  3. C.An entity belongs to exactly one subclass
  4. D.Subclasses have no common superclass type

Explanation

Overlapping specialization allows an entity to be a member of more than one subclass simultaneously.

Report an error in this question

Data ModelsHard

Q22. A category (union type) in the EER model represents:

  1. A.A superclass entity that has no subclasses
  2. B.An entity defined without any attributes
  3. C.A relationship with no participants at all
  4. D.A subclass with multiple possible superclasses✓ Correct

Explanation

A category is a subclass that is a union of different entity types (multiple superclasses).

Report an error in this question

Data ModelsHard

Q23. The concept of aggregation in the ER model is used to:

  1. A.Treat a relationship set as a higher-level entity✓ Correct
  2. B.Create weak entities that depend on other types
  3. C.Delete entities from the conceptual data model
  4. D.Merge two databases into a single schema model

Explanation

Aggregation treats a relationship set and its participating entities as a higher-level entity.

Report an error in this question

Data ModelsHard

Q24. In a ternary relationship among three entities A, B, and C, the cardinality constraint is specified:

  1. A.Only for the strongest entity participating here
  2. B.Only for one entity in the ternary relationship
  3. C.Cardinality does not apply to ternary relationships
  4. D.For each pair of entities with respect to the third✓ Correct

Explanation

In a ternary relationship, cardinality is specified for each pair of entities relative to the third.

Report an error in this question

Data ModelsHard

Q25. Disjoint constraint (d) on specialization means:

  1. A.An entity can be a member of at most one subclass✓ Correct
  2. B.Subclasses can overlap with shared memberships
  3. C.There is no constraint on subclass membership
  4. D.An entity must belong to all subclasses at once

Explanation

The disjoint constraint ensures an entity can belong to at most one subclass of a specialization.

Report an error in this question

Data ModelsHard

Q26. Attribute inheritance in EER means:

  1. A.Attributes are shared across all entities uniformly
  2. B.Subclass entities inherit all attributes of the superclass✓ Correct
  3. C.Attributes cannot be inherited between entity types
  4. D.Superclass inherits all attributes from the subclass

Explanation

Attribute inheritance means subclass entities automatically inherit all attributes defined for the superclass.

Report an error in this question

Data ModelsHard

Q27. A lattice in the EER model occurs when:

  1. A.An entity has no attributes or properties defined on it
  2. B.A superclass has no subclasses defined in the model at all
  3. C.A subclass has more than one superclass (multiple inheritance)✓ Correct
  4. D.All entities in the model are weak entity types entirely

Explanation

A lattice structure occurs with multiple inheritance where a subclass has more than one superclass.

Report an error in this question

Data ModelsHard

Q28. The Object-Relational model extends the relational model by adding:

  1. A.Hierarchical parent-child relationships between records
  2. B.Network-style pointers linking records across the model
  3. C.Only more tables and relations without other extensions
  4. D.Support for complex data types, methods, and inheritance✓ Correct

Explanation

The Object-Relational model adds complex types, user-defined types, methods, and inheritance to the relational model.

Report an error in this question

Data ModelsHard

Q29. In the Entity-Relationship model, the participation constraint and cardinality ratio together define:

  1. A.Query optimization parameters used
  2. B.Physical storage structure of tables
  3. C.Only the key constraints of entities
  4. D.Structural constraints of a relationship✓ Correct

Explanation

Structural constraints include both cardinality ratio and participation constraints of a relationship.

Report an error in this question

Data ModelsHard

Q30. A recursive relationship is one where:

  1. A.No entity type participates in the relationship that is defined
  2. B.The same entity type participates more than once in different roles✓ Correct
  3. C.Only weak entity types participate in the relationship instance
  4. D.Two different entity types participate together in one relationship

Explanation

A recursive (unary) relationship involves the same entity type participating in different roles (e.g., Employee manages Employee).

Report an error in this question

More Databases Topics

Introduction to Database Systems

Practice MCQs with explanations

Database Architecture

Practice MCQs with explanations

Relational Database Concepts

Practice MCQs with explanations

Relational Algebra & Calculus

Practice MCQs with explanations

SQL

Practice MCQs with explanations

Advanced SQL

Practice MCQs with explanations

Ready to test yourself on Data Models?

Take a timed quiz drawn from 210+ questions on this topic. No signup required — your progress saves in your browser.

Start Data Models Quiz