Definition of schema

Design  Plan of a database is known as the schema. Composition is of three sorts: Physical schema, logical schema and view schema.

The outline of a database at physical level is called physical schema, how the information put away in squares of capacity is portrayed at this level.

Outline of database at logical level is called logical schema, software engineers and database managers work at this level, at this level information can be portrayed as specific sorts of information records gets put away in information structures, however the inward points of interest, for example, usage of information structure is covered up at this level (accessible at physical level).

Plan of database at view level is called view schema. This by and large depicts end client connection with database frameworks.