WorksheetsDatabase Management Midterm Exam Part 1
Total questions: 15
Worksheet time: 8mins
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
What does an Entity-Relationship Diagram (ERD) primarily depict?
The logical structure of data and relationships between entities
The physical implementation of database tables
The flow of control within a system
What is the cardinality in a Many-to-Many relationship?
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 is the purpose of a foreign key constraint in a database?
To ensure each record is uniquely identified
To establish links between tables by referencing the primary key of another table
To prevent null values in key attributes
In a One-to-One relationship, how are entities related?
One entity can be related to only one instance of another entity, and vice versa
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
Which component of an ER Diagram describes the characteristics or properties of an entity?
Entities
Attributes
Relationships
