UNIT 5: DATA MODELLING – ASSIGNMENT 2 & 3 (LEARNING AIM B & C) 2025/2026 COMPLETE COURSEWORK WITH VERIFIED ANSWERS AND DETAILED EXPLANATIONS || 100% GUARANTEED PASS RECENT VERSION

UNIT 5: DATA MODELLING – ASSIGNMENT 2 & 3
(LEARNING AIM B & C) 2025/2026 COMPLETE
COURSEWORK WITH VERIFIED ANSWERS AND
DETAILED EXPLANATIONS || 100% GUARANTEED
PASS <RECENT VERSION>

UNIT 5: DATA MODELLING – LEARNING AIMS B & C
100 QUESTIONS AND ANSWERS
Part 1: Core Concepts & Definitions (Questions 1-20)
1. What is the primary purpose of data modelling?
A) To write efficient SQL code
B) To visually represent data structures and their relationships
C) To create a user interface for a database
D) To improve internet connection speed
2. Which of these is a key benefit of creating a conceptual data model?
A) It defines specific data types for each attribute.
B) It focuses on high-level business concepts and rules, independent of technology.

C) It is optimized for a specific Database Management System (DBMS).
D) It includes primary and foreign keys.
3. In a relational database, what is an "entity"?
A) A person, place, thing, or event about which data is stored.
B) A link between two tables.
C) A specific programming language.
D) A type of database server.
4. What is an "attribute" in the context of data modelling?
A) The speed of a database query.
B) A property or characteristic of an entity.

,C) The relationship between two entities.
D) A backup of the database.
5. A "relationship" in an ERD (Entity-Relationship Diagram) represents:
A) The connection between a programmer and a user.
B) An association between two or more entities.
C) The data type of a column.
D) The hardware configuration of the server.
6. What does cardinality define in a data model?
A) The number of tables in a database.
B) The data types of the primary keys.
C) The number of instances of one entity that can be associated with another.
D) The speed of database transactions.
7. The term "modality" (or optionality) in a relationship indicates:
A) Whether the relationship is mandatory or optional.
B) The maximum number of entity instances.
C) The name of the foreign key.
D) The programming language used.
8. Which of the following is the correct cardinality for "one and only one"?
A) 0..*
B) 1..*
C) 0..1
D) 1..1
9. A relationship where one instance of Entity A is associated with many
instances of Entity B is called:
A) One-to-One (1:1)
B) One-to-Many (1:M)
C) Many-to-Many (M:N)
D) Many-to-One (M:1)
10. What is a "weak entity"?
A) An entity that is not important to the business.
B) An entity that depends on another entity for its existence and identity.

, C) An entity with only one attribute.
D) An entity that has no relationships.
11. What is a "composite attribute"?
A) An attribute that can be divided into smaller, meaningful parts.
B) An attribute that is derived from other attributes.
C) An attribute used as a primary key.
D) An attribute that is optional.
12. A "derived attribute" is:
A) An attribute that is the primary key.
B) An attribute whose value can be calculated from other attributes.
C) An attribute that is made up of multiple parts.
D) An attribute that is always null.
13. What is the main goal of normalization?
A) To make the database faster.
B) To reduce data redundancy and prevent anomalies.
C) To create more tables.
D) To improve the visual design of the ERD.
14. An "insertion anomaly" occurs when:
A) You cannot insert data because you are missing other, unrelated data.
B) You insert too much data at once.
C) The database connection is lost during an insert.
D) Data is inserted in the wrong order.
15. The First Normal Form (1NF) requires that:
A) There are no partial dependencies.
B) All attributes are atomic (no repeating groups).
C) All non-key attributes are dependent on the whole primary key.
D) There are no transitive dependencies.
16. A table is in Second Normal Form (2NF) if it is in 1NF and:
A) It has a single-column primary key.
B) All non-key attributes are fully functionally dependent on the entire primary
key.