Database Structure

Database Structure

Table is the entire collection of related data in one table, referred to as a File or Table where the data is organized as row and column.

Each row in a table represents a record, which is a set of data for each database entry.

Each table column represents a Field, which groups each piece or item of data among the records into specific categories or types of data. Eg. StuNo., StuName, StuAge, StuClass, StuSec.

A Table is known as a RELATION

A Row is known as a TUPLE

A column is known as an ATTRIBUTE