DATA MODELLING COMPREHENSIVE
EXAM PREP QUESTIONS AND SOLUTIONS
VERIFIED STUDY RESOURCE
●● What are data models?
Answer: Relatively simple representations of complex real-world data
structures, often graphical.
●● What is an entity in a data model?
Answer: Anything about which data are to be collected and stored.
●● What is an attribute in a data model?
Answer: A characteristic of an entity.
●● What does a relationship describe in a data model?
Answer: An association among entities.
●● What are the types of relationships in data models?
Answer: One-to-many (1:M), many-to-many (M:N), and one-to-one
(1:1) relationships.
●● What is a constraint in a data model?
, Answer: A restriction placed on the data.
●● What are business rules?
Answer: Descriptions of policies, procedures, or principles within a
specific organization that apply to data storage and usage.
●● How do business rules influence database design?
Answer: They describe operations to create/enforce actions within an
organization's environment.
●● What is the role of data abstraction in data modeling?
Answer: It helps reconcile different views of the same data by providing
various degrees of abstraction.
●● What is the hierarchical model?
Answer: A data model developed in the 1960s represented by an upside-
down tree structure, containing one-to-many relationships.
●● What are the disadvantages of the hierarchical model?
Answer: Complex to implement, difficult to manage, lacks structural
independence, and does not conform to 1:M relationships.
●● What is the network model?
EXAM PREP QUESTIONS AND SOLUTIONS
VERIFIED STUDY RESOURCE
●● What are data models?
Answer: Relatively simple representations of complex real-world data
structures, often graphical.
●● What is an entity in a data model?
Answer: Anything about which data are to be collected and stored.
●● What is an attribute in a data model?
Answer: A characteristic of an entity.
●● What does a relationship describe in a data model?
Answer: An association among entities.
●● What are the types of relationships in data models?
Answer: One-to-many (1:M), many-to-many (M:N), and one-to-one
(1:1) relationships.
●● What is a constraint in a data model?
, Answer: A restriction placed on the data.
●● What are business rules?
Answer: Descriptions of policies, procedures, or principles within a
specific organization that apply to data storage and usage.
●● How do business rules influence database design?
Answer: They describe operations to create/enforce actions within an
organization's environment.
●● What is the role of data abstraction in data modeling?
Answer: It helps reconcile different views of the same data by providing
various degrees of abstraction.
●● What is the hierarchical model?
Answer: A data model developed in the 1960s represented by an upside-
down tree structure, containing one-to-many relationships.
●● What are the disadvantages of the hierarchical model?
Answer: Complex to implement, difficult to manage, lacks structural
independence, and does not conform to 1:M relationships.
●● What is the network model?
