Conceptual Data Modelling (CDM) — Learn free

Self-check

Questions 1–10 of 10

1. What does Conceptual Data Modelling (CDM) provide?
Question 1A. A high-level, business-oriented view of data identifying core entities and their relationships without technical implementation detailsB. A platform-specific storage design with indexesC. A list of ETL jobsD. A physical partitioning strategyE. A set of SQL views
2. What is the primary goal of Conceptual Data Modelling?
Question 2A. To capture the essence of business information in a way non-technical stakeholders can understand and validateB. To optimise indexing and storageC. To choose a database vendorD. To define data types for every columnE. To normalise tables to 3NF
3. Which of the following is intentionally omitted at the conceptual modelling level?
Question 3A. Entities such as Customer and LoanB. Relationships between entitiesC. Cardinality rulesD. Attributes such as interest rate, date fields and data typesE. The name of each entity
4. In the loan domain, what cardinality describes the relationship between Customer and Loan?
Question 4A. One-to-oneB. One-to-zero-or-oneC. Many-to-manyD. Zero-to-zeroE. One-to-zero-or-many, since each Loan has exactly one Customer but a Customer may have zero, one or many Loans
5. Why is the relationship between Loan and Approval Decision described as one-to-zero-or-one?
Question 5A. Because a loan can have many decisionsB. Because decisions belong to customersC. Because decisions are optional foreverD. Because a Loan may not yet have a decision while under review, but once processed has exactly oneE. Because approval is stored in a separate system
6. What cardinality holds between an approved Loan and its Repayment Schedule?
Question 6A. One-to-manyB. Many-to-manyC. One-to-oneD. One-to-zero-or-manyE. Zero-to-many
7. In the university example, how is the Student and Course relationship represented at the conceptual level?
Question 7A. As a one-to-one relationshipB. As a one-to-zero-or-one relationshipC. As a unary relationshipD. It cannot be represented conceptuallyE. As a many-to-many relationship, resolved into junction entities later in logical or physical modelling
8. What transition does Conceptual Data Modelling mark?
Question 8A. From logical to physical designB. From process thinking to structural thinkingC. From analytics to operationsD. From cloud to on-premisesE. From data to metadata
9. Which statement about Logical Data Modelling (LDM) is correct?
Question 9A. It is a single modelling techniqueB. It is a stage in the modelling journey where different modelling families and design philosophies emergeC. It is platform-specificD. It replaces conceptual modellingE. It only applies to OLAP systems
10. In the overview of logical modelling families, which technique has the stated limitation of being complex for business users despite offering full traceability?
Question 10A. Dimensional ModellingB. Normal Forms (1NF-3NF+)C. Data VaultD. NoSQL ModellingE. Temporal Modelling