Chapter 1 Flashcards
what types of databases does traditional applications have?
numeric and textual databases.
stock administration is an example of….
numeric and textual databases used in traditional databases
spotify and youtube are examples of ___________ databases.
multimedia
GIS stands for….
Geographic Information Systems
Name 3 types of databases used in recent applications:
- multimedia databases
- geographical information systems
- biological and genome databases
- data warehouses
- mobile databases
- real-time and active databases
Data that resides on the “cloud” means
it is in huge data centers using thousands of machines
a collection of related data.
database
known facts that can be recorded and have an implicit meaning.
data
a software package/system to facilitate the creation and maintenance of a computerized database.
Database Management System (DBMS)
the DMBS software together with the data itself. (Sometimes, the applications are also included.
Database System
A database system is composed of ________ and _________.
the DBMS, the data itself.
T/F: Student grades and transcripts at a university is an example of a mini-world
true.
some part of the real world about which data is stored in a database.
mini-world
A database has a ______, a ______, and an __________ as its implicit properties.
source, form, audience.
T/F: Changes to the miniworld are reflected in the database.
true.
T/F: A random assortment of data can be referred to as a database.
false, it cannot be referred to as a database.
T/F: A database is a logically coherent collection of data with some inherent meaning.
true.
T/F: A database does not have an intended group of users.
false, it has an intended group of users
T/F: A database is designed, built, and populated with data for a general purpose.
false, for a specific purpose
T/F: A database has a specific size and complexity.
false, it can be of any size and complexity.
A simplified database system environment includes the ______, and the ____________.
database system, DBMS software.
The DBMS software includes two kind of software one to _____________, and one to ___________.
process queries/programs, access stored data.
What are the two kinds of databases that the DBMS software accesses?
the stored database, and the stored database definition (Meta-Data)
T/F: the DBMS doesn’t have to deal with the authorization of users to allow them access to data.
false, DBMS must not allow unauthorized users to access data.
T/F: the DBMS must keep up with changing user requirements against the database.
true
T/F: Defining a particular database in terms of its data types, structures, and constraints is one of the typical DBMS functions.
true
_______ or ________ the initial database contents on a secondary storage medium is one of the typical DBMS functions.
Constructing, loading
T/F: Manipulating the database, one of the typical DBMS functions, includes retrieval, modification, and accessing the database through web applications.
true.
_______ and ________ by a set of concurrent users and applications programs, is one of the typical functions of the DBMS.
Processing, sharing.
The data that is being processing and shared in a DBMS by concurrent users and application programs must all be ______ and _______.
valid, consistent.
Applications interact with a database by generating ________ and ___________.
queries, transcations.
an executing program that forms a logical unit of database processing.
transcations
T/F: transcations include only one of database access operations including insertion, deletion, modification or retrieval operations.
false, one or more.
transcations need to be ________ or _______.
committed, aborted.