Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/25

Click to flip

25 Cards in this Set

  • Front
  • Back
What is a database?
a collection of all files of the organization.
(the files can be stand alone or managed by a DBMS.)
What are two Secondary Storage Devices Classification?
By Function: (sequential, random)

By Type: (magnetic disk, magnetic tape, optical disk)
What are file types by function?
Master file
transaction file
backup file
history file
What are file access methods?
sequential
Random access (direct access)
Indexing
ISAM
VSAM
What are the procedures for Sequential (Batch) Processing?
The Master file contains data from previous cycle. Data is stored sequentially, sorted by the record key.
2. Transactions are accumulated on a Transaction file in the random order they arrive
3. Periodically, the Transactions file is sorted by the key and merged with the Master file to create a new Master file
What does ISAM mean?
Indexed Sequential Access Method
What are the disadvantages of a file processing system?
Duplication of Data
Limited Data Sharing
Program-Data Dependence
Lengthy Development Time and maintenance
What is data?
all the facts, text, graphics, images, sound, and video segments that have meaning in the user environment.
What is information?
is data that was processed to increase the knowledge of the person who uses it.
What is Meta data?
are data that describes the property of other data (but doesn't include the data).
What is a data warehouse?
data mart) contains historical and summarized data which is used by management for decision making.
What functions can a database application perform?
Create, read, update, delete
How is a database developed?
By the conceptual and physical schema
What is schema?
Definition of the entire database; entities, attributes, relations.
What is subschema?
Portion of the schema. It defines the portion of the schema (database) which is accessible to certain users based on password.
What is the Data Dictionary?
(encyclopedia): holds the entire information about the database, including the tables, relations, design comments.
What is the catalog?
multiple schemas (Oracle terminology)
What is DDL?
(Data Definition Language): Used to generate the schema. It can be created via the GUI interfaces in Access or SQL commands.
What is DML?
(Data Manipulation Language): are the SQL commands for processing data .
What is DBMS?
(Database Management System): Set of programs that manages a database.
What are the advantages of the database approach?
Program-data independence
Minimal data redundancy
Improved Data Consistency
Improved Data Sharing
Increased Productivity of Application Development
Enforcement of Standards
Improve data quality (validation, integrity checks)
Improve data accessibility and responsiveness
Reduce Program Maintenance
Security
Data recovery
Where are the data definitions stored?
In the repository
Name several different database applicaions (range)
Personal
Department
Workgroup
Enterprise
Internet
Name some of the reasons, companies/individuals have not utilized DBMS, if they are so popular.
Cost of purchasing the database software (DBMS) is high. Depending on the system platform and number of user, it could be a six digits figure

Conversion of the old systems (referred to as legacy systems) from COBOL to SQL is expensive

The usage of DBMS requires sophisticated computer professionals

Organizational Conflict (politics)
It required management commitment, budgets, agreements among participants
Name first generation DBMS.
Hierarchical and network