CHAPTER 1 (Long Exam) Flashcards
A function of DBMS that involves specifying the data types, structures, and constraints for the data to be stored in the database.
Define
The characteristic that allows program-data independence.
Database Abstraction
The primary source in a database environment.
database
Responsible for acquiring software and hardware resources as needed?
Database Administrators
It is a collection of programs that enables users to create an maintain a database.
Database Management System
Responsible for choosing appropriate structures to represent and store this data.
Database Designer
These are standard types pf queries and updates.
Canned Transactions
They determine the requirements of end users, especially naive and parametric end users, and develop specifications for canned transactions that meet these requirements.
System Analysts
Persons who design and implement the DBMS modules and interfaces as a software package.
System Designers and Implementer
The process of storing the data itself on some storage medium that is controlled by the DBMS.
Construct
Responsible for administering the primary and secondary resources in a database environment.
Database Administrators
The interface for casual users.
Query Language
The system administration personnel who are responsible for the actual running and maintenance of the hardware and software environment for the database system.
Operators and Maintenance Personnel
It is a collection of related data.
Database
Include engineers, scientists, business analysts, and others who thoroughly familiarize themselves with the facilities of the DBMS so as to implement their applications to meet their complex requirements.
Sophisticated
Those who work to maintain the database system environment, but who are not actively interested in the database itself.
Workers behind the Scene
The interface for application programmers.
Programming Language
Any known facts that can be recorded and which have implicit meaning
Data
They maintain personal databases by using ready-made program packages that provide easy to use menu or graphics-based interfaces.
Stand Alone End Users
The secondary resource in a database environment.
DBMS and Related Softwares
Includes such functions as querying the database to retrieve specific data, updating the database to reflect changes in the mini world, and generating reports from the data.
Manipulate
Those people whose jobs involve the day to day use of a large database.
Actors on the Scene
This refers to the property wherein the structure of data files is stored in the DBMS catalog separately from the access programs.
Isolation (*)
The interface for parametric users.
Forms
This will ensure that several users trying to update the same data do so in a controlled manner so that the result of the updates is correct.
Concurrency control
The people whose jobs requires access to the database for querying, updating, and generating reports.
End-Users
Their main job function revolves around constantly querying and updating the database using canned transactions.
Naive/Parametric
Include persons who design and implement tools
Tool Designers
The interface for stand-alone users.
Menu Driven Interface
Accountable for the problem such as breach of security, or poor system response time.
Database Administrators
The software packages that facilitate database system design and use and help improve performance.
Tools
They implement the specifications as programs; then they test, debug, document, and maintain these canned transactions
Application Programmers
They occasionally access the database, but they may need different information each time.
Casual End-Users
Responsible for Identifying the data to be stored in the database.
Database Designer
A feature of databases systems dictating that it must happen in its entirety or not at all.
Atomicity
A DBMS should provide a security and authorization subsystem, which the DBA uses to create accounts and specify account restrictions.
TRUE
Databases cannot be used to provide persistent storage for program objects and data structures.
FALSE
Databases can*
A database represents some aspect of the real world, sometimes called mini world.
TRUE
A fundamental characteristic of the database approach is that the database system contains not only the database itself but also a complete definition or description of the database structure and constraints.
TRUE
The backup and recovery subsystem of the DBMS is responsible for recovery.
TRUE
A query is a question represented in a way that the DBMS can recognize and process.
TRUE
The simplest type of integrity constraint involves specifying a data type for each data item.
TRUE
A random assortment of data can be referred to as a database.
FALSE
A database typically has many users, each of whom may require only one perspective or view of the database.
FALSE
It is the responsibility of database administrators to communicate with all prospective database users, in order to understand their requirements, and to come up with a design that meets these requirements.
FALSE
A database is designed, built, and populated with data for a specific purpose.
TRUE
A DBMS must have the capability to represent a variety of complex relationships among the data as well as to retrieve and update related data easily and efficiently.
TRUE
A database cannot be of any size and of varying complexity.
FALSE
A database is a random collection of data with some inherent meaning.
FALSE
