QUESTION 1 If a table contained both employee numbers and Social Security number

Question

QUESTION 1

If a table contained both employee numbers and Social Security numbers, both columns would be referred to as candidate keys.

True

False

4 points   

QUESTION 2

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

third normal form

Boyce-Codd normal form

second normal form

first normal form

4 points   

QUESTION 3

A(n) ____ is the association between entities.

join

qualification

relationship

functional dependency

4 points   

QUESTION 4

An unnormalized relation is a relation that may contain repeating groups.

True

False

4 points   

QUESTION 5

A relation is essentially a three-dimensional table.

True

False

4 points   

QUESTION 6

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

True

False

4 points   

QUESTION 7

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

True

False

4 points   

QUESTION 8

It is possible for the computer to generate values that are used as the primary key column.

True

False

4 points   

QUESTION 9

Qualification is an update anomaly.

True

False

4 points   

QUESTION 10

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

column

row

tuple

entity

4 points   

QUESTION 11

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

candidate

functional

nonkey

determinant

4 points   

QUESTION 12

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

circles

ovals

rectangles

diamonds

4 points   

QUESTION 13

In a relational database each ____ should be unique.

All of the above

row

tuple

record

4 points   

QUESTION 14

____ is the duplication of data.

Redundancy

Anomaly

Repeating group

Replication

4 points   

QUESTION 15

A relation is a characteristic or property of an entity.

True

False

4 points   

QUESTION 16

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

qualification

relational management

database design

normalization

4 points   

QUESTION 17

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

True

False

4 points   

QUESTION 18

A primary key always comprises a single column.

True

False

4 points   

QUESTION 19

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

period (.)

backslash (/)

comma (,)

pound sign (#)

4 points   

QUESTION 20

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

True

False

4 points   

QUESTION 21

The definition for a primary key really defines a candidate key as well.

True

False

4 points   

QUESTION 22

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

True

False

4 points   

QUESTION 23

You can determine functional dependence by viewing sample data.

True

False

4 points   

QUESTION 24

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

nonkey column

determinant

primary key

dependency

4 points   

QUESTION 25

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

True

False

a.

third normal form

b.

Boyce-Codd normal form

c.

second normal form

d.

first normal form

Explanation / Answer

1.

Statement :

If a table contained both employee numbers and Social Security numbers, both columns would be referred to as candidate keys.

Statement True.

2.

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

Option d correct.

3.

A relationship is the association between entities.

Option c correct.

4.

Statement :

An unnormalized relation is a relation that may contain repeating groups.

Statement True.

5.

Statement :

A relation is essentially a three-dimensional table.

Statement False.

6.

Statement :

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

Statement True.

7.

Statement :

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

Statement True.

8.

Statement :

It is possible for the computer to generate values that are used as the primary key column.

Statement True.

9.

Statement :

Qualification is an update anomaly.

Statement False.

10.

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

Option a correct.

11.

A nonkey column is a column that is not part of the primary key

Option c correct.

12.

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

Option c correct.

13.

In a relational database each row, record, tuple should be unique.

Option a correct.

14.

Redundancy is the duplication of data.

Option a correct.

15.

Statement :

A relation is a characteristic or property of an entity.

Statement False.

16.

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

Option c correct.

17.

Statement :

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

Statement False.

18.

Statement :

If the primary key of a table contains only asingle column.

Statement False.

19.

period (.) symbols is used to qualify column names.

Option a correct.

20.

Statement :

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

Statement True.

21.

Statement :

The definition for a primary key really defines a candidate key as well.

Statement True.

22.

Statement :

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

Statement True.

23.

Statement :

You can determine functional dependence by viewing sample data.

Statement False.

24.

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

Option b correct.

25.

Statement :

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

Statement False.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.