MDM Exam 1 (CH: 1+2+3+4)
Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance
80%
Referring to the figure below, which of the following is NOT true?
A component is always used in only one item.
For the relationship represented in the figure below, which of the following is true?
A department can have more than one employee.
In the figure shown below, which of the following is true?
A person can marry at most one person.
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.
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.
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.
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.
A rental unit must be either an apartment or a house and cannot be both at the same time.
A rental unit must be either an apartment or a house and cannot be both at the same time.
A rental unit must be either an apartment or a house and could be both.
A rental unit must be either an apartment or a house and could be both.
The relational data model consists of which components?
All of these
Which of the following types of data can be stored in a database?
All of these
In the following diagram, which is true?
All of these.
Physical database design decisions must be made carefully because of impacts on:
All of these.
The common types of entities are:
All of these.
Which of the following conditions should exist if an associative entity is to be created?
All of these.
Which of the following criteria should be considered when selecting an identifier?
All of these.
In the following diagram, which is true?
Both Each patient has one or more patient histories and Each patient history belongs to one and only one patient
The following figure shows an example of:
Both Each patient has one or more patient histories and Each patient history belongs to one and only one patient
In the figure below, the primary key for "Order Line" is which type of key?
Composite
_______ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.
Data integrity
Which of the following is an integrated decision support database with content derived from various operational databases?
Data warehouse
Which of the following is software used to create, maintain, and provide controlled access to databases?
Database management system (DBMS)
given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, TransmissionSUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, TransmissionTruck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload
Define one vehicle entity type to hold all entities.
In the following diagram, which answer is true?
Each employee can supervise one to many employees.
Which of the following is NOT a cost and/or risk of the database approach?
Improved responsiveness
The three-schema approach includes which of the following schemas?
Internal
Which of the following is not a suggestion by Salin regarding developing data names?
Keep insignificant or illegal words.
in the figure below, what type of relationship is depicted?
Many-to-many
Which of the following is an entity type on which a strong entity depends?
None of these
Which organizational function should set database standards?
None of these
An attribute of the supertype that determines the target subtype(s) is called the:
None of these.
Data that describe the properties of other data are:
None of these.
The following diagram shows:
None of these.
The need for consensus on data definitions is an example of which type of risk in the database environment?
Organizational conflict
In the figure below, which of the following are subtypes of patient?
Outpatient
The subtype discriminator in the figure below is:
Part_Type
An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:
RAD
In the figure below, what type of key is depicted?
Recursive foreign
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
Relationship
Which of the following is NOT a reason to create an instance of a relational schema with sample data?
Sample data can reverse database implementation errors.
A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?
Second
In the figure below, which attribute is multivalued?
Skill
In the figure below, what type of relationship do the relations depict?
Strong entity/weak entity
_______ is a tool even non-programmers can use to access information from a database.
Structured query language
Which of the following is a generic entity type that has a relationship with one or more subtypes?
Supertype
The traditional methodology used to develop, maintain and replace information systems is called the:
Systems Development Life Cycle
In the following diagram, what type of relationship is depicted?
Ternary
Which of the following is a completeness constraint?
Total specialization
Which of the following will interfere with access to operational databases?
Unstructured and unpredictable use of data
n the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized?
Vehicle
In the figure below, which attribute is derived?
Years_Employed
A user view is:
a logical description of some portion of the database
The following figure shows an example of:
a strong entity and its associated weak entity.
An alternative name for an attribute is a(n):
alias
Which of the following anomalies result from a transitive dependency?
all
Which of the following are anomalies that can be caused by redundancies in tables?
all
Which of the following are properties of relations?
all
all attributes of person and student are inherited by undergraduate.
all attributes of person and student are inherited by undergraduate.
An understanding of how to merge relations is important because:
all of these
Databases may be more expensive to maintain than files because of:
all of these
A mutually exclusive relationship is one in which
an entity instance can participate in only one of several alternative relationships.
The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase.
analysis
The SDLC phase in which the detailed conceptual data model is created is the ________ phase.
analysis
In a file processing environment, descriptions for data and the logic for accessing the data are built into:
application programs.
An entity type 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 primary key that consists of more than one attribute is called a:
composite key.
A rule that CANNOT be violated by database users is called a
constraint.
In the SQL language, the ________ statement is used to make table definitions.
create table
When a regular entity type contains a multivalued attribute, one must
create two new relations, one containing the multivalued attribute.
A graphical system used to capture the nature and relationships among data is called a(n)
data model.
A good method for identifying inconsistencies and finding hidden meaning in the customized purchased data model is:
data profiling.
One application of data warehouses is:
decision support.
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
The total quiz points for a student for an entire semester is a(n) ________ attribute
derived
A nonkey attribute is also called a(n):
descriptor.
Organizing the database in computer disk storage is done in the ________ phase
design
The attribute on the left-hand side of the arrow in a functional dependency is the
determinant.
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
Database development begins with ________, which establishes the range and general contents of organizational databases.
enterprise data modeling
When identifying with the parts of the packaged data model that apply to your organization, you should first start with:
entities
Customers, cars, and parts are examples of:
entities.
The ________ states that no primary key attribute may be null.
entity integrity rule
The logical representation of an organization's data is called a(n)
entity-relationship model.
A person, place, object, event or concept about which the organization wishes to maintain data is called a(n)
entity.
The most common source of database failures in organizations is:
failure to implement a strong database administration function.
Program-data dependence is caused by:
file descriptors being stored in each application.
When all multivalued attributes have been removed from a relation, it is said to be in:
first normal form
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:
foreign key.
A constraint between two attributes is called a(n):
functional dependency
The process of defining a more general entity type from a set of more specialized entity types is called:
generalization
An attribute that may have more than one meaning is called a(n)
homonym.
A(n) ________ is the relationship between a weak entity type and its owner
identifying relationship
The SDLC phase in which database processing programs are created is the ________ phase.
implementation
Data processed in a way that increases a user's knowledge is:
information.
A domain definition consists of the following components EXCEPT:
integrity constraints.
Older systems that often contain data of poor quality are called ________ systems.
legacy
One disadvantage of file processing systems is:
limited data sharing.
A database is an organized collection of ________ related data
logically
Business policies and rules govern all of the following EXCEPT:
managing employees.
A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.
mandatory one
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 the main goals of normalization EXCEPT:
maximize storage space.
All of the following are advantages of packaged data models EXCEPT:
more one-to-one relationships give the data model more flexibility.
The entity integrity rule states that:
no primary key attribute can be null.
In the figure below, what type of relationship do the relations depict?
one to many
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.
A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency.
partial functional
The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.
partial specialization
The following figure is an example of:
partial specialization.
A form of database specification that indicates all the parameters for data storage that are then input to database implementation is:
physical.
an attribute (or attributes) that uniquely identifies each row in a relation is called a:
primary key.
All of the following are properties of metadata EXCEPT:
processing logic.
One of the most popular RAD methods is:
prototyping.
All of the following are primary purposes of a database management system (DBMS) EXCEPT:
providing an integrated development environment.
a rule that states that each foreign key value must match a primary key value in the other relation is called the:
referential integrity constraint.
Relational databases establish the relationships between entities by means of common fields included in a file called a(n):
relation
A two-dimensional table of data is called a:
relation.
A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):
repository.
A knowledge base of information on facts about an enterprise is called a(n)
repository.
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.
A workgroup database is stored on a central device called a:
server
The process of defining one or more subtypes of a supertype and forming relationships is called:
specialization
Another word for a data definition is a(n)
structural assertion.
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
Two or more attributes having different names but the same meaning are called:
synonyms
A simultaneous relationship among the instances of three entity types is called a ________ relationship.
ternary
The figure below is an example of mapping which type of relationship?
ternary
A candidate key must satisfy all of the following conditions EXCEPT:
the key must indicate the row's position in the table.
the overlap rule.
the overlap rule.
Subtypes should be used when:
there are attributes that apply to some but not all instances of an entity type.
A value that indicates the date or time of a data value is called a
time stamp.
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.
A functional dependency between two or more nonkey attributes is called a:
transitive dependency.
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.
Languages, menus, and other facilities by which users interact with the database are collectively called a(n):
user interface.
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
user view
All of the following are steps to using a packaged data model EXCEPT:
utilize all business rules that come with the packaged data model.
A data warehouse derives its data from:
various operational databases.
An entity type whose existence depends on another entity type is called a ________ entity.
weak
A relation that contains minimal redundancy and allows easy use is considered to be:
well-structured
A good data definition will describe all of the characteristics of a data object EXCEPT
who can delete the data.
A relatively small team of people who collaborate on the same project is called a
workgroup.
Understanding the steps involved in transforming EER diagrams into relations is important because:
you must be able to check the output of a CASE tool.
