Schema And Instance In DBMS With Examples

Schema And Instance In DBMS Explain With Examples, What Is Schema, What Is Instance, Difference Between Schema & Instance  

SCHEMAS AND INSTANCES

The description of a database is called the database schema, which is specified during database design and is not expected to change frequently.

The collection of information stored in the database at a particular moment is called an instance of the database. It changes very frequently than the schema.

Examples:

Schema:
Student(studno,name,address)
Course(courseno,lecturer)

Instances
Student(123,Bloggs,Woolton)
       (321,Jones,Owens)

Tweet