Final-

Jul 11th, 2023

4.7 (114 reviews)

32 test answers

question

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

answer

True

question

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

answer

True

question

A primary key always comprises a single column

answer

False

question

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

answer

True

question

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

answer

Database design

question

A ____ is the association between entities.

answer

Relationship

question

A(n) ____ is a property of an entity.

answer

FieldAttributeColumnALL OF THE ABOVE

question

In a relational database each ____ should be unique.

answer

RowRecordTupleALL OF THE ABOVE

question

There is a commonly excepted shorthand representation to show the structure of a relational database; after the name of the table, all the columns in the table are listed within a set of ____.

answer

Parentheses

question

A field is another term for a(n) ____.

answer

Column

question

A record is another term for a(n) ____.

answer

Row

question

Which of the following symbols is used to qualify column names?

answer

Period (.)

question

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

answer

ORDER_NUM and ITEM_NUMThe terms are underlined ^^^

question

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

answer

First normal form

question

____ is the duplication of data.

answer

Redundancy

question

____ is one of the categories of update anomalies.

answer

Inconsistent data

question

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

answer

Nonkey

question

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

answer

Update anomalies

question

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

answer

Determinant

question

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

answer

Third normal form

question

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

answer

Rectangles

question

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

answer

Lines

question

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

answer

Entity

question

A(n) ___ is the association between entities.

answer

Relationship

question

A relational database is a collection of ___.

answer

Tables

question

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

answer

Order

question

A ___ is another name for a record or a row.

answer

Tuple

question

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

answer

Qualify

question

In a relational database, column B is ___ on another column A, if at any point in time a value for A determines a single value for B.

answer

Functionally dependent

question

The ___ Key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.

answer

Primary

question

A relation is in ___ normal form if it does not contain any repeating groups.

answer

First

question

A(n) ___ column is a column that is not part of the primary key.

answer

Nonkey

1 of 32

question

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

answer

True

question

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

answer

True

question

A primary key always comprises a single column

answer

False

question

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

answer

True

Don’t waste time

You can get a custom paper by one of our expert writers.

Get your custom essay

Helping students since 2015

question

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

answer

Database design

question

A ____ is the association between entities.

answer

Relationship

question

A(n) ____ is a property of an entity.

answer

FieldAttributeColumnALL OF THE ABOVE

question

In a relational database each ____ should be unique.

answer

RowRecordTupleALL OF THE ABOVE

question

There is a commonly excepted shorthand representation to show the structure of a relational database; after the name of the table, all the columns in the table are listed within a set of ____.

answer

Parentheses

question

A field is another term for a(n) ____.

answer

Column

question

A record is another term for a(n) ____.

answer

Row

question

Which of the following symbols is used to qualify column names?

answer

Period (.)

question

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

answer

ORDER_NUM and ITEM_NUMThe terms are underlined ^^^

question

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

answer

First normal form

question

____ is the duplication of data.

answer

Redundancy

question

____ is one of the categories of update anomalies.

answer

Inconsistent data

question

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

answer

Nonkey

question

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

answer

Update anomalies

question

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

answer

Determinant

question

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

answer

Third normal form

question

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

answer

Rectangles

question

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

answer

Lines

question

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

answer

Entity

question

A(n) ___ is the association between entities.

answer

Relationship

question

A relational database is a collection of ___.

answer

Tables

question

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

answer

Order

question

A ___ is another name for a record or a row.

answer

Tuple

question

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

answer

Qualify

question

In a relational database, column B is ___ on another column A, if at any point in time a value for A determines a single value for B.

answer

Functionally dependent

question

The ___ Key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.

answer

Primary

question

A relation is in ___ normal form if it does not contain any repeating groups.

answer

First

question

A(n) ___ column is a column that is not part of the primary key.

answer

Nonkey

Final-

Haven't found what you need?