Question 1

The entity relationship diagram (ERD) represents the ____database as viewed by the end user.

Accepted Answer

conceptual

Question 2

The _____notation of entity-relationship modelling can be used for both conceptual and implementation modelling.

Accepted Answer

UML

Question 3

A(n) ____ is the set of possible values for a given attribute.

Accepted Answer

domain

Question 4

Ideally, an entity identifier is composed of ___ attributes.

Accepted Answer

one

Question 5

A ___ attribute can be further subdivided to yield additional attributes.

Accepted Answer

composite

Question 6

A ___ attribute is one that cannot be subdivided.

Accepted Answer

simple

Question 7

The conceptual model can handle ____ relationships and multivalued attributes.

Accepted Answer

M:N

Question 8

A derived attribute is indicated in the Chen model by a ____ that connects the attribute and an entity.

Accepted Answer

dashed line

Question 9

The decision to store ____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.

Accepted Answer

derived

Question 10

A relationship is an association between _____.

Accepted Answer

entities

Question 11

_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

Accepted Answer

Cardinality

Question 12

In the ERD, cardinality is indicated using the ____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities.

Accepted Answer

(min, max)

Question 13

When the specific cardinalities are not included on the diagram in Crow\'s Foot notation, cardinality is implied by the use of ____.

Accepted Answer

symbols

Question 14

Knowing the minimum and maximum number of ____ occurrences is very helpful at the application software level.

Accepted Answer

entity

Question 15

An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.

Accepted Answer

existence

Question 16

If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n) ____ entity.

Accepted Answer

strong

Question 17

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Accepted Answer

weak

Question 18

The existence of a(n) ____entity indicates that its minimum cardinality is zero.

Accepted Answer

optional

Question 19

The Crow\'s foot symbol with two vertical parallel lines indicates ____ cardinality.

Accepted Answer

(1,1)

Question 20

A ____ relationship exists when an association is maintained within a single entity.

Accepted Answer

unary

Question 21

A _____ relationship exists when three entities are associated.

Accepted Answer

ternary

Question 22

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship.

Accepted Answer

recursive

Question 23

To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent ____ relationships whenever possible.

Accepted Answer

binary

Question 24

The entity relationship model uses the associative entity to represent a(n) ____ relationship between two or more entities.

Accepted Answer

M:N

Question 25

When using the Crow\'s Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity.

Accepted Answer

solid

Question 26

If Tiny College has some departments that are classified as \"research only\" and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity.

Accepted Answer

optional to

Question 27

In organizations that generate large number of transactions, ____ are often a top priority in database design.

Accepted Answer

high processing speeds

Question 28

Complex _____ requirements may dictate data transformations, and they may not expand the number of entities and attributes within the design.

Accepted Answer

information

Question 29

Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages are as high as you need to ...

Accepted Answer

Three

Question 30

From a structural point of view, 3NF is better than_____.

Accepted Answer

2NF

Question 31

1NF, 2NF, and 3NF are _____.

Accepted Answer

normalization stages

Question 32

From a structural point of view, 2NF is better than _____.

Accepted Answer

1NF

Question 33

____ yields better performance.

Accepted Answer

Denormalization

Question 34

An attribute that is part of a key is known as a(n) _____ attribute.

Accepted Answer

prime

Question 35

A table that displays data redundancies yields ______.

Accepted Answer

anomalies

Question 36

Data redundancy produces ____.

Accepted Answer

data integrity

Question 37

Some very specialized applications may require normalization beyond the ______.

Accepted Answer

4NF

Question 38

Of the following normal forms, _____ is mostly of theoretical interest.

Accepted Answer

DKNF

Question 39

A(n) ______ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.

Accepted Answer

transitive dependency

Question 40

Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Accepted Answer

determines

Question 41

A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.

Accepted Answer

repeating group

Question 42

A relational table must not contain a(n) ______.

Accepted Answer

repeating group

Question 43

Dependencies based on only a part of a composite primary key are known as ______ dependencies.

Accepted Answer

partial

Question 44

In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.

Accepted Answer

dependency

Question 45

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in ______.

Accepted Answer

1NF

Question 46

A table that is in 1NF and includes no partial dependencies is said to be in _____.

Accepted Answer

2NF

Question 47

If you have three different transitive dependencies, _____different determinant(s) exist.

Accepted Answer

three

Question 48

Before converting a table into 3NF, it is imperative that the table already be in _____.

Accepted Answer

2NF

Question 49

A(n) _____ exists when there are functional dependencies such that XY is functionally dependent on WZ, X is functionally dependent on W, and XY is the primary key.

Accepted Answer

partial dependency

Question 50

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have ______ based on this composite candidate key even when the primary key changes...

Accepted Answer

partial dependencies

Question 51

A table that is in 2NF and contains no transitive dependencies is said to be in _____.

Accepted Answer

3NF

Question 52

Improving _____ leads to more flexible queries.

Accepted Answer

atomicity

Question 53

An atomic attribute ______.

Accepted Answer

cannot be further subdivided

Question 54

The most likely data type for a surrogate key is _____.

Accepted Answer

numeric

Question 55

Granularity refers to ______.

Accepted Answer

the level of detail represented by the values in a table\'s row

Question 56

From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices.

Accepted Answer

derived

Question 57

In a real-world environment, we must strike a balance between design integrity and _____.

Accepted Answer

flexibility

Question 58

For most business transactional databases, we should normalize relations into ______.

Accepted Answer

3NF

Question 59

To generate a surrogate key, Microsoft Access uses a(n) _____ data type.

Accepted Answer

AutoNumber

Question 60

A table where every determinant is a candidate key is said to be in _____.

Accepted Answer

BCNF

Question 61

In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other.

Accepted Answer

multivalued dependency

Question 62

BCNF can be violated only if the table contains more than one _____ key.

Accepted Answer

candidate

Question 63

When a table contains only one candidate key, ______ are considered to be equivalent.

Accepted Answer

the 3NF and the BCNF

Question 64

Most designers consider the BCNF as a special case of the _____.

Accepted Answer

3NF

Combo with "MIS 342–Midtern–Chapter 4" and 1 other – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards