Chapter 1 Flashcards
________ are established between entities in a well-structured database so that the desired information can be retrieved.
Relationships
Database architects establish standards for data in business units.
True
Metadata are data that describe the properties of other data.
True
Metatdata typically describes all of the following EXCEPT:
location on disk.
Organizational commitment to a database project is not necessary for its success.
False
Many of the disadvantages of file processing systems can also be limitations of databases.
True
All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.
False
Prototyping is a type of rapid application development.
True
Database processing programs are coded and tested during the design stage of the systems development life cycle.
False
________ do NOT concentrate on determining the requirements for the database component of an information system.
End Users
Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.
True
The period that can be considered a “proof of concept” time was the:
1960s
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
Which of the following is software used to create, maintain, and provide controlled access to databases?
Database management system (DBMS)
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
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
user view
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.
True
The SDLC phase in which database processing programs are created is the ________ phase.
implementation
Separation of metadata from application programs that use the data is called data independence.
True
Which of the following is NOT a cost and/or risk of the database approach?
Improved responsiveness
Which of the following is NOT an advantage of database systems?
Redundant data
Multi-tier client/server database applications contain a business logic layer.
True
Although personal databases improve productivity, one risk is that data cannot be shared with other users.
True
An enterprise resource planning system integrates all functions of the enterprise.
True
A well-structured database establishes the entities between relationships in order to derive the desired information.
False
________ do NOT concentrate on determining the requirements for the database component of an information system.
End Users
A database is an organized collection of ________ related data.
logically
Database development projects are never done in a bottom-up fashion.
False
Because applications are often developed independently in file processing systems:
unplanned duplicate data files are the rule rather than the exception.
The steps of the systems development life cycle can only be viewed as a linear process.
False
The repository is populated during the analysis phase of the systems development life cycle.
True
________ specify computer systems requirements.
Systems analysts
The data repository assists database administrators in enforcing standards.
True
Which of the following is NOT a cost and/or risk of the database approach?
Improved responsiveness
One of the most popular RAD methods is:
prototyping.
A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):
entity.
The need for consensus on data definitions is an example of which type of risk in the database environment?
Organizational conflict
A major difference between data warehouses and transactional systems as compared to big data is:
the data is unstructured in big data systems.
Enterprise modeling sets the range and general contents of organizational databases.
True
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
user view