Computer Chapter 10

37 terms by necck2 

Create a new folder

Advertisement Upgrade to remove ads

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set