Design of DB Ch. 1 & 2

One application of data warehouses is:

decision support.

Data processed in a way that increases a user's knowledge is:

information.

All of the following are properties of metadata EXCEPT:

processing logic.

Program-data dependence is caused by:

file descriptors being stored in each application.

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

80 percent

A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):

entity.

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

relation.

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

user view

________ is a tool even non-programmers can use to access information from a database.

Structured query language

The most common source of database failures in organizations is:

failure to implement a strong database administration function.

In a file processing environment, descriptions for data and the logic for accessing the data are built into:

application programs.

Which of the following is NOT a cost and/or risk of the database approach?

Improved responsiveness

A knowledge base of information on facts about an enterprise is called a(n):

repository.

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):

repository.

Languages, menus, and other facilities by which users interact with the database are collectively called a(n):

user interface

The traditional methodology used to develop, maintain and replace information systems is called the:

Systems Development Life Cycle.

The SDLC phase in which database processing programs are created is the ________ phase.

implementation

Organizing the database in computer disk storage is done in the ________ phase.

design

One of the most popular RAD methods is:

prototyping.

________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.

Systems analysts

E. F. Codd developed the relational model in the:

1970s.

A workgroup database is stored on a central device called a(n):

server.

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

entity-relationship model

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

who can delete the data.

A fact is an association between two or more:

terms.

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

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

The most common types of entities are:

strong entities.

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

two

Business policies and rules govern all of the following EXCEPT

managing employees.

A ________ defines or constrains some aspect of the business.

business rule

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

Inconsistent

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

Relates to a technical characteristic of the system

Customers, cars, and parts are examples of:

entities.

Which of the following is an entity that exists independently of other entity types?

Strong

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

weak

The following figure shows an example of:

B) a strong entity and its associated weak entity.

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

identifying relationship

An entity type name should be all of the following EXCEPT

as short as possible.

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

attribute.

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

required attribute.

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

attributes.

An attribute of an entity that is computed is a(n):

derived attribute.

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

composite

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

one.

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

degree.

A relationship between the instances of a single entity type is called a ________ relationship.

unary

In the following diagram, what type of relationship is depicted?

C) Ternary

In the following diagram, which is true?

It depicts a many-to-many relationship.

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

ternary

The following figure shows an example of:

a composite attribute.

In the figure below, which attribute is multivalued?

C) Skill

In the figure below, which attribute is derived?

Years_Employed

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

derived

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

derived

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

Choose an identifier that doesn't have large composite attributes.

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

composite identifier.

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

associative entity.

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

cardinality constraint

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

mandatory one

A mutually exclusive relationship is one in which:

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

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.

many-to-many

A value that indicates the date or time of a data value is called a:

time stamp.

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

t

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

t

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

t

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

f

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

t

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

f

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

t

A business rule should be internally consistent.

t

Business rules are formulated from a collection of business ramblings. .

f

Data names should always relate to business characteristics.

t

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

f

A fact is an association between two or more terms.

t

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

t

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

t

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

t

In the figure below, Name would be an ideal identifier.

f

When choosing an identifier, choose one that will not change its value often

t

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

f

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

t

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

t

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

f

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

f

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

f

Data names do not have to be unique.

f

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

t

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

f

An entity type name should always be a singular noun.

t

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

f

Some examples of attributes are: eye_color, weight, student_id, STUDENT. T

f

A simple attribute can be broken down into smaller pieces.

f

An attribute whose values can be calculated from related attribute values is called a derived attribute.

t

A multivalued attribute may take on more than one value for a particular entity instance.

t

Relationships represent action being taken using a verb phrase

t

Participation in a relationship may be optional or mandatory.

t

A ternary relationship is equivalent to three binary relationships

f

The degree of a relationship is the number of attributes that are associated with it.

f

The relationship between the instances of two entity types is called a binary relationship.

t

The relationship among the instances of three entity types is called a unary relationship. .

t