by Dinesh Thakur

Relation schema:

A set of attributes is called a relation schema (or relation scheme). A relation schema is also known as table schema (or table scheme). A relation schema can be thought of as the basic information describing a table or relation. It is the logical definition of a table. Relation schema defines what the name of the table is. This includes a set of column names, the data types associated with each column.

Relational schema:


 Relational schema may also refer to as database schema. A database schema is the collection of relation schemas for a whole database. Relational or Database schema is a collection of meta-data. Database schema describes the structure and constraints of data representing in a particular domain. A Relational schema can be described a blueprint of a database that outlines the way data is organized into tables. This blueprint will not contain any type of data. In a relational schema, each tuple is divided into fields called Domains.

 

There are different kinds of database schemas:

 

  • Conceptual schema
  • Logical schema
  • Physical schema