Database Schema and Instance

DATABASE SCHEMA

• The Database Schema is the description of the organization or structure of a database.
• It is specified during database design and is not expected to change frequently.

DATABASE INSTANCE

• The collection of information stored in the database at a particular moment is called an instance of the database.
• It is also called a database state or snapshot or the current set of occurrences in the database.

ANALOGY OF SCHEMA AND INSTANCE