Question

Difference between database schema and database state

Answer 1

A database schema or an intention gives a description of the database. This can be considered as a blueprint of a database, and gives a list of fields in the database with their data types. In other words, it describes the organization and structure of data in a database system, along with the relationships mapped between the entities.

A database state provides the present state of the database and its data. It can be considered as an extension of the database schema. When a database is newly defined, the corresponding database state is empty. Factors that affect a database state are entering, deleting or modifying information in the database.