Database Exam 1

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

80 percent

For the relationship represented in the figure below, which of the following is true?

A department can have more then one employee.

supertype/subtype hierarchy.

A hierarchical arrangement of supertypes and subtypes in which each subtype has only one supertype.

In the figure below, which of the following is true?

A person can marry at most one person.

Which of the following statements is true about the figure shown below?

A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time.

Which of the following statements is true about the figure shown below?

A rental unit can be an apartment, a house or just a rental unit; it may not be more than one at the same time.

Which of the following statements is true about the figure shown below?

A rental unit must be either an apartment or a house and cannot be both at the same time.

Which of the following statements is true about the figure shown below?

A rental unit must be either an apartment or a house and could be both.

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

A. All the relationships for the participating entities are many-to-many B. The new associative entity has independent meaning C. The new associative entity participates in independent relationships D. All of the above Answer = D. All of the above

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

A. Choose an identifier that will not be null B. Choose an identifier that doesn't have large composite attributes C. Choose an identifier that is stable D. All of the above Answer = D. All of the above

In the following diagram, which of the answers below is true?

A. Each patient has one or more patient histories. B. Each patient has one and only one visit. C. Each patient history belongs to one and only one patient. D. Both A and C Answer = D. Both A and C

In the following diagram, which is true?

A. It depicts a unary relationship B. It depicts a many-to-many relationship C. There is an associative entity D. All of the above Answer = D. All of the above

Databases may be more expensive to maintain than files because of:

A. The need for specialized personnel. B. The complexity of the database environment. C. Backup and recovery needs. D. All of these Answer = D. All of the above.

Which of the following types of data can be stored in a database?

A. Voice B. Letters C. Numbers D. All of the above Answer = D. All of the above

The common types of entities are:

A. Weak entities B. Strong entities C. Associative entities D. All of the above Answer = D. All of the above

In the following diagram, which answer is true?

Each employee can supervise one to many employees.

In the figure below, which of the following are subtypes of patient?

Outpatient

The subtype discriminator in the figure below is:

Part_Type

Which of the following is NOT an advantage of database systems?

Redundant data

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

Relates to a technical characteristic of the system

______ are established between entities in a well-structured database so that the desired information can be retrieved.

Relationships

In the figure below, which attribute is multivalued?

Skill

Which of the following is a generic entity type that has a relationship with one or more subtypes?

Supertype

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

Ternary

Which of the following is a completeness constraint?

Total specialization

In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized?

Vehicle

Which statement is true about the following diagram?

all attributes of person and student are inherited by undergraduate.

An entity name should be all of the following EXCEPT:

as short as possible

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

associative entity

The property by which subtype entities possess the values of all attributes of a supertype is called:

attribute inheritance.

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

attribute.

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

attributes.

CASE is a class of tools that:

automate the design of databases and application programs.

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

cardinality constraint

A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.

completeness

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

composite

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

composite identifier.

A good method for identifying inconsistencies and finding hidden meaning in the customized purchased data model is:

data profiling.

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

degree.

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

derived

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

derived

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

derived

The most important challenge of customizing a purchased data model is:

determining the business rules that will be established through the data model.

In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ________ rule.

disjoint

The ________ rule specifies that an entity can be a member of only one subtype at a time.

disjoint

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.

disjointedness constraint

Customers, cars, and parts are examples of:

entities

When identifying with the parts of the packaged data model that apply to your organization, you should first start with:

entities

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

entity-relationship model

The process of defining a more general entity type from a set of more specialized entity types is called:

generalization.

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

information.

One disadvantage of file processing systems is:

limited data sharing.

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

The third step in the data modeling process with a packaged data model is:

map data to be used from package to data in current databases.

All of the following are advantages of packaged data models EXCEPT:

more one-to-one relationships give the data model more flexibility.

In the figure below, a student:

must be a graduate student, an undergraduate, a special student or some other type of student.

An attribute of the supertype that determines the target subtype(s) is called the:

none of the above (subtype discriminator)

Data that describe the properties of other data are:

none of the above.

In a supertype/subtype hierarchy, each subtype has:

only one supertype.

The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.

overlap

The subtype discriminator is a composite attribute when there is a(n):

overlap rule.

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.

partial specialization

All of the following are properties of metadata EXCEPT:

processing logic.

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

providing an integrated development environment.

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

relation.

With the database approach, data descriptions are stored in a central location known as a:

repository.

Packaged data models:

require customization.

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

required attribute.

The process of defining one or more subtypes of a supertype and forming relationships is called:

specialization

In a supertype/subtype hierarchy, subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________ in the hierarchy.

supertypes

The following figure shows an example of:

the overlap rule.

Subtypes should be used when:

there are attributes that apply to some but not all instances of an entity type.

The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

total specialization

The following figure is an example of:

total specialization

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

two

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

unary

A generic or template data model that can be reused as a starting point for a data modeling project is called a(n):

universal data model.

Because applications are often developed independently in file processing systems:

unplanned duplicate data files are the rule rather than the exception.

All of the following are steps to using a packaged data model EXCEPT:

utilize all business rules that come with the packaged data model.

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

weak

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

who can delete the data.