DATA MODELLING EXAM SCRIPT VERIFIED
QUESTIONS AND SOLUTIONS COMPLETE
REVIEW MATERIAL
●● Why are data models important?
Answer: They facilitate interaction among the designer, applications
programmer, and end user, serving as a communication tool.
●● What are the basic building blocks of a data model?
Answer: Entity, Attribute, Relationship, and Constraint.
●● Define 'Entity' in the context of data modeling.
Answer: Anything about which data are to be collected and stored, such
as a person, place, thing, or event.
●● Give examples of entities.
Answer: CUSTOMER, STUDENT, PATIENT, BLOCK, ROOM,
BOOK, CD, FURNITURE, WEDDING, MUSICAL CONCERT.
●● What is an 'Attribute'?
Answer: A characteristic of an entity, such as CUST_ID or
CUST_ADDRESS.
,●● What does 'Relationship' describe in data modeling?
Answer: An association among entities.
●● What are the types of relationships in data modeling?
Answer: One-to-many (1:M), Many-to-many (M:N or M:M), and One-
to-one (1:1).
●● What is a One-to-many (1:M) relationship?
Answer: A relationship where each instance of one entity can be
associated with multiple instances of another entity.
●● Provide an example of a One-to-many (1:M) relationship.
Answer: PAINTER paints PAINTING: Each painter may paint multiple
paintings, but each painting must be painted by one painter.
●● What is a Many-to-many (M:N) relationship?
Answer: A relationship where multiple instances of one entity can be
associated with multiple instances of another entity.
●● Provide an example of a Many-to-many (M:N) relationship.
Answer: STUDENT takes COURSE: Each student may take multiple
courses, and each course can be taken by multiple students.
, ●● What is a One-to-one (1:1) relationship?
Answer: A relationship where each instance of one entity is associated
with exactly one instance of another entity.
●● Provide an example of a One-to-one (1:1) relationship.
Answer: STAFF manages DEPARTMENT: Each staff member manages
one department, and each department is managed by one staff member.
●● What is a 'Constraint' in data modeling?
Answer: A restriction placed on the data to help ensure data integrity,
usually expressed in the form of rules.
●● Give an example of a constraint.
Answer: A student's GPA must be between 0.00 and 4.00.
●● What are business rules?
Answer: Brief, precise, and unambiguous descriptions of policies,
procedures, or principles within a specific organization.
●● How do business rules influence data modeling?
Answer: They help to clearly identify entities, attributes, relationships,
and constraints.
QUESTIONS AND SOLUTIONS COMPLETE
REVIEW MATERIAL
●● Why are data models important?
Answer: They facilitate interaction among the designer, applications
programmer, and end user, serving as a communication tool.
●● What are the basic building blocks of a data model?
Answer: Entity, Attribute, Relationship, and Constraint.
●● Define 'Entity' in the context of data modeling.
Answer: Anything about which data are to be collected and stored, such
as a person, place, thing, or event.
●● Give examples of entities.
Answer: CUSTOMER, STUDENT, PATIENT, BLOCK, ROOM,
BOOK, CD, FURNITURE, WEDDING, MUSICAL CONCERT.
●● What is an 'Attribute'?
Answer: A characteristic of an entity, such as CUST_ID or
CUST_ADDRESS.
,●● What does 'Relationship' describe in data modeling?
Answer: An association among entities.
●● What are the types of relationships in data modeling?
Answer: One-to-many (1:M), Many-to-many (M:N or M:M), and One-
to-one (1:1).
●● What is a One-to-many (1:M) relationship?
Answer: A relationship where each instance of one entity can be
associated with multiple instances of another entity.
●● Provide an example of a One-to-many (1:M) relationship.
Answer: PAINTER paints PAINTING: Each painter may paint multiple
paintings, but each painting must be painted by one painter.
●● What is a Many-to-many (M:N) relationship?
Answer: A relationship where multiple instances of one entity can be
associated with multiple instances of another entity.
●● Provide an example of a Many-to-many (M:N) relationship.
Answer: STUDENT takes COURSE: Each student may take multiple
courses, and each course can be taken by multiple students.
, ●● What is a One-to-one (1:1) relationship?
Answer: A relationship where each instance of one entity is associated
with exactly one instance of another entity.
●● Provide an example of a One-to-one (1:1) relationship.
Answer: STAFF manages DEPARTMENT: Each staff member manages
one department, and each department is managed by one staff member.
●● What is a 'Constraint' in data modeling?
Answer: A restriction placed on the data to help ensure data integrity,
usually expressed in the form of rules.
●● Give an example of a constraint.
Answer: A student's GPA must be between 0.00 and 4.00.
●● What are business rules?
Answer: Brief, precise, and unambiguous descriptions of policies,
procedures, or principles within a specific organization.
●● How do business rules influence data modeling?
Answer: They help to clearly identify entities, attributes, relationships,
and constraints.
