DBC_CHAPTER 2

What is the primary role of data models in an organization?

• To store data permanently

• To serve as a communication tool

Which of the following is NOT a basic building block of a data model?

• Entity

• Attribute

• Function

• Relationship

What type of relationship describes an association where one entity can relate to many others?

• One-to-many (1:M)

• Many-to-many (M:N)

What is a business rule?

• A description of a policy or principle

• A type of data model

What does the conceptual model provide?

• A physical representation of data

• A global view of the entire database

Which level of data abstraction is the end user's view of the data environment?

• External Model

• Conceptual Model

What is the purpose of mapping in data models?

• To translate elements between different levels

• To visualize data relationships

Which of the following is an example of a constraint in a data model?

• A relationship between entities

• A restriction placed on data

What does the internal model represent?

• The user's perspective of data

• The database as seen by the DBMS

What is the first step in the evolution of data models?

• Defining data abstraction levels

• Addressing previous model shortcomings