Understanding Data Models in Organisations

What is the primary purpose of a conceptual data model?

• To define the physical storage of data

• To provide a high-level understanding of the organisational data

• To specify the data types and relationships

• To optimise database performance

Which of the following is a characteristic of a logical data model?

• It includes detailed data types and constraints

• It is used to design the physical storage of data

• It is primarily used for data visualisation

• It focuses on the hardware requirements

What is the main focus of a physical data model?

• To define the business rules and policies

• To describe how data is stored in the database

• To provide a conceptual view of the data

• To establish user access levels

In a hierarchical database model, data is organised in which structure?

• A flat file

• A tree-like structure

• A network graph

• A tabular format

Which of the following is a key principle of the relational model?

• Data is stored in a hierarchical format

• Data is organised in tables with rows and columns

• Data is stored in a single flat file

• Data is accessed through a network protocol

What is a common use of a conceptual data model in organisations?

• To create detailed database schemas

• To facilitate communication between stakeholders

• To implement database security measures

• To optimise query performance

Which of the following best describes a logical data model?

• It is a blueprint for the physical database

• It is a high-level overview of the data

• It is a detailed representation of data entities and relationships

• It is a user interface for data entry

What is a primary advantage of using a physical data model?

• It simplifies the data entry process

• It enhances data security

• It provides a detailed view of data storage

• It improves data visualisation

In a hierarchical database model, what is a "parent" node?

• A node that has no children

• A node that has one or more child nodes

• A node that is at the bottom of the hierarchy

• A node that is isolated from others

Which of the following is true about the relational model?

• It uses pointers to connect data

• It allows for complex many-to-many relationships

• It is based on set theory and predicate logic

• It is primarily used for unstructured data