Question 1

data characteristics are important in the design of programs and other systems components

Accepted Answer

Data modeling may be the most important part of the systems development process because:

Question 2

entity-relationship model

Accepted Answer

The logical representation of an organization\'s data is called a(n):

Question 3

all of the above

Accepted Answer

The common types of entities are:

Question 4

two

Accepted Answer

In an E-R diagram, there are ________ business rule(s) for every relationship

Question 5

managing employees

Accepted Answer

Business policies and rules govern all of the following EXCEPT:

Question 6

all of the above

Accepted Answer

A business rule:

Question 7

Inconsistent

Accepted Answer

Which of the following is NOT a characteristic of a good business rule?

Question 8

Relates to a technical characteristic of the system

Accepted Answer

Which of the following is NOT a good characteristic of a data name?

Question 9

terms

Accepted Answer

A fact is an association between two or more:

Question 10

who can delete the data

Accepted Answer

A good data definition will describe all of the characteristics of a data object EXCEPT:

Question 11

entities

Accepted Answer

Customers, cars, and parts are examples of:

Question 12

None of the above

Accepted Answer

Which of the following is an entity type on which a strong entity depends?

Question 13

weak

Accepted Answer

An entity type whose existence depends on another entity type is called a ________ entity

Question 14

identifying relationship

Accepted Answer

A(n) ________ is the relationship between a weak entity type and its owner

Question 15

as short as possible

Accepted Answer

An entity type name should be all of the following EXCEPT:

Question 16

attribute

Accepted Answer

A property or characteristic of an entity type that is of interest to the organization is called a(n):

Question 17

required attribute

Accepted Answer

An attribute that must have a value for every entity (or relationship) instance is a(n):

Question 18

attributes

Accepted Answer

A person\'s name, birthday, and social security number are all examples of:

Question 19

required attribute

Accepted Answer

An attribute of an entity that must have a value for each entity instance is a(n):

Question 20

composite

Accepted Answer

An attribute that can be broken down into smaller parts is called a(n) ________ attribute.

Question 21

derived

Accepted Answer

An attribute that can be calculated from related attribute values is called a(n) ________ attribute.

Question 22

derived

Accepted Answer

The total quiz points for a student for an entire semester is a(n) ________ attribute.

Question 23

All of the above

Accepted Answer

Which of the following criteria should be considered when selecting an identifier?

Question 24

composite identifier

Accepted Answer

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

Question 25

associative entity

Accepted Answer

An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n):

Question 26

All of the above.

Accepted Answer

Which of the following conditions should exist if an associative entity is to be created?

Question 27

degree

Accepted Answer

The number of entity types that participate in a relationship is called the:

Question 28

unary

Accepted Answer

A relationship between the instances of a single entity type is called a(n) ________

Question 29

many-to-many

Accepted Answer

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

Question 30

cardinality constraint

Accepted Answer

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity

Question 31

ternary

Accepted Answer

A simultaneous relationship among the instances of three entity types is called a(n) ________ relationship

Question 32

mandatory one

Accepted Answer

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

Question 33

an entity instance can participate in only one of several alternative relationships

Accepted Answer

A mutually exclusive relationship is one in which:

Question 34

FALSE

Accepted Answer

Most systems developers believe that data modeling is the least important part of the systems development process.

Question 35

TRUE

Accepted Answer

Data, rather than processes, are the most complex aspects of many modern information systems.

Question 36

TRUE

Accepted Answer

The E-R model is used to construct a conceptual model.

Question 37

FALSE

Accepted Answer

In an E-R diagram, strong entities are represented by double-walled rectangles.

Question 38

TRUE

Accepted Answer

In an E-R diagram, an associative entity is represented by a rounded rectangle.

Question 39

TRUE

Accepted Answer

Data modeling is about documenting rules and policies of an organization that govern data

Question 40

TRUE

Accepted Answer

One of the roles of a database analyst is to identify and understand rules that govern data.

Question 41

FALSE

Accepted Answer

The purpose of data modeling is to document business rules about processes.

Question 42

TRUE

Accepted Answer

A business rule is a statement that defines or constrains some aspect of the business.

Question 43

FALSE

Accepted Answer

The intent of a business rule is to break down business structure

Question 44

TRUE

Accepted Answer

Enforcement of business rules can be automated through the use of software tools that can interpret the rules and enforce them.

Question 45

FALSE

Accepted Answer

When systems are automatically generated and maintained, quality is diminished.

Question 46

FALSE

Accepted Answer

A business rule is a statement of how a policy is enforced or conducted

Question 47

FALSE

Accepted Answer

The intent of a business rule is to break down business structure

Question 48

TRUE

Accepted Answer

Enforcement of business rules can be automated through the use of software tools that can interpret the rules and enforce them

Question 49

FALSE

Accepted Answer

When systems are automatically generated and maintained, quality is diminished.

Question 50

FALSE

Accepted Answer

A business rule is a statement of how a policy is enforced or conducted.

Question 51

TRUE

Accepted Answer

While business rules are not redundant, a business rule can refer to another business rule

Question 52

TRUE

Accepted Answer

A business rule should be internally consistent

Question 53

FALSE

Accepted Answer

Business rules are formulated from a collection of business ramblings

Question 54

TRUE

Accepted Answer

Data names should always relate to business characteristics

Question 55

FALSE

Accepted Answer

Data names do not have to be unique

Question 56

FALSE

Accepted Answer

An example of a term would be the following sentence: \"A student registers for a course.\"

Question 57

TRUE

Accepted Answer

A fact is an association between two or more terms.

Question 58

TRUE

Accepted Answer

A good data definition is always accompanied by diagrams, such as the entity-relationship diagram

Question 59

TRUE

Accepted Answer

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Question 60

TRUE

Accepted Answer

A single occurrence of an entity is called an entity instance.

Question 61

TRUE

Accepted Answer

The relationship between a weak entity type and its owner is an identifying relationship.

Question 62

FALSE

Accepted Answer

An entity type on which a strong entity is dependent is called a covariant entity.

Question 63

TRUE

Accepted Answer

An entity type name should always be a singular noun.

Question 64

FALSE

Accepted Answer

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

Modern Database Management – Chapter 2 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards