24
May 10

Relational Theory

The difference between relvar and relation:

A relation is a value, filled with all the attribute and tuple values. On the other hand a relvar is a variable associated with some representation of a relation.

The difference between a base relation and a view:

Base relation is the original value while a view is deducted from it by a certain criteria (select statement).