L06a Exploring Data Models and Their Uses

Which of the following best describes a hierarchical data model?

• A model where data is organised in a graph structure with multiple parent-child relationships.

• A model where data is organised in a tree structure with a single parent for each child.

• A model where data is organised in tables with relationships defined by keys.

• A model where data is organised in a network of interconnected nodes.

What is one advantage of the hierarchical data model?

• It allows for complex many-to-many relationships.

• It is easy to implement and understand due to its simple tree structure.

• It supports ad-hoc queries efficiently.

• It is highly flexible and adaptable to changes.

In which scenario is the network data model most effectively used?

• When data needs to be stored in a simple, flat structure.

• When there are complex many-to-many relationships between data entities.

• When data is organised in a strict hierarchy.

• When data is primarily used for analytical purposes.

Which of the following is a key feature of the entity relationship model?

• It uses a tree structure to represent data.

• It uses a graph structure to represent data.

• It uses tables to represent entities and relationships.

• It uses a network of interconnected nodes.

What is a common use of entity relationship diagrams (ERDs)?

• To represent data in a hierarchical format.

• To visualise the relationships between different data entities.

• To model data in a network structure.

• To optimise database performance.

How does the hierarchical data model compare to the network data model in terms of flexibility?

• The hierarchical model is more flexible than the network model.

• The network model is more flexible than the hierarchical model.

• Both models offer the same level of flexibility.

• Neither model is flexible.

Which of the following is a disadvantage of the hierarchical data model?

• It is difficult to implement.

• It does not support many-to-many relationships.

• It is not suitable for large databases.

• It is not compatible with modern database systems.

What is a primary benefit of using the network data model?

• It simplifies data retrieval by using a tree structure.

• It allows for complex relationships and efficient data retrieval.

• It is easy to implement and maintain.

• It is the most modern data model available.

Which of the following best describes an entity in an entity relationship model?

• A single piece of data.

• A collection of related data items.

• A real-world object or concept represented in the database.

• A relationship between two data items.

What is the main purpose of using an entity relationship diagram (ERD) in database design?

• To create a physical database schema.

• To define the data types used in the database.

• To provide a visual representation of the database structure.

• To optimise database queries.