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
Candidate Table

Tags: Bca

Owlgen
Logo
Enable registration in settings - general
Compare items
  • Total (0)
Compare
0