Cuestionario: Mastering Relational Database Design — 9 preguntas

1. What is the relational database model primarily characterized by?

A. A framework that uses object-oriented programming to manage data.

B. A model that stores data exclusively in flat files without relationships.

C. A system that organizes data into interconnected tables using keys and relationships.

D. A method that emphasizes data redundancy to improve read performance.

Answer: (C)

Explicación

The correct answer is the first option because the relational database model structures data into tables (relations) that are interconnected through primary and foreign keys, enabling complex queries and maintaining data integrity. The other options describe different data storage or management approaches that do not define the relational model.

2. What is the primary purpose of a primary key in a relational database table?

A. To establish relationships between tables.

B. To uniquely identify each record within a table.

C. To store foreign data from another table.

D. To improve the speed of data insertion.

Answer: (B)

Explicación

A primary key uniquely identifies each record in a table, ensuring entity integrity. While it can be used to establish relationships, its main purpose is to guarantee each row is unique.

3. In the context of relational databases, what is the primary key in the 'Customers' table typically called?

A. OrderNumber

B. CustomerID

C. CustomerName

D. EmailAddress

Answer: (B)

Explicación

The primary key in the 'Customers' table is typically called 'CustomerID', as it uniquely identifies each customer record. The other options, such as 'OrderNumber', 'CustomerName', and 'EmailAddress', are not designated as primary keys in the given example, and 'CustomerID' is explicitly mentioned as an example of a primary key.

4. Which relationship type involves multiple records in one table related to multiple records in another table?

A. One-to-One

B. One-to-Many

C. Many-to-Many

D. Dependent relationship

Answer: (C)

Explicación

Many-to-Many relationships involve multiple records in one table relating to multiple records in another, typically implemented via junction tables.

5. What is the primary role of relationship types in a relational database?

A. To define how tables are connected and related to each other

B. To store data in a structured format within tables

C. To enforce data integrity constraints on individual columns

D. To perform calculations and aggregations on data

Answer: (A)

Explicación

The primary role of relationship types in a relational database is to define how tables are connected and related to each other. They specify the nature of the association between entities, such as one-to-one, one-to-many, or many-to-many, which is essential for maintaining data integrity and enabling complex queries across related data.

6. Who is credited with formalizing the relational model of databases in 1970?

A. Edgar F. Codd

B. Michael Stonebraker

C. Charles Bachman

D. Jim Gray

Answer: (A)

Explicación

Edgar F. Codd introduced the relational model for databases in 1970, revolutionizing how data is structured and queried.

7. What does normalization in database design primarily aim to achieve?

A. Maximize data redundancy for faster reads.

B. Organize data to reduce redundancy and dependency.

C. Introduce redundancy to enhance data security.

D. Speed up data insertion at the expense of structure.

Answer: (B)

Explicación

Normalization aims to organize data to minimize redundancy and dependency, improving data integrity and design clarity.

8. Which SQL operation is primarily used to combine data from multiple tables based on related columns?

A. SELECT

B. JOIN

C. INSERT

D. UPDATE

Answer: (B)

Explicación

JOIN operations combine rows from multiple tables based on related columns, enabling complex queries across tables.

9. Why might a database designer choose to denormalize a database?

A. To reduce data redundancy.

B. To improve read performance by introducing redundancy.

C. To enforce stricter data integrity.

D. To make normalization process easier.

Answer: (B)

Explicación

Denormalization introduces redundancy deliberately to improve read performance, often used in data warehousing, at the cost of increased redundancy.