5370 Quiz 1
Specifying how data from a logical schema are stored in secondary memory is part of the:
Design
A user view is how the user sees data when it is produced.
False
A well-structured database establishes the entities between relationships in order to derive the desired information.
False
Database development begins with the design of the database.
False
Reduced program maintenance is and advantage of file processing systems.
False
The conceptual schema is always technology specific.
False
The steps of the systems development life cycle can only be viewed as a linear process.
False
With the traditional file processing approach, each application shares data files, thus enabling much data sharing.
False
Which of the following is NOT a cost and/or risk of the database approach?
Improved responsiveness
______ is a tool even non-programmers can use to access information from a database.
Structured Query Language
Which of the following is NOT an objective that drove the development and evolution of database technology?
The desire to require programmers to write all file handling functionality.
A modern database management system automates more of the backup and recovery tasks than a file system.
True
A relational database establishes the relationships between entities by means of a common field.
True
Database architects establish standards for data in business units.
True
E.F. Codd developed the relational data model during the 1970s.
True
File processing systems have been replaced by database systems in most critical business applications today.
True
Information is processed data.
True
Metadata are data that describe the properties of other data.
True
Multi-tier client/server database applications contain a business logic layer.
True
Prototyping is a type of rapid application development.
True
The data repository assists database administrators in enforcing standards.
True
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 rule that CANNOT be violated by database users is called a:
constraint.
Data that describe the properties of other data are:
metadata.
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 knowledge base of information or facts about an enterprise is called a(n):
repository.
A major difference between data warehouses and transactional systems as compared to big data is:
the data is unstructured in big data systems
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