Deck 2: Database Design Fundamentals

Question 1

The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class,you can determine the pay rate.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

You can determine functional dependence by viewing sample data.

Answer 3

False

Question 4

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

Question 5

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

Question 6

In a relation,all values in a column are values of the same attribute.

Question 7

A relation is essentially a three-dimensional table.

Question 8

A tabular database is a collection of tables.

Question 9

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

Question 10

A primary key always comprises a single column.

Question 11

A secondary key is the unique identifier for a table.

Question 12

A relation is a characteristic or property of an entity.

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

Because there is a one-to-many relationship between sales reps and customers in the TAL Distributors database,one sales rep can be associated with zero,one,or more customers.

Question 18

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

Question 19

Columns are sometimes called tuples.

Question 20

A matrix is the association between entities.

Question 21

A determinant is any column (or collection of columns)that determines another table.

Question 22

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

Question 23

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

Question 24

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

Question 25

Normalization is done before creating the database design.

Question 26

A programmer interviews users,examines existing and proposed documents,and examines organizational policies to determine exactly the type of data needs the database must support.

Question 27

A(n)____ is the association between entities.

A)qualification
B)​functional dependency
C)relationship
D)​join

Question 28

When you convert an unnormalized table to a table in first normal form,the primary key of the table in first normal form is usually the concatenation of at least two columns.

Question 29

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

Question 30

A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of the primary key.

Question 31

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

A)period (.)
B)​comma (,)
C)backslash (/)
D)​pound sign (#)

Question 32

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

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

Question 33

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 ____.

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

Question 34

Qualification is an update anomaly.

Question 35

In a relational database each ____ should be unique.

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

Question 36

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

A)tuple
B)​row
C)column
D)​entity

Question 37

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

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

Question 38

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

A)field
B)​attribute
C)column
D)All of the above​

Question 39

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

Question 40

At TAL Distributors,there is a ____ relationship between sales reps and customers.

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

Question 41

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

A)ovals
B)​equal signs
C)lines
D)​circles

Question 42

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

A)Qualification
B)​Update anomalies
C)Function splitting
D)​Determination

Question 43

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

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

Question 44

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

A)determinant
B)​candidate
C)functional
D)​nonkey

Question 45

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

Question 46

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

A)Qualification
B)​Joining
C)Normalization
D)​Concatenation

Question 47

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

Question 48

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.

Question 49

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

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

Question 50

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

Question 51

____ is one of the categories of update anomalies.

A)Functional dependence
B)​Functional splitting
C)Inconsistent data
D)​Qualification

Question 52

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

A)ORDER_NUM
B)​ITEM_NUM
C) QUOTED_PRICE
D)​ORDER_NUM and ITEM_NUM

Question 53

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

Question 54

A relational database is a collection of ____________________.

Question 55

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

A)nonkey column
B)​primary key
C)dependency
D)​determinant

Question 56

A(n)____________________ is the association between entities.

Question 57

A relationship is an association between ____________________.

Question 58

____ is the duplication of data.

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

Question 59

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

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

Question 60

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

Question 61

In one style of entity-relationship (E-R)diagrams,a crow's foot is used to represent the ____________________ side of a relationship.

Question 62

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

Question 63

In one style of entity-relationship (E-R)diagrams,diamonds are used to describe ____________________.

Question 64

Define a relation.

Question 65

______________________________ is another name given to third normal form in this text.

Question 66

How does a DBMS that follows the relational model handle entities,attributes of entities,and relationships between entities?

Question 67

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

Question 68

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

Question 69

If the primary key of a table contains only a single column,the table is automatically in ____________________ normal form.

Question 70

The four categories of update anomalies are additions,deletions,inconsistent data,and ____________________.

Question 71

What is the precise definition of a primary key?

Question 72

If B is functionally dependent on A,you also can say that A functionally ____________________ B.

Question 73

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

Question 74

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.

Question 75

In one style of entity-relationship (E-R)diagrams,the letter n is used to represent the ____________________ side of a relationship.