Notes and Study Materials

Table and its Characteristics:

A table is perceived as a two-dimensional structure composed of rows and columns. A table is also called a relation because the relational model’s creator, E. F. Codd, used the term relation as a synonym for a table. A Table is Primary Component in Relational Data Model.

The characteristics of a relational table are summarized as follows:


1. A table is perceived as a two-dimensional structure composed of rows and columns.

2. Each table row (tuple) represents a single entity occurrence within the entity set.

3. Each table column represents an attribute, and each column has a distinct name.

4. Each row/column intersection represents a single data value.

5. All values in a column must conform to the same data format.

6. Each column has a specific range of values known as the attribute domain.

7. The order of the rows and columns is immaterial to the DBMS.

8. Each table must have an attribute or a combination of attributes that uniquely identifies each row. 

 

You may also like:

Basic notations of ER diagram

Types of Keys in DBMS

Integrity Rules in DBMS

Relational Set Operaotrs

Codd’s Relational Database Rules

Back to DBMS Questions

 

 

 

 

Search

On Screen Facebook Popup by Infofru

Receive all updates via Facebook. Just Click the Like Button Below

Close