Scribd
Upload
31 views1 page

Relational Model Concepts in DBMS

The relational model represents a database as a collection of relations, where each relation is a table with rows (tuples) and columns (attributes). A tuple represents related data values across attributes, with each attribute having a domain that specifies the type of values allowed in that column. A domain is a set of indivisible atomic values from which the data types populating each attribute are drawn.

Uploaded by

kavitha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
31 views1 page

Relational Model Concepts in DBMS

The relational model represents a database as a collection of relations, where each relation is a table with rows (tuples) and columns (attributes). A tuple represents related data values across attributes, with each attribute having a domain that specifies the type of values allowed in that column. A domain is a set of indivisible atomic values from which the data types populating each attribute are drawn.

Uploaded by

kavitha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Relational Model Concepts

The relational model represents the database as a collection of relations

relation is thought of as a table of values, each row in the table represents a collection of related
data values.
a row is called a tuple, a column
header is called an attribute, and the table is called a relation. The data type
describing the types of values that can appear in each column is represented by a
domain of possible values. We now define these terms—domain, tuple, attribute,
and relation—formally. Attributes
Relation

tuples

Domain
A domain D is a set of atomic values. By atomic we mean that each value in the
domain is indivisible as far as the formal relational model is concerned. A common
method of specifying a domain is to specify a data type from which the data values
forming the domain are drawn

You might also like