Database Management Exam 1 – Flashcards
Unlock all answers in this set
Unlock answersquestion
One application of data warehouses is:
answer
decision support
question
Older systems that often contain data of poor quality are called ________ systems.
answer
legacy
question
A database is an organized collection of ________ related data.
answer
logically
question
Data processed in a way that increases a user's knowledge is:
answer
information.
question
One disadvantage of file processing systems is:
answer
limited data sharing.
question
A person, place, object, event or concept about which the organization wishes to maintain data is called a(n):
answer
entity.
question
________ is a tool even non-programmers can use to access information from a database.
answer
Structured query language
question
In a file processing environment, descriptions for data and the logic for accessing the data are built into:
answer
application programs.
question
A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):
answer
repository.
question
Languages, menus, and other facilities by which users interact with the database are collectively called a(n):
answer
user interface.
question
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.
answer
analysis
question
Repositories are always used in file processing systems.
answer
FALSE
question
An enterprise data model describes the scope of data for only one information system.
answer
FALSE
question
The steps of the systems development life cycle can only be viewed as a linear process.
answer
FALSE
question
The repository is populated during the analysis phase of the systems development life cycle.
answer
TRUE
question
The physical structure and storage organization of the database are decided upon during the implementation phase of the systems development life cycle.
answer
FALSE
question
Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.
answer
TRUE
question
Characteristics of the structure of the database are generally changed during the implementation phase of the database development process.
answer
FALSE
question
In 1998, ANSI/SPARC published an important document describing the three-schema architecture.
answer
FALSE
question
The conceptual schema is always technology specific.
answer
FALSE
question
Personal databases are designed to support a small group of individuals working together on a project.
answer
FALSE
question
The most common way to support a group of individuals who work together on a project or group of similar projects is with a two-tier client/server database.
answer
TRUE
question
Business policies and rules govern all of the following EXCEPT:
answer
managing employees.
question
Which of the following is NOT a good characteristic of a data name?
answer
Relates to a technical characteristic of the system
question
Customers, cars, and parts are examples of:
answer
entities.
question
A(n) ________ is the relationship between a weak entity type and its owner.
answer
identifying relationship
question
A property or characteristic of an entity type that is of interest to the organization is called a(n):
answer
attribute.
question
An attribute that can be calculated from related attribute values is called a(n) ________ attribute.
answer
derived
question
An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):
answer
composite identifier.
question
The number of entity types that participate in a relationship is called the:
answer
degree.
question
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.
answer
many-to-many
question
The purpose of data modeling is to document business rules about processes.
answer
FALSE
question
A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.
answer
FALSE
question
Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload
answer
Define one vehicle entity type to hold all entities.
question
In the figure below, which of the following are subtypes of patient?
answer
Outpatient
question
In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized?
answer
Vehicle
question
The following figure is an example of:
answer
total specialization.
question
In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ________ rule.
answer
disjoint
question
Packaged data models:
answer
require customization.
question
The third step in the data modeling process with a packaged data model is:
answer
map data to be used from package to data in current databases.
question
One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.
answer
TRUE
question
Specialization is the reverse of generalization.
answer
TRUE
question
The total specialization rule states that an entity instance of a supertype is allowed not to belong to any subtype.
answer
FALSE
question
The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes.
answer
TRUE
