Question 1

Match between columns
                        Premises: Field that uniquely identifies a given row.

Accepted Answer

The Answer of primary key and relationship and entity and is...

Question 2

The attributes of an entity become the ____________________ in a table.

Accepted Answer

The answer of The attributes of an entity become the...

Question 3

Modified Multiple Choice _____ is(are) used in the shorthand representation of table.

Accepted Answer

A)  Underlining ____ 
B)  Slashes / / 
C)  Parentheses ( ) 
D)  Arrow ® 
A)  Underlining ____ 
B)  Slashes / / 
C)  Parentheses ( ) 
D)  Arrow ®

Question 4

If a client can be offered many courses and each course is offered to many clients, there is a many-to-many relationship between clients and courses.

Accepted Answer

A) True 
 B)False

Question 5

The attributes of an entity become the _____ in the table.

Accepted Answer

A)  records 
B)  columns 
C)  rows 
D)  tuples 
A)  records 
B)  columns 
C)  rows 
D)  tuples

Question 6

The goal of normalization is to take a table or collection of tables and produce a new collection of tables that represents the same information but is free of problems.

Accepted Answer

A) True 
 B)False

Question 7

Critical Thinking Questions Case 11-1 One of the employees at Regional Books is attempting to use the normalization process in the design of the database. She has created the following unnormalized table: Book ( ISBN , Title, PublisherCode, PublisherName, (AuthorNum, AuthorLast, AuthorFirst)) What will be the primary key of the table in first normal form?

Accepted Answer

The primary key will

Question 8

When you combine a field name with a table name, you say that you _____ the field names.

Accepted Answer

A)  concatenate 
B)  combine 
C)  normalize 
D)  qualify 
A)  concatenate 
B)  combine 
C)  normalize 
D)  qualify

Question 9

In designing a database, you must first identify the fields in the database and then the tables.

Accepted Answer

A) True 
 B)False

Question 10

When creating a database, a(n) _____ is represented as a table.

Accepted Answer

A)  entity 
B)  attribute 
C)  determinant 
D)  tuple 
A)  entity 
B)  attribute 
C)  determinant 
D)  tuple

Question 11

Match between columns
                        Premises: A field or collection of fields that determines another field.

Accepted Answer

The Answer of entity and relationship and determinant and nonkey is...

Question 12

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

Accepted Answer

A)  record 
B)  tuple 
C)  entity 
D)  attribute 
A)  record 
B)  tuple 
C)  entity 
D)  attribute

Question 13

In a relation, the order of rows is fixed; rows must be in ascending order by primary key.

Accepted Answer

A) True 
 B)False

Question 14

If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to determine the second field. In addition, the second field is said to be ____________________ dependent on the first.

Accepted Answer

The answer of If you know that whenever you are...

Question 15

When you combine a field name with a table name, you say that you ____________________ the field names.

Accepted Answer

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

Question 16

The normalization process involves converting tables into various types of _____.

Accepted Answer

A)  tuples 
B)  relations 
C)  normal forms 
D)  diagrams 
A)  tuples 
B)  relations 
C)  normal forms 
D)  diagrams

Question 17

Modified Multiple Choice The most common normal forms are _____.

Accepted Answer

A)  1NF 
B)  2NF 
C)  3NF 
D)  4NF 
A)  1NF 
B)  2NF 
C)  3NF 
D)  4NF

Question 18

If one employee is assigned to a project and each project has only one employee working on it, there is a(n) _____ relationship between employees and projects.

Accepted Answer

A)  uni-to-uni 
B)  only-to-one 
C)  one-to-one 
D)  one-to-many 
A)  uni-to-uni 
B)  only-to-one 
C)  one-to-one 
D)  one-to-many

Question 19

The formal term for a table is ____________________.

Accepted Answer

The answer of The formal term for a table is...

Question 20

A dependent key is a field or combination of fields on which all fields in the table are functionally dependent.

Accepted Answer

A) True 
 B)False

The attributes of an entity become the ____________________ in a table.

Modified Multiple Choice _____ is(are) used in the shorthand representation of table.

If a client can be offered many courses and each course is offered to many clients, there is a many-to-many relationship between clients and courses.

The attributes of an entity become the _____ in the table.

The goal of normalization is to take a table or collection of tables and produce a new collection of tables that represents the same information but is free of problems.

When you combine a field name with a table name, you say that you _____ the field names.

In designing a database, you must first identify the fields in the database and then the tables.

When creating a database, a(n) _____ is represented as a table.

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

In a relation, the order of rows is fixed; rows must be in ascending order by primary key.

If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to determine the second field. In addition, the second field is said to be ____________________ dependent on the first.

When you combine a field name with a table name, you say that you ____________________ the field names.

The normalization process involves converting tables into various types of _____.

Modified Multiple Choice The most common normal forms are _____.

If one employee is assigned to a project and each project has only one employee working on it, there is a(n) _____ relationship between employees and projects.

The formal term for a table is ____________________.

A dependent key is a field or combination of fields on which all fields in the table are functionally dependent.

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Filters

Exam 12: Database Design

The attributes of an entity become the ____________________ in a table.

Modified Multiple Choice _____ is(are) used in the shorthand representation of table.

If a client can be offered many courses and each course is offered to many clients, there is a many-to-many relationship between clients and courses.

The attributes of an entity become the _____ in the table.

The goal of normalization is to take a table or collection of tables and produce a new collection of tables that represents the same information but is free of problems.

When you combine a field name with a table name, you say that you _____ the field names.

In designing a database, you must first identify the fields in the database and then the tables.

When creating a database, a(n) _____ is represented as a table.

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

In a relation, the order of rows is fixed; rows must be in ascending order by primary key.

If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to determine the second field. In addition, the second field is said to be ____________________ dependent on the first.

When you combine a field name with a table name, you say that you ____________________ the field names.

The normalization process involves converting tables into various types of _____.

Modified Multiple Choice The most common normal forms are _____.

If one employee is assigned to a project and each project has only one employee working on it, there is a(n) _____ relationship between employees and projects.

The formal term for a table is ____________________.

A dependent key is a field or combination of fields on which all fields in the table are functionally dependent.

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Filters