How can we help?

You can also find more resources in our Help Center.

37 terms

Computer Chapter 10

STUDY
PLAY
Database
A Collection of Data
Information
Processed Data
DBMS - Database Management System
Add, modify, delete, sort, or retrieve data
Data integrity
Identifies the quality of the data
GIGO
Garbage in, garbage out
Accurate information
Error-free data
Verifiable information
Data that can be proven to be correct or incorrect
Timely information
Data that has an age suited to its use
Organized information
Data that is arranged to suit the needs and requirements of the user
Accessible information
Data that is available when the user needs it
Useful information
Data that has meaning to the user
Cost-effective information
Data that gives more value that it costs to produce
Database hierarchy
Databse contains files which contain records which contain fields which contain characters
Character
A number, letter, space, punctuation mark, or symbol
Field
A combination of one or more related characters
Field name
Uniquely identifies each field
Field size
Defines the maximum number of characters a field can contain
Data type
Specifies the kind of data a field can contain
Common data types
Text, numeric, autonumber, currency, date, memo, yes/no, hyperlink, object
Record
A group of related fields
Primary key
A field that uniquely identifies each record in a field
Data file
A collection of related records
File maintenance
Procedures that keep data current
2 Reasons to modify a record
1) to correct inaccurate data, 2) to update old data with new data
Validation
Comparing data with a set of rules or values to find out if the data is correct
Validation checks
alphabetic/numeric, range, consistency, completeness, digit
Benefits of using a database
reduced data redundancy, improved data integrity, shared data, easier access, reduced development time
Data dictionary
Contains data about each file in the database and each field in those files.
Query
A request for specific data
Form
A window on the screen that provides areas for entering ro modifying data
Backup
A copy of the database
Recovery utility
Uses backups to restore lost or damaged data
Data model
Rules and standards that define how the database organizes information
Relational database
Organizes data using tables, columns, rows, and relationships
Different types of databases
Multimedia, groupware, computer-aided design, hypertext
Multidimensional Database
A database that stores data in multiple dimensions
Structure Query Language (SQL)
Allows users to manage, update, and retrieve data in a relational database