I.T U2 Module 1 Objective 1

Fields

Fields/column/attributes refer to a set of values arranged in a table and has the same data type.

Records

Records/rows in a database refer to a group of related data with the same structure.

Tables

A collection of related records and fields structured into rows and columns.

Database

A database is an organized collection of data. It can be computerized but can also be manual.

Database Management System

Database management systems is a collection of software tools used for the manipulation and creation of databases. It allows users to create, update and query databases efficiently by reducing data redundancy and ensuring data integrity.

Relational database

A type of database that organizes data into rows and columns, which collectively form a table where the data points, are related to each other.

Data Mining

sorting through data to identify patterns and establish relationships.

Data Warehousing

development of systems to extract data from operating systems plus installation od a warehouse database system that provides managers a flexible access to data.

Data Redundancy

Data redundancy refers to repeated data.

Data Integrity

Data integrity is the accuracy, consistency, and reliability of data throughout its lifecycle, ensuring that it remains complete, unaltered, and trustworthy.

• the property of data that when satisfied requires every value of one attribute of a table to exist as a value of another attribute in a different or same table.
  This rule is also there to ensure that the rules of the database are followed.
  E.g. you cannot add a payroll record for someone whose record is not present in the employee table.