Database Management Test 3

Front 1

Independent entities have ___ in an E-R diagram.

Back 1

square corners

Front 2

A table is in fourth normal form when it is in third normal form and there is no ___.

Back 2

multivalued dependencies

Front 3

A table is in first normal form if it does not contain ___.

Back 3

repeating groups

Front 4

If a many-to-many-to-many relationship is created when it is not appropriate to do so, the conversion to ___ normal form will correct the problem.

Back 4

fourth

Front 5

Partial dependencies are dependencies on only a portion of the ___ key.

Back 5

primary

Front 6

Potential problems in the design of a relational database are known as ___.

Back 6

update anomalies

Front 7

___ contains a repeating group.

Back 7

Orders (OrderNum, OrderDate, (PartNum, NumOrdered))

Front 8

After the information-level design is completed, the ___ is the next step.

Back 8

physical-level design

Front 9

An alternate key is a ___.

Back 9

column that could be a primary key but was not chosen

Front 10

An alternative to the primary key of a table is listed with the ___ abbreviation in DBDL.

Back 10

AK

Front 11

A(n) ___ is a system-generated primary key that is usually hidden from users.

Back 11

surrogate key

Front 12

A column is a nonkey column if it is ___.

Back 12

not a part of the primary key

Front 13

When implementing the physical-level design, you must ensure that it is possible to retrieve data rapidly on the basis of a value of any ___

Back 13

secondary.

Front 14

Second normal form can be defined as a table that is in first normal form but that contains no ___.

Back 14

partial dependencies

Front 15

When designing a database, you might find it helpful to design a(n) ___ to obtain required information from users.

Back 15

survey form

Front 16

Convert the following table to first normal form:

Branch (BranchNum, BranchName, BookCode, Title, CopyNum, Quality, Price))

Back 16

Branch (BranchNum, BranchName, BookCode, Title, CopyNum, Quality, Price)

Front 17

A(n) ___ is a primary key that consists of a column that uniquely identifies an entity, such as a person’s Social Security number.

Back 17

natural key

Front 18

The definition for ___ also defines a candidate key.

Back 18

primary key

Front 19

From all the ___ keys, one is chosen to be the primary key.

Back 19

candidate

Front 20

The conversion of an unnormalized table to first normal form requires the removal of ___.

Back 20

repeating groups

Front 21

The crucial issue in making the determination between a single many-to-many-to-many relationship and two (or three) many-to-many relationships is the ___.

Back 21

independence

Front 22

In the standard E-R diagrams, relationships are drawn as ___, with lines connecting the entities involved in relationships.

Back 22

diamonds

Front 23

If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key, the other choices are referred to as ___.

Back 23

alternate keys

Front 24

A relationship that is necessary for identification is called a(n) ___.

Back 24

identifying relationship

Front 25

If each employee works in a single department and each department has only one employee, the relationship between employees and departments is ___.

Back 25

one-to-one