Data Modeling Quiz

What is the primary purpose of a conceptual data model?

• Detailed structure with attributes and data types

• High-level overview of data and relationships

• Implementation of the database

• Data organised in a tree-like structure

In an ER model, what does the 'Relationship' component represent?

• Properties of entities

• Real-world objects or concepts

• Connections between entities

• Methods in a class

Which type of data model focuses on the implementation of the database, including tables and constraints?

• Conceptual Data Model

• Logical Data Model

• Physical Data Model

• Hierarchical Model

What does the 'CustomerID' attribute in the logical data model represent?

• A string data type

• A relationship between entities

• A primary key

• A foreign key

In a hierarchical model, how is data organised?

• Into tables with rows and columns

• Into a tree-like structure

• Into UML diagrams

• Into ER diagrams

What is the purpose of a sequence diagram in UML?

• Shows classes, attributes, and relationships

• Represents connections between entities

• Shows the flow of interactions over time

• Represents attributes of entities

Which of the following is an example of a physical data model element?

• Customer places Order

• CustomerID is an Integer

• SQL table for Customers

• Departments are parents, Employees are children

In an ER model, what is an 'Attribute'?

• An object or concept like Customer

• A property of an entity like Customer Name

Which tool would you use to design an online shopping system's data structure?

• UML Class Diagram

• Sequence Diagram

• Use Case Diagram

• ER Model

What is an example of a class method in a UML diagram for a school system?

• StudentID

• AssignClass()

• Name

• RoomNumber