Modern Database Management – Chapter 1 – Flashcards

Unlock all answers in this set

Unlock answers
question
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
Which of the following types of data can be stored in a database?
answer
Voice, Letters, Numbers
question
Data processed in a way that increases a user's knowledge is:
answer
information.
question
Data that describe the properties of other data are:
answer
none of the above.
question
All of the following are properties of metadata EXCEPT:
answer
processing logic.
question
One disadvantage of file processing systems is:
answer
limited data sharing.
question
Program-data dependence is caused by:
answer
file descriptors being stored in each application.
question
Because applications are often developed independently in file processing systems:
answer
unplanned duplicate data files are the rule rather than the exception.
question
Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.
answer
80 percent
question
A graphical system used to capture the nature and relationships among data is called a(n):
answer
data model.
question
A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):
answer
entity.
question
________ are established between entities in a well-structured database so that the desired information can be retrieved.
answer
Relationships
question
Relational databases establish the relationships between entities by means of common fields included in a file called a(n):
answer
relation.
question
All of the following are primary purposes of a database management system (DBMS) EXCEPT:
answer
providing an integrated development environment.
question
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
answer
user view
question
With the database approach, data descriptions are stored in a central location known as a(n):
answer
repository.
question
A user view is:
answer
a logical description of some portion of the database.
question
Which organizational function should set database standards?
answer
None of the above
question
________ is a tool even non-programmers can use to access information from a database.
answer
Structured query language
question
Which of the following is NOT an advantage of database systems?
answer
Redundant data
question
The most common source of database failures in organizations is:
answer
failure to implement a strong database administration function.
question
A rule that CANNOT be violated by database users is called a:
answer
constraint.
question
In a file processing environment, descriptions for data and the logic for accessing the data are built into:
answer
application programs.
question
Databases may be more expensive to maintain than files because of:
answer
all of the above.
question
Which of the following is NOT a cost and/or risk of the database approach?
answer
Improved responsiveness
question
The need for consensus on data definitions is an example of which type of risk in the database environment?
answer
Organizational conflict
question
A knowledge base of information on facts about an enterprise is called a(n):
answer
repository.
question
Which of the following is software used to create, maintain, and provide controlled access to databases?
answer
Database management system (DBMS)
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
CASE is a class of tools that:
answer
automates the design of databases and application programs.
question
Languages, menus, and other facilities by which users interact with the database are collectively called a(n):
answer
user interface.
question
Database development begins with ________, which establishes the range and general contents of organizational databases.
answer
enterprise data modeling
question
The traditional methodology used to develop, maintain and replace information systems is called the:
answer
Systems Development Life Cycle.
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
The SDLC phase in which database processing programs are created is the ________ phase.
answer
implementation
question
The SDLC phase in which the detailed conceptual data model is created is the ________ phase.
answer
analysis
question
Organizing the database in computer disk storage is done in the ________ phase.
answer
design
question
An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:
answer
RAD.
question
One of the most popular RAD methods is:
answer
prototyping.
question
The three-schema approach includes which of the following schemas?
answer
Internal
question
________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.
answer
Systems analysts
question
________ concentrate on determining the requirements for the database component of an information system.
answer
Database analysts
question
E. F. Codd developed the relational model in the:
answer
1970s.
question
Which of the following is NOT an objective that drove the development and evolution of database technology?
answer
The desire to require programmers to write all file handling functionality
question
The period that can be considered a "proof of concept" time was the:
answer
1960s.
question
A relatively small team of people who collaborate on the same project is called a(n):
answer
workgroup.
question
A workgroup database is stored on a central device called a(n):
answer
server.
question
Which of the following is an integrated decision support database with content derived from various operational databases?
answer
Data warehouse
question
A data warehouse derives its data from:
answer
Various operational data sources.
question
Which of the following will interfere with access to operational databases?
answer
Unstructured and unpredictable use of data
question
Information is processed data.
answer
Answer: TRUE
question
In practice, databases today may contain either data or information.
answer
Answer: TRUE
question
Metadata are data that describe the properties of other data.
answer
Answer: TRUE
question
Databases were developed as the first application of computers to data processing.
answer
Answer: FALSE
question
File processing systems have been replaced by database systems in most critical business applications today.
answer
Answer: TRUE
question
Unplanned duplicate data files are the rule rather than the exception in file processing systems.
answer
Answer: TRUE
question
With the traditional file processing approach, each application shares data files, thus enabling much data sharing.
answer
Answer: FALSE
question
Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program.
answer
Answer: TRUE
question
Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.
answer
Answer: FALSE
question
Many of the disadvantages of file processing systems can also be limitations of databases.
answer
Answer: TRUE
question
A data model is a graphical system used to capture the nature and relationships among data.
answer
Answer: TRUE
question
A well-structured database establishes the entities between relationships in order to derive the desired information.
answer
Answer: FALSE
question
A person is an example of an entity.
answer
Answer: TRUE
question
The data that you are interested in capturing about an entity is called an instance.
answer
Answer: FALSE
question
A relational database establishes the relationships between entities by means of a common field.
answer
Answer: TRUE
question
Separation of metadata from application programs that use the data is called data independence.
answer
Answer: TRUE
question
Data redundancy is used to establish relationships between data but is never used to improve database performance.
answer
Answer: FALSE
question
Redundancy increases the risk of inconsistent data.
answer
Answer: TRUE
question
A user view is how the user sees the data when it is produced.
answer
Answer: FALSE
question
One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer.
answer
Answer: TRUE
question
The data repository assists database administrators in enforcing standards.
answer
Answer: TRUE
question
The failure to implement a strong database administrative function is the most common source of database failures in organizations.
answer
Answer: TRUE
question
A constraint is a rule in a database system that can be violated by users.
answer
Answer: FALSE
question
End users can often retrieve and display data easily with a relational database.
answer
Answer: TRUE
question
Reduced program maintenance is an advantage of file processing systems.
answer
Answer: FALSE
question
Cost and complexity are just two of the disadvantages of database processing.
answer
Answer: TRUE
question
The term legacy system refers to a newly installed database management system.
answer
Answer: FALSE
question
A modern database management system automates more of the backup and recovery tasks than a file system.
answer
Answer: TRUE
question
Organizational commitment to a database project is not necessary for its success.
answer
Answer: FALSE
question
Repositories are always used in file processing systems.
answer
Answer: FALSE
question
The user interface includes languages, menus, and other facilities by which users interact with various system components.
answer
Answer: TRUE
question
Personal databases are designed to support a small group of individuals working together on a project.
answer
Answer: FALSE
question
Database development begins with the design of the database.
answer
Answer: FALSE
question
An enterprise data model describes the scope of data for only one information system.
answer
Answer: FALSE
question
Database development projects are never done in a bottom-up fashion.
answer
Answer: FALSE
question
The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems.
answer
Answer: TRUE
question
The steps of the systems development life cycle can only be viewed as a linear process.
answer
Answer: FALSE
question
Enterprise modeling sets the range and general contents of organizational databases.
answer
Answer: TRUE
question
All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.
answer
Answer: FALSE
question
The repository is populated during the analysis phase of the systems development life cycle.
answer
Answer: TRUE
question
The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle.
answer
Answer: FALSE
question
Database processing programs are coded and tested during the design stage of the systems development life cycle.
answer
Answer: FALSE
question
Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.
answer
Answer: TRUE
question
Database maintenance is typically the longest step of the database development process.
answer
Answer: TRUE
question
Characteristics of the structure of the database are generally changed during the implementation phase of the database development process.
answer
Answer: FALSE
question
Prototyping is a type of rapid application development.
answer
Answer: TRUE
question
In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct.
answer
Answer: TRUE
question
Visual programming tools such as Visual Basic have made prototyping more difficult.
answer
Answer: FALSE
question
In 1998, ANSI/SPARC published an import document describing the three-schema architecture.
answer
Answer: FALSE
question
The conceptual schema is always technology specific.
answer
Answer: FALSE
question
The external schema contains a subset of the conceptual schema relevant to a particular group of users.
answer
Answer: TRUE
question
A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.
answer
Answer: TRUE
question
The internal schema consists of the physical schema and the enterprise data model.
answer
Answer: FALSE
question
Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications.
answer
Answer: FALSE
question
Database architects establish standards for data in business units.
answer
Answer: TRUE
question
E. F. Codd developed the relational data model during the 1970s.
answer
Answer: TRUE
question
The relational data model is no longer popular in the 21st century.
answer
Answer: FALSE
question
Although personal databases improve productivity, one risk is that data cannot be shared with other users.
answer
Answer: TRUE
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
Answer: TRUE
question
Each member of a workgroup accesses data located on a database server.
answer
Answer: TRUE
question
In two-tier database architectures, little functionality needs to be programmed into the client application.
answer
Answer: FALSE
question
Applications built with a multitier architecture are meant to support departments.
answer
Answer: TRUE
question
Multitier client/server database applications contain a business logic layer.
answer
Answer: TRUE
question
The scope of an enterprise application is one workgroup or department.
answer
Answer: FALSE
question
An enterprise resource planning system integrates all functions of the enterprise.
answer
Answer: TRUE
question
A data warehouse contains summarized and historical information.
answer
Answer: TRUE
question
An intranet utilizes Web-based technology to improve communication with parties outside of the organization.
answer
Answer: FALSE
question
An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers.
answer
Answer: TRUE
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New