DBC CHAPTER 2 - REVISION

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

• To manage hardware resources

• To serve as a communication tool

• To store data permanently

• To create user interfaces

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

• Relationship

• Function

• Attribute

• Entity

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

• None of the above

• Many-to-many (M:N)

• One-to-many (1:M)

• One-to-one (1:1)

What is a business rule?

• A type of data model

• A description of a policy within an organization

• A method for data storage

• A programming language

What does the conceptual model provide?

• A physical representation of data

• A global view of the entire database

• A detailed view of the database

• A user interface design

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

• Conceptual Model

• Internal Model

• External Model

• Logical Model

What is the purpose of mapping in data models?

• To enforce security measures

• To visualize data

• To create new data

• To translate elements between different levels

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

• An attribute's data type

• A restriction placed on data

• A relationship type

• An entity's name

What does the internal model represent?

• The physical storage of data

• The conceptual design process

• The database as seen by the DBMS

• The end user's view of data

What is the significance of business rules in database design?

• They help in data visualization

• They standardize the company’s view of data

• They are used for data storage

• They define programming languages