Question 1

At Premiere Products, there is a ____ relationship between sales reps and customers.

Accepted Answer

A)  one-to-one 
B)  one-to-two 
C)  one-to-many 
D)  many-to-many 
A)  one-to-one 
B)  one-to-two 
C)  one-to-many 
D)  many-to-many C

Question 2

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

Accepted Answer

A)  first normal form 
B)  second normal form 
C)  third normal form 
D)  Boyce-Codd normal form 
A)  first normal form 
B)  second normal form 
C)  third normal form 
D)  Boyce-Codd normal form A

Question 3

Define a relation.

Accepted Answer

A relation is a two-dimensional table in which:
1. The entries in the table are single-valued; that is, each location in the table contains a single entry.
2. Each column has a distinct name (technically called the attribute name).
3. All values in a column are values of the same attribute (that is, all entries must match the column name).
4. The order of columns is immaterial.
5. Each row is distinct.
6. The order of rows is immaterial.

Question 4

In a relational database each ____ should be unique.

Accepted Answer

A)  row 
B)  record 
C)  tuple 
D)  All of the above 
A)  row 
B)  record 
C)  tuple 
D)  All of the above

Question 5

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

Accepted Answer

A)  unnormalized 
B)  first normal form 
C)  second normal form 
D)  third normal form 
A)  unnormalized 
B)  first normal form 
C)  second normal form 
D)  third normal form

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

The answer of A(n) ____________________ column is a column that...

Question 8

A matrix is the association between entities.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  row 
B)  field 
C)  attribute 
D)  property 
A)  row 
B)  field 
C)  attribute 
D)  property

Question 10

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

Accepted Answer

A)  normalization 
B)  database design 
C)  qualification 
D)  relational management 
A)  normalization 
B)  database design 
C)  qualification 
D)  relational management

Question 11

____ is the duplication of data.

Accepted Answer

A)  Repeating group 
B)  Redundancy 
C)  Replication 
D)  Anomaly 
A)  Repeating group 
B)  Redundancy 
C)  Replication 
D)  Anomaly

Question 12

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

Accepted Answer

A)  rectangles 
B)  ovals 
C)  circles 
D)  diamonds 
A)  rectangles 
B)  ovals 
C)  circles 
D)  diamonds

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

What are the six steps necessary to design a database for a set of requirements?

Accepted Answer

1. Read the requirements, identify the e

Question 16

There is a commonly accepted 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 ____.

Accepted Answer

A)  square brackets 
B)  parentheses 
C)  back slashes 
D)  curly braces 
A)  square brackets 
B)  parentheses 
C)  back slashes 
D)  curly braces

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Many organizations and institutions are moving toward using Social Security numbers as primary keys because of privacy issues.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

You can determine functional dependence by viewing sample data.

Accepted Answer

A) True 
 B)False

At Premiere Products, there is a ____ relationship between sales reps and customers.

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

Define a relation.

In a relational database each ____ should be unique.

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

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

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

A matrix is the association between entities.

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

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

____ is the duplication of data.

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

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

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

What are the six steps necessary to design a database for a set of requirements?

There is a commonly accepted 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 ____.

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

Many organizations and institutions are moving toward using Social Security numbers as primary keys because of privacy issues.

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

You can determine functional dependence by viewing sample data.

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Exam 2: Database Design Fundamentals

At Premiere Products, there is a ____ relationship between sales reps and customers.

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

Define a relation.

In a relational database each ____ should be unique.

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

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

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

A matrix is the association between entities.

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

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

____ is the duplication of data.

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

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

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

What are the six steps necessary to design a database for a set of requirements?

There is a commonly accepted 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 ____.

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

Many organizations and institutions are moving toward using Social Security numbers as primary keys because of privacy issues.

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

You can determine functional dependence by viewing sample data.

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters