Relational Model Concepts In DBMS Explain With Example, Tuple, Attribute, Relation In DBMS Explain
The relational model represents the database as a collection of relations.
Each relation resembles a simple table, having a set of rows and set of columns.
Each relation consists of a relational schema and relational instance.
In the formal language terminology,
Row is called as- tuple
Column header is called as-attribute
Table is called as-relation
The data type describing the types of values that can appear in each column is called a domain.
The number of attributes in a relation is the degree of a relation.
The number of tuples in a relation is called the cardinality of that relation.
Relation schema(R) is the description about the structure of any relation.
Relation state(r) is the data in the relation at any moment of time.
0 comments:
Post a Comment
Thanks For Your Comment. We Get Back To You As Soon As Possible.