Ppt10-Database Flashcards
Collection of unprocessed items
Data
Processed data
Information
Allow user to create online computerized database
Database system
One byte
Character
Combination of related characters
Field
Combination of related fields
Record
Field thAt identifies records
Primary key
Collection of reltaed records
Data file
Procedure to keep data current
File maintenance
Compare data to rules to determine if it meets certain criteria
Validation
Define how user view organization of data
Data model
Contain data about each file in database
Data dictionary
English like statments that allow user to specify data
Query langauge
Request for specific data from database
Query
Allow user to enter, retrieve and edit
Structured query language
Has GUI to help user retireve data
Query by example
Window on screen that provide space for data editing
Form
Allow user to design report, where data is entered
Report writer
Techniques to restore database
Log
Backup
Recover utility
Continouos backup
