Define database instance

Database Instance and Schema

Instance: Collection of data stored in the database at a particular moment is called an Instance of the database.

For example, if we execute the following SQL query the result produced is one instance;

SELECT * FROM Student;

Schema: The overall design of the database is called the database Schema. In other words, it is the entity sets and attributes.

For example, the following representation is called as schema.

STUDENT (RegNo, Name, DOB, Gender, Phone)

In some representation, the schema sometimes shown with the type and size of attribtues.  

*********

Go to Database glossary page

Go to Database introduction and conceptual modelling 2 mark questions page

Define database instance

Define database schema

What is database instance?

What is schema?

Example of database schema

Example of database instance