Quiz answers - CH 1
Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.
80 percent
Which of the following is software used to create, maintain, and provide controlled access to databases?
Database management system (DBMS)
Organizing the database in computer disk storage is done in the ________ phase
Design
A user view is how the user sees the data when it is produced.
False
An enterprise data model describes the scope of data for only one information system.
False
Database development projects are never done in a bottom-up fashion.
False
Repositories are always used in file processing systems.
False
The conceptual schema is always technology specific.
False
The scope of an enterprise application is one workgroup or department.
False
The steps of the systems development life cycle can only be viewed as a linear process.
False
________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.
Systems analysts
A data model is a graphical system used to capture the nature and relationships among data.
True
A person is an example of an entity.
True
A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.
True
Although personal databases improve productivity, one risk is that data cannot be shared with other users.
True
An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers.
True
Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.
True
Database maintenance is typically the longest step of the database development process.
True
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.
True
E. F. Codd developed the relational data model during the 1970s.
True
Each member of a workgroup accesses data located on a database server.
True
End users can often retrieve and display data easily with a relational database.
True
In practice, databases today may contain either data or information.
True
In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct.
True
Information is processed data.
True
Metadata are data that describe the properties of other data
True
Multitier client/server database applications contain a business logic layer.
True
Separation of metadata from application programs that use the data is called data independence
True
Separation of metadata from application programs that use the data is called data independence.
True
The repository is populated during the analysis phase of the systems development life cycle.
True
Unplanned duplicate data files are the rule rather than the exception in file processing systems.
True
Which of the following will interfere with access to operational databases?
Unstructured and unpredictable use of data
A user view is:
a logical description of some portion of the database.
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
CASE is a class of tools that
automates the design of databases and application programs
A rule that CANNOT be violated by database users is called a:
constraint
A graphical system used to capture the nature and relationships among data is called a(n):
data model
One disadvantage of file processing systems is:
limited data sharing
A database is an organized collection of ________ related data.
logically
One of the most popular RAD methods is:
prototyping
A data warehouse derives its data from
various operational data sources
A relatively small team of people who collaborate on the same project is called a(n):
workgroup
