ORM Modelling — Learn free

Self-check

Questions 1–10 of 10

1. What does ORM stand for in the context of Information Modelling?
Question 1A. Object-Relational MappingB. Operational Rule ModelC. Ordered Relationship MethodD. Object-Role ModellingE. Organisational Resource Model
2. What does ORM treat as the core building blocks of information?
Question 2A. TablesB. AttributesC. FactsD. IndexesE. Swimlanes
3. How would ORM represent the information that an employee has a department?
Question 3A. As a department attribute on the employee tableB. As a foreign key columnC. As a swimlane in a process diagramD. As the fact 'Employee works for Department', with both as objects playing rolesE. As a bounded context
4. In the school example of ORM, how is a student's class expressed?
Question 4A. As a class attribute in a student tableB. As a class ID stored with the studentC. As a gateway in a workflowD. As a column in a reportE. As the fact 'Student is enrolled in Class'
5. Which of the following is an example of an explicit rule that ORM can define in the loan example?
Question 5A. A loan must have exactly one approval decisionB. Loans are stored in a data warehouseC. The loan officer works in the second swimlaneD. Loan amount is stored as a decimalE. Loans are backed up nightly
6. Where do ORM's business rules live?
Question 6A. Hidden in application logicB. In the physical database onlyC. In the model itselfD. In the reporting toolE. In the workflow engine
7. Which of the following is NOT named as a constraint ORM can express directly in the model?
Question 7A. UniquenessB. Mandatory participationC. Allowed combinations of factsD. Cardinality rulesE. Encryption requirements
8. Into which representations can ORM models be transformed?
Question 8A. Entity-relationship diagrams, relational database schemas or XML schemasB. Only BPMN diagramsC. Only spreadsheetsD. Only natural-language documentsE. Only graph databases
9. What drawback does ORM's expressive power introduce?
Question 9A. Models lose all business meaningB. As models grow, ORM diagrams can become difficult for non-technical stakeholders to read and maintainC. Rules can no longer be expressedD. Models cannot be transformed into schemasE. Facts must be stored as attributes
10. How does ORM relate to NIAM?
Question 10A. ORM predates NIAMB. ORM builds on NIAM's ideas but adds much stronger structure and formalityC. ORM is a simplified version of NIAMD. ORM and NIAM are unrelatedE. ORM removes the fact-based approach of NIAM