Information Management Summative Test (MIDTERM)

What is a data model?

• A set of rules for constructing a database

• The visual plan for building a database

• A graphical system used to represent data relationships

• All of the above

Which of the following is NOT a component of a data model?

• Structural part

• Manipulative part

• Integrity rules

• Set of Operations

What is the process of hiding irrelevant internal details from users in a database system called?

• Data modeling

• Data manipulation

• Data abstraction

• Normalization

What are the three major components of the Relational Model?

• Entities, Attributes, Relationships

• Classes, Objects, Methods

• Relations, Attributes, Domains

• Tables, Rows, Columns

What is the highest level of data abstraction, which shows only a part of the actual database to users?

• Physical Level

• Logical Level

• View Level

• Internal Schema

What is an "entity" in the context of data modeling?

• A set of characteristics representing an object

• The association between two objects

• A real-time object about which data is collected and stored

• A restriction placed on data

Which symbol is used to represent a relationship between two entities?

• Rectangle

• Ellipse

• Diamond

• Line

In a relational database, how are data relationships represented?

• By using diamond symbols

• By common values in related tables

• By tree-like structures

• By creating a separate table for each relationship

What type of relationship exists when one record in table A can be linked with many records in table B, but one row in table B is linked to only one row in table A?

• One-to-one

• One-to-many

• Many-to-many

• Many-to-one

What is a "constraint" in a database?

• A visual representation of a system

• A collection of rules to ensure data integrity

• The process of building a working model of a database

• A representation of a table with rows and columns