top of page
Data on a Touch Pad

RDBMS FUNDAMENTALS

COMPONENTS OF DATABASE SYSTEM

components.JPG

Data

o    Data are raw, facts and figures that cannot identify an object uniquely.
o    It is the plural form of the Latin word datum.
o    Data are collected by systematic survey or review on a particular activity.
o    It can be represented by a name, number, symbol or character, etc.
o    Example:- sunil, 7, $, etc.

Field

o    A field is a collection of related data.
o    It represents the column of a table.
o    A field is the smallest unit of records of a table.
o    The total number of fields of a table is called as Arity.

field.JPG

Record/Tuple

o    A record is a collection of related field.
o    The row of  a  table is called as record.
o    The total number of records of a table is called as Cardinality.
​

cardinality.JPG

Table/File/Relation

o    A collection of related records is called as file.
o    A table is a relation consists of rows and columns.
o    Rows are called as records and columns are called as fields.
o    A table is a 2D matrix.

relation.JPG

Database

o    A collection of related tables/files/relations is called as database.
o    A database is a collection of huge amount of data stored in tabular format.

Data warehouse

o    A data warehouse is a collection of inter-related database.
o    It is a central repository system that stores huge amount of data.
o    It is also known as go-down of data.
o    A data warehouse store data according to their subject.
o    Example:- Library Information System ( LIS).

Related Topics:

bottom of page