Jess.Bee.Happy! NA-NA-NA-NA-NA

Monday, February 1, 2010

9:13 AM

Paper (Manuel) - Hard copy

Flat File - type of database where all of the data is contained in one file. For all of the information to be held in one table, every student record would require data to be unnecessarily duplicated, introducing redundant data

Relational Database - collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. Store alot of information.

Hypermedia - a multimedia system in which related items of information are connected and can be presented together. Can be access anywhere, depending on security levels. (not the best because of security).Passwords,

Personnel Records - documenting the management of employees are important records in all organisations.

Encription - encoding: the activity of converting data or information into code

Level of Access - how much can be accessed. Eg age groups, or position (boss vs emmployee)

Data Dictionary - Meta Data [data about data] , A data dictionary is a table providing a comprehensive description of each field in the database. This commonly includes: field name, data type, data format, field size, description and example.

Schema - the organisational structure of a database. It should show the entities (the tables in the database), and their characteristics (i.e. their properties/attributes/fields). It should clearly identify the primary key in each table and the links and relationships between tables. The example below is just one way a schema can be represented.

Defined as an organised plan of the entire database showing how and where the data is to be found, descriptions of the data, and their logical relationships.

Primary Key - primary key is a character or group of characters used to identify a unique record in a database. The key is composed of one or more fields from the record.

Data validation - as a check on entered data to ensure that it is of the correct data type and that its value is sensible. If anything other then 'M' or 'F' is entered into the 'Gender' field, the entry will not be allowed and a warning message will be displayed. This will assist accurate data entry.

Query language - the method of formulating queries in an information retrieval system to retrieve data. A query language builds search specifications using relational and logical operators. Relational and logical operators compare expressions that make up the search specification.

{Home > Information Processes and Technology > Information Systems and Databases}