Logical Data Modelling (LDM) — Learn free

Self-check

Questions 1–10 of 10

1. What does Logical Data Modelling define?
Question 1A. The detailed structure of entities, attributes and relationships using formal principles such as normalisation, independent of any database technologyB. The physical storage layout for a specific database engineC. The high-level business view of entities without attributesD. The workflow of business processesE. The network of connected knowledge nodes
2. What is the primary goal of Logical Data Modelling?
Question 2A. To choose indexing and partitioning strategiesB. To describe the business in plain languageC. To create a precise, normalised representation of data that is implementation-ready but not tied to a platformD. To define a canonical exchange formatE. To classify concepts into hierarchies
3. In the logical loan model, which attributes are listed for the Loan entity?
Question 3A. CustID, Name and AddressB. DecisionID, Status and DecisionDateC. RepayID, DueDate and StatusD. LoanID, CustID as a foreign key, Amount and ProductTypeE. Interest rate, partition key and index name
4. Which rule ensures a Loan cannot exist without a valid Customer in the logical model?
Question 4A. A partitioning ruleB. A denormalisation ruleC. An indexing ruleD. A naming conventionE. A referential integrity rule
5. How does normalisation handle customer details in the loan example at the logical stage?
Question 5A. Customer details are repeated inside every loan recordB. Customer details are stored in a spreadsheetC. The Customer entity is separated and referenced from Loan through a foreign key, so each fact is stored in one placeD. Customer details are dropped from the modelE. Customer details are stored in the ApprovalDecision entity
6. With which type of system is normalised logical modelling particularly aligned?
Question 6A. OLAP systemsB. OLTP systems, where accuracy and consistency are criticalC. Content management systemsD. Search enginesE. Recommendation systems
7. How might the loan domain be represented logically for OLAP analytical purposes?
Question 7A. As a single unnormalised text fileB. As a fact table such as FactLoanApproval linked to dimension tables such as Customer, Product, Date and DecisionC. As a set of BPMN diagramsD. As a knowledge graph onlyE. As a 6NF decomposition
8. Which of the following is deferred to the physical modelling stage rather than defined logically?
Question 8A. Primary keysB. Foreign keysC. CardinalitiesD. Data types, indexing strategies and partitioning schemesE. Uniqueness constraints
9. Which of the following is NOT something the Logical Data Model explicitly defines?
Question 9A. Primary keysB. Foreign keysC. OptionalityD. Uniqueness constraintsE. Storage clustering
10. What transition does Logical Data Modelling mark?
Question 10A. From abstract business entities to structured schemas with attributes, keys and formal constraintsB. From physical tables to business conceptsC. From process modelling to business modellingD. From metadata to raw dataE. From cloud to on-premises deployment