IT Fundamentals Managing a Database

Database

is a collection of data organized in a manner that allows access, retrieval and use of data.

Data

is a collection of unprocessed items, which can include text, numbers, images, audio a and video.

Database software

it is a computerized database that can add, modify and delete data in the database, sort and retrieve data, create forms and reports from the data in the database.

Garbage In Garbage Out(GIGO)

is a computing phrase that points out the accuracy of a computer's output depends on the accuracy of the input.

Character-Fields-Records-File

Hierarchy of Data

Character

it represent a single character which can be a number, letter, space, punctuation mark or other symbol.

Fields

is a combination of one or more related characters or bytes and is the smallest unit of data.

Records

is a group of related fields.

File

is a collection of related records stored on a stored on a storage medium.

File maintenance

refers to the procedures that keep data current.

Validation

is the process of comparing data with set of rules or values to find out if the data is correct.

Form (data entry form)

is a window on the screen that provides areas for entering or modifying data in a database.

Report generator(report writer)

allows users to design a report on the screen, retrieve data into the report design and then display or print the report.

Relational database

is a database that stores data in tables that consist of rows and columns.

relationship

is a link within the data.

Object Oriented database(OODB)

stores data in object.

object

is an item that contains data as well as the actions that read or process the data.

Multidimensional databases

stores data in dimensions. It can store more than two dimensions of data