What Is an Instance of a Database? (Schema vs. Data vs. State)

In database systems, the term instance is primarily about the current state (data contents) of the database—not the logical design (schema) and not the design-time “complete set of attributes” as a definition. In standard database modeling, a database instance corresponds to the state of the database at a given point in time and changes as tuples are inserted/updated/deleted.

A concise way to see this is the classic separation:

• schema defines what can exist.
• instance defines what does exist now.
• relational instance is the data at that moment.

Below, we evaluate each option (i)–(iv) in the question by mapping it to schema vs instance vs data-time state.

Key definitions used to solve the multiple-choice item

• logical design
• relation
• tuple
• database state

With these, an instance is best understood as:

the entire set of relation contents (tuples/values) across the database at some time $t$.

$$\text{Instance at time } t = \bigcup \{\text{relation instances of all relations at } t\}$$

Evaluating the given options (i)–(iv)

(i) The logical design of the database system

This is logical design (the schema).

• It describes the structure and rules.
• It does not describe the actual data values currently stored.

✅ Conclusion: Not an instance—it is the schema.

---

(ii) The entire set of attributes of the database put together in a single relation

This describes a particular relational schema form (a relation’s attributes set), i.e., structure such as:

• attribute names
• possibly their types
• constraints

But an instance requires the actual tuples (data values) that populate relations.

✅ Conclusion: Not an instance—this is still about schema/structure.

---

(iii) The state of the database system at any given point of time

This directly matches the standard meaning of database state and therefore instance.

If we model the database as a set of relations $R_1, R_2, \dots, R_n$, then an instance at time $t$ is the set of relation instances:

$$I(t)=\{(R_1)_t,(R_2)_t,\dots,(R_n)_t\}$$

✅ Conclusion: This is an instance.

---

(iv) The initial values inserted into the database immediately after its creation

Immediately after creation (and initial inserts), the database does have a particular data state—so those initial values are indeed an instance at that specific time.

However, compared with option (iii), option (iv is only one special moment (right after creation), whereas “instance” is typically defined as the database state at any point in time.

✅ Conclusion: An instance at that specific time, but not the best general definition.