Describe the differences in meaning between the terms relation and relation schema.

Question

Computers & Technology

Ulises Sosa

9 May, 06:11

Describe the differences in meaning between the terms relation and relation schema.

+4

Answers (1)

Know the Answer?

Dalia Carrillo · Answer 1

Relational Schema refers to meta-data elements which are used to describe structures and constraints of data representing a particular domain. A relation abide of a heading and a body. A heading is a set of attributes. A body is a set of n-tuples. The heading of the relation is also the heading of each of its tuples.

Explanation:

Defination of relation:

A relation is a property or predicate that ranges over more than one argument

A relation is defined as a set of n-tuples. In both mathematics and the relational database model, a set is an unordered collection of items. In mathematics, a tuple has an order, and allows for duplication.

Relation schema

A relation schema is a collection of meta-data that describes the relations in a database. Which is also called data base schema. This schema can be described as the "layout" of a database or the blueprint that outlines the way data is organized into table.