Sunday, February 11, 2018

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.  

*********




Define database instance
Define database schema
What is database instance?
What is schema?
Example of database schema
Example of database instance

No comments:

Post a Comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery