Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
A. Relation, Domain
B. Relation, Schema
C. Instance, Schema
D. Schema, Instance

Respuesta :

Lanuel

Answer:

D. Schema, Instance.

Explanation:

Database schema, which is the logical design of the database, and the database instance, which is a snapshot of the data in the database at a given instant in time.

In database management, the term "schema" is used to denote a representation of data while the term "instance" is used to denote an instance of time.

A database schema is a structure which is typically used to represent the logical design of the database and as such represents how data are stored or organized and the relationships existing in a database management system. There are two (2) main categories of a database schema; physical database schema and logical database schema.

A database instance is a snapshot of the data in the database at a given instant in time and as such represents an operational database by following the conditions, validation and constraints set for a database management system.