Tuesday, February 7, 2012

Database Definitions

Field: A field is a single piece of information and also fields are the smallest units of information you can access.
Record: A record is one complete set of fields.  Records are composed of fields, each of which contains one item of information.

File:  A file is a collection of records. A collection of data or information that has a name, called the file name.

Query: A request for information from a database. A query is when you ask a question to the database. Query search for records that match the field criteria.
Database: A collection of information organized in such a way that a computer program can quickly select desired pieces of data

Report: A formatted and organized presentation of data.

DBMS: A collection of programs that enables you to store, modify, and extract information from a database.

Data Dictionary: A data dictionary contains a list of all files in the database, the number of records in each file, and the names and types of each field.

Data Types:
Classification of a particular type of information.
alphanumeric text eg, abc....123.....?#/......
numeric 0-9 , eg 1234

No comments:

Post a Comment