Question 1

In an entity-relationship (E-R)diagram,one-to-many relationships between entities are drawn as ____.

Accepted Answer

One-to-many relationships between entities are represented by drawing a line from the one-side entity to the many-side entity with an arrow pointing towards the many-side entity.

Question 2

____ can occur when there is a column in a table that is dependent on only a portion of the primary key.

Accepted Answer

Update anomalies can occur when a column in a table is dependent on only a portion of the primary key, leading to inconsistencies and errors when updating or deleting records.

Question 3

A relation is in ____ if it does not contain any repeating groups.

Accepted Answer

First normal form (1NF) requires that all attributes in a relation be atomic, meaning that they cannot be further divided into smaller components. This eliminates repeating groups in a relation, making A the correct answer. Second normal form (2NF) requires that a relation be in 1NF and also that all non-key attributes be dependent on the entire primary key, not just part of it. Third normal form (3NF) requires that a relation be in 2NF and also that there be no transitive dependencies between non-key attributes. Boyce-Codd normal form (BCNF) is a stricter version of 3NF that requires that every determinant be a candidate key.

Question 4

A ____ column is a column that is not part of the primary key.

Accepted Answer

A nonkey column is any column in a table that is not part of the primary key.

Question 5

When you write a column in the format CUSTOMER.REP_NUM,you say that you ____________________ the column name.

Accepted Answer

The answer of When you write a column in the...

Question 6

____ is the formal term for combining two or more columns to form a primary key.

Accepted Answer

Concatenation is the process of joining two or more columns or fields to form a single unique column or field. It is commonly used in database management systems to create a primary key, which is a unique identifier for each row in a table.

Question 7

When you combine a column name with a table name,you are said to ____________________ the column name.

Accepted Answer

The answer of When you combine a column name with...

Question 8

A table's design should be as simple as possible;you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n)____________________ group)in an individual location in the table.

Accepted Answer

The answer of A table's design should be as simple...

Question 9

In an entity-relationship (E-R)diagram,____ are used to represent an entity.

Accepted Answer

Rectangles are used to represent entities in an entity-relationship (E-R) diagram.

Question 10

A(n)____________________ is another name for a record or a row.

Accepted Answer

The answer of A(n)____________________ is another name for a record...

Question 11

____ is one of the categories of update anomalies.

Accepted Answer

Inconsistent data is one of the categories of update anomalies, which occurs when changes made to one part of the database result in inconsistencies in other parts of the database. Functional dependence and functional splitting are concepts related to database normalization and are not categories of update anomalies. Qualification is not a known category of update anomalies.

Question 12

Which of the following is the primary key of the ORDER_LINE (ORDER_NUM,ITEM_NUM,NUM_ORDERED,QUOTED_PRICE)table?

Accepted Answer

The primary key of a table is a unique identifier for each record. In the ORDER_LINE table, both ORDER_NUM and ITEM_NUM together uniquely identify each record, as a single order can have multiple items.

Question 13

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

Accepted Answer

The answer of In a relation,the ____________________ of the rows...

Question 14

A relational database is a collection of ____________________.

Accepted Answer

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

Question 15

Any column (or collection of columns)that determines another column is called a(n)____.

Accepted Answer

A determinant is a column or a collection of columns that determines another column. A primary key is a special type of determinant that uniquely identifies each row in a table. Nonkey columns are columns that do not participate in any dependencies. Dependencies refer to the relationships between columns in a table.

Question 16

A(n)____________________ is the association between entities.

Accepted Answer

The answer of A(n)____________________ is the association between entities....

Question 17

A relationship is an association between ____________________.

Accepted Answer

The answer of A relationship is an association between ____________________....

Question 18

____ is the duplication of data.

Accepted Answer

Redundancy refers to the duplication of data in a database, which can lead to inefficiencies and data inconsistencies.

Question 19

In this text,Boyce-Codd normal form is the same as ____.

Accepted Answer

Boyce-Codd normal form is a higher level of normalization than third normal form, so it cannot be the same as first or second normal form. It specifically deals with functional dependencies and the elimination of anomalies, making D the correct choice.

Question 20

A(n)____________________ is a person,place,thing,or event for which you want to store and process data.

Accepted Answer

The answer of A(n)____________________ is a person,place,thing,or event for which...

Quiz 2: Database Design Fundamentals

In an entity-relationship (E-R) diagram,one-to-many relationships between entities are drawn as ____.