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 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
Dinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular