Database Management Midterm Exam Part 1

What does data integrity primarily refer to?

• Completeness, accuracy, and reliability

• Speed, efficiency, and scalability

• Accessibility, flexibility, and security

In data modeling, what does the Entity-Relationship Model (ERM) focus on?

• Describing real-world entities and relationships between them

• Optimizing database performance and storage

• Implementing complex algorithms for data analysis

What is the purpose of a primary key constraint in a database?

• To establish links between tables

• To ensure each record is uniquely identified

• To prevent null values in key attributes

Which constraint ensures that if a foreign key exists in one table, the corresponding primary key exists in another table?

• Referential Integrity Constraint

• Entity Integrity Constraint

• Foreign Key Constraint

What does an Entity-Relationship Diagram (ERD) primarily depict?

• The physical layout of database tables

• The logical structure of data and relationships between entities

• The flow of data within a system

What do the components of an ER Diagram include?

• Entities, attributes, and relationships

• Tables, rows, and columns

• Functions, procedures, and triggers

In a One-to-Many relationship, what is the cardinality?

• One entity can be related to only one instance of another entity

• One entity can be related to multiple instances of another entity

• Multiple instances of one entity can be related to multiple instances of another entity

What ensures that each row in a table is uniquely identified and that no key attributes are null?

• Foreign Key Constraint

• Entity Integrity Constraint

• Primary Key Constraint

What is the role of data constraints in a database?

• Ensuring data security

• Enhancing data visualization

• Ensuring data accuracy, consistency, and reliability

Which constraint uniquely identifies each record in a table?

• Referential Integrity Constraint

• Foreign Key Constraint

• Primary Key Constraint