Back to the 2018 paper

Module 1: Database System Architecture

20182m

Data model is collection of conceptual tools for describing
(i) data
(ii) data schema
(iii) consistency constraints
(iv) All of the above

Worked SolutionAI Assisted

Answer

Correct Option: (iv) All of the above

Explanation

A Data Model is a collection of conceptual tools for describing:

  1. Data itself — structure of data (entity, attributes, relationships)
  2. Data relationships — associations among data
  3. Data semantics — meaning and constraints
  4. Consistency constraints — rules to maintain integrity (key, referential, domain constraints)
  5. Data schema — overall organization and definition

Standard definitions (Elmasri/Navathe, Korth):

Data Model = Structure + Operations + Constraints

Hence it describes data, its schema, and consistency constraints together.

Final Answer

Data model covers all three aspects → Option (iv) All of the above.

Similar questions

Budget AppAndroid App

Pocketly on Android

Log daily food, travel, and hostel expenses instantly. Set monthly spending limits and see where your money goes without complex spreadsheets.