Question 1

Columns are sometimes called tuples.

Accepted Answer

Columns are not called tuples in databases. Tuples refer to rows or records in a database table.

Question 2

You can determine functional dependence by viewing sample data.

Accepted Answer

Functional dependence between two variables means that the value of one variable is determined by the value of another. While sample data can suggest a relationship or correlation, it cannot definitively prove functional dependence without a thorough analysis or mathematical proof, as exceptions or unseen variables may not be represented in the sample.

Question 3

In a relation, the order of the rows and columns is immaterial.

Accepted Answer

In a relation, the order of the rows and columns does not affect the content of the relation. The rows can be re-ordered or the columns can be swapped without changing the meaning of the relation.

Question 4

You can indicate a table's primary key by underlining the column or collection of columns that comprises the primary key for each table in the database.

Accepted Answer

This is a commonly accepted convention for indicating the primary key in a database table.

Question 5

A relation is essentially a three-dimensional table.

Accepted Answer

A relation is a two-dimensional table consisting of rows and columns, representing a set of related data.

Question 6

The same column name can appear in two different tables in a relational database.

Accepted Answer

This is true. It is possible for two different tables in a relational database to have columns with the same name. However, it is generally considered good practice to use unique column names to avoid confusion and make querying the data easier.

Question 7

A tabular database is a collection of tables.

Accepted Answer

The answer of A tabular database is a collection of...

Question 8

The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class, you can determine the pay rate.

Accepted Answer

The statement explicitly states that the pay class determines the pay rate, therefore it is true.

Question 9

In a relational database, each entity has its own table.

Accepted Answer

In a relational database, each entity is represented by a table with its own set of columns and rows. This allows for efficient storage and retrieval of data, as well as the ability to establish relationships between entities by using keys and foreign keys.

Question 10

Because there is a one-to-many relationship between sales reps and customers in the Premiere Products database, one sales rep can be associated with zero, one, or more customers.

Accepted Answer

This statement is true. In a one-to-many relationship, one entity (in this case, the sales rep) can be associated with zero or more instances of the other entity (in this case, customers).

Question 11

Each column in a table of a relational database should have a distinct name.

Accepted Answer

Each column in a table of a relational database must have a unique name to identify its contents and differentiate it from other columns. This is a fundamental principle of database design and helps ensure proper organization and management of data.

Question 12

A relation is a characteristic or property of an entity.

Accepted Answer

The answer of A relation is a characteristic or property...

Question 13

In the one-to-many type of relationship, the word many always indicates a large number.

Accepted Answer

The word "many" in a one-to-many relationship simply means that there can be multiple related records on the "many" side for each record on the "one" side. It does not necessarily indicate a large number.

Question 14

A matrix is the association between entities.

Accepted Answer

The answer of A matrix is the association between entities....

Question 15

A primary key always comprises a single column.

Accepted Answer

A primary key can comprise one or multiple columns, known as a composite key.

Question 16

The process of determining the particular tables and columns that will comprise a database is known as database design.

Accepted Answer

Database design involves identifying the tables that will store the data and the columns within those tables that will hold specific types of information.

Question 17

In a relation, all values in a column are values of the same attribute.

Accepted Answer

This statement is true for relations in a relational database. Each attribute in a relation corresponds to a column in the table and the values in that column represent the values of that attribute for each tuple (or row) in the table.

Question 18

In a relational database, relationships are implemented by having common columns in two or more tables.

Accepted Answer

Relationships in a relational database are implemented through common columns, also known as keys, in two or more tables. These columns allow data to be linked between tables and enable the database to maintain data integrity and consistency.

Question 19

The concept of functional dependence is trivial to understanding database concepts.

Accepted Answer

The answer of The concept of functional dependence is trivial...

Question 20

A secondary key is the unique identifier for a table.

Accepted Answer

A secondary key is not the unique identifier for a table. A primary key is the unique identifier for a table, while a secondary key is another attribute or combination of attributes that can be used to identify and retrieve individual records within a table.

Quiz 2: Database Design Fundamentals