WorksheetsCS10337 - Lecture # 6
Total questions: 10
Worksheet time: 2mins
Database design is only concerned with how fast data can be retrieved, not how accurately it represents real-world entities.
True
False
One key objective of database design is maintainability, meaning the database structure should be easy to update and extend over time.
True
False
Normalization is a process that increases data redundancy in order to improve performance.
True
False
In a normalized database, each fact should be stored only once to reduce duplication and maintain integrity.
True
False
Data modeling focuses on visually representing entities, attributes, and their relationships before the database is implemented.
True
False
Which of the following best describes the main purpose of database design?
To create as many tables as possible for flexibility
To define how data is stored, organized, and accessed in a structured and efficient way
To ensure that data can only be modified by administrators
To build reports directly from raw data
Which of the following is not one of the main objectives of database design?
Efficiency
Scalability
Randomness
Security
What is the main goal of normalization in database design?
To increase the number of tables for complex queries
To organize data to reduce redundancy and maintain integrity
To combine multiple tables into one
To simplify database security management
In database design, the process of denormalization refers to:
Splitting large tables into smaller ones
Introducing controlled redundancy for performance improvement
Removing all relationships between tables
Using unstructured data models
The primary purpose of data modeling is to:
Perform backups
Test performance optimization
Visually represent entities, attributes, and relationships before implementation
Create user interfaces
