UNIT 5: DATA MODELLING – ASSIGNMENT 1
(LEARNING AIM A) 2025/2026 VERIFIED
COURSEWORK WITH CORRECT SOLUTIONS AND
EXPLANATIONS || 100% GUARANTEED PASS
<RECENT VERSION>
UNIT 5: DATA MODELLING – LEARNING AIM A (FUNDAMENTALS)
100 Questions and Answers for Guaranteed Success
Section 1: Core Concepts & Definitions
1. What is the primary purpose of data modelling?
a) To write efficient SQL code
b) To visually represent data and its relationships to support the development
of information systems
c) To create graphical user interfaces for databases
d) To optimize the hardware for database servers
,2. A data model acts as a _____ between the real-world concepts of a
system and the digital representation in a database.
a) Barrier
b) Bridge
c) Filter
d) Compiler
3. Which of these is a key benefit of creating a data model before building
a database?
a) It eliminates the need for a database administrator.
b) It ensures data integrity and reduces redundancy.
c) It automatically generates the application code.
d) It makes the database hardware-independent.
4. The term "Data Integrity" in a database context refers to:
a) The speed of data retrieval.
b) The accuracy, consistency, and reliability of data.
c) The amount of data stored.
d) The security encryption of data.
5. What does "Data Redundancy" mean?
a) Storing the same piece of data in multiple places.
, b) Having backup copies of the database.
c) Using redundant hardware systems.
d) Deleting old and unused data.
Section 2: Data Modelling Concepts & Terminology
6. An "Entity" in a data model is best described as:
a) A person, place, thing, event, or concept about which data is stored.
b) The line connecting two tables.
c) A single piece of data like a name or date.
d) A unique identifier for a record.
7. An "Attribute" is:
a) A property or characteristic of an entity.
b) A link between two entities.
c) A category of data models.
d) A type of database management system.
8. A "Relationship" in a data model defines:
a) How two entities are connected or associated.
b) The primary key of an entity.
c) The data type of an attribute.
d) The business rules of an organization.
(LEARNING AIM A) 2025/2026 VERIFIED
COURSEWORK WITH CORRECT SOLUTIONS AND
EXPLANATIONS || 100% GUARANTEED PASS
<RECENT VERSION>
UNIT 5: DATA MODELLING – LEARNING AIM A (FUNDAMENTALS)
100 Questions and Answers for Guaranteed Success
Section 1: Core Concepts & Definitions
1. What is the primary purpose of data modelling?
a) To write efficient SQL code
b) To visually represent data and its relationships to support the development
of information systems
c) To create graphical user interfaces for databases
d) To optimize the hardware for database servers
,2. A data model acts as a _____ between the real-world concepts of a
system and the digital representation in a database.
a) Barrier
b) Bridge
c) Filter
d) Compiler
3. Which of these is a key benefit of creating a data model before building
a database?
a) It eliminates the need for a database administrator.
b) It ensures data integrity and reduces redundancy.
c) It automatically generates the application code.
d) It makes the database hardware-independent.
4. The term "Data Integrity" in a database context refers to:
a) The speed of data retrieval.
b) The accuracy, consistency, and reliability of data.
c) The amount of data stored.
d) The security encryption of data.
5. What does "Data Redundancy" mean?
a) Storing the same piece of data in multiple places.
, b) Having backup copies of the database.
c) Using redundant hardware systems.
d) Deleting old and unused data.
Section 2: Data Modelling Concepts & Terminology
6. An "Entity" in a data model is best described as:
a) A person, place, thing, event, or concept about which data is stored.
b) The line connecting two tables.
c) A single piece of data like a name or date.
d) A unique identifier for a record.
7. An "Attribute" is:
a) A property or characteristic of an entity.
b) A link between two entities.
c) A category of data models.
d) A type of database management system.
8. A "Relationship" in a data model defines:
a) How two entities are connected or associated.
b) The primary key of an entity.
c) The data type of an attribute.
d) The business rules of an organization.
