Schemas versus Instances

• Database Schema: The description of a database.
Includes descriptions of the database structure, data types, and the constraints on the database.
• Schema Diagram: An illustrative display of (most aspects of) a database schema.
• Schema Construct:
A component of the schema or an object within the schema, e.g., STUDENT,
COURSE.
• Database State: The actual data stored in a database at a particular moment in time. This includes the collection of all the data in the database. Also called database instance (or occurrence or snapshot).

• The term instance is also applied to individual database components, e.g. record instance, table instance, entity instance

0 comments