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
Related Post
DATABASE LANGUAGES IN DBMS
Database Languages are used to create and maintain database. Today almost all RDBMS(MySql, Oracle, Infomix, Syba ... 
DATA INDEPENDENCE IN DBMS
Data Independence is the capacity to modify a scheme definition in one level without affecting a scheme definiti ... - Codd's 12 rules in DBMS
Codd's twelve rules are a set of thirteen rules (numbered zero to twelve) proposed by Edgar F. Codd, a pioneer of the ...
DBMS-TRANSACTION MANAGEMENT
INTRODUCTION
A transaction is a collection of logical operations which occurs in a database.It is executed as ... 
DATABASE MODELS IN DBMS
A database model is a type of data model that determines the logical structure of a database and fundamentally deter ...
