Explain the characteristics of Table in Database Management System?

The relational table’s characteristics are:

• A table is perceived as a two-dimensional structure composed of rows and columns.
• Each table row (also known as tuple) represents a single instance of the entity within the entity set.
• Each column represents an attribute and each column has distinct name.
• Each row/column intersection represents a data value.
• Each table must have an attribute or combination of attributes that uniquely identifies each row.
• All values in a column must confirm to the same data format.
• Each column has specific range of values known as the domain of the attribute.
• The order of rows and columns is immaterial to the DBMS.

To illustrate the characteristics of table, we consider the table of candidates at IT Bank, Inc. The table at present contains information on ten candidates (i.e., 10 rows) each having information on eight attributes (i.e., 8 columns). Each row represents one candidate a single entity occurrence within the entity set. Each column represents an attribute of candidate and that each attribute has distinct name. Each row/column intersection contains only one data value. All the values in a column match entity’s characteristics. For example, CAND_DEGREE column contains only degree entries. Also the order of rows is immaterial to the user. Each row is uniquely identified by one attribute, CAND_NUM. We have following attributes about candidate.

CAND_ID = Candidate identification.

CAND LNAME = Last name of candidate

CAND_FNAME = First name of candidate

CAND MI = Middle name of candidate

CAND_DOB = Date of birth of candidate

CAND_QUA = Qualification of candidate

CAND_MAJOR = major subject of candidate

CAND_EXP = Number of years of experience of candidate