Question

Differentiate between Database state and database schema.

Answer 1

• Database State/Instance: The data stored in the database at a particular moment time of time i.e. the state of the database at a particular instance of time, is called an instance of the database.
• Database Schema: The logical structure and design of a database are called the database schema. It is the blueprint or skeleton structure of a database.

Answer 2

	Database Schema	Database State
1.	It is the overall description of the database.	It is the collection of information stored in a database at a particular moment.
2.	The schema is same for the whole database.	Data in instances can be changed using addition, deletion, and updation.
3.	Does not change Frequently.	Changes Frequently.
4.	Defines the basic structure of the database i.e. how the data will be stored in the database.	It is the set of Information stored at a particular time.