DATA MODELLING UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
COMPREHENSIVE STUDY GUIDE
●● Data models
Answer: Simple representations of complex real-world data structures
●● Model
Answer: Abstraction of a real-world object or event
●● Entity
Answer: Unique and distinct object used to collect and store data
●● Attribute
Answer: Characteristic of an entity
●● Relationship
Answer: Describes an association among entities
●● One-to-many (1:M)
Answer: A relationship where one entity is associated with multiple
instances of another entity.
, ●● Many-to-many (M:N or M:M)
Answer: A relationship where multiple instances of one entity are
associated with multiple instances of another entity.
●● One-to-one (1:1)
Answer: A relationship where one instance of an entity is associated with
exactly one instance of another entity.
●● Constraint
Answer: Set of rules to ensure data integrity.
●● Nouns translate into entities
Answer: In data modeling, nouns in business rules typically represent
entities.
●● Verbs translate into relationships
Answer: In data modeling, verbs in business rules typically represent
relationships among entities.
●● Relationships are bidirectional
Answer: In data modeling, relationships can be traversed in both
directions.
QUESTIONS AND CORRECT ANSWERS
COMPREHENSIVE STUDY GUIDE
●● Data models
Answer: Simple representations of complex real-world data structures
●● Model
Answer: Abstraction of a real-world object or event
●● Entity
Answer: Unique and distinct object used to collect and store data
●● Attribute
Answer: Characteristic of an entity
●● Relationship
Answer: Describes an association among entities
●● One-to-many (1:M)
Answer: A relationship where one entity is associated with multiple
instances of another entity.
, ●● Many-to-many (M:N or M:M)
Answer: A relationship where multiple instances of one entity are
associated with multiple instances of another entity.
●● One-to-one (1:1)
Answer: A relationship where one instance of an entity is associated with
exactly one instance of another entity.
●● Constraint
Answer: Set of rules to ensure data integrity.
●● Nouns translate into entities
Answer: In data modeling, nouns in business rules typically represent
entities.
●● Verbs translate into relationships
Answer: In data modeling, verbs in business rules typically represent
relationships among entities.
●● Relationships are bidirectional
Answer: In data modeling, relationships can be traversed in both
directions.
