1.7- Schemas And Instance In DBMS In Hindi | What Is Schema In Database | dbms course online
1.7- Schemas And Instance In DBMS In Hindi | What Is Schema In Database | dbms course online
PLAYLIST:
DBMS - Data Base Management System Tutorials In Hindi | GATE- NET- DBMS Lectures in Hindi
• DBMS Complete Syllabus- All University exa...
gate database questions,
#DBMStutorials
#GateDbmsLectures
#NetDbmsLectures
gate database lectures,
ugc net dbms questions and answers,
ugc net dbms previous question papers,
ugc net dbms tutorial,
gate dbms lectures,
dbms gate tutorials in hindi,
difference between instance and schema,
Difference between Schema and Instance in DBMS
1. Instances :
Instances are the collection of information stored at a particular moment. The instances can be changed by certain CRUD operations as like addition, deletion of data. It may be noted that any search query will not make any kind of changes in the instances.
Example –
Let’s say a table teacher in our database whose name is School, suppose the table has 50 records so the instance of the database has 50 records for now and tomorrow we are going to add another fifty records so tomorrow the instance have total 100 records. This is called an instance.
2. Schema :
Schema is the overall description of the database. The basic structure of how the data will be stored in the database is called schema.
Schema is of two types: Logical Schema, and Physical Schema.
gate dbms lectures in hindi,
ugc net dbms lectures in hindi,
gate dbms lectures,
ugc net dbms lectures,
gate dbms tutorials in hindi,
ugc net dbms tutorials in hindi,
gate dbms tutorials,
ugc net dbms tutorials,
Logical Schema – It describes the database designed at logical level.
Physical Schema – It describes the database designed at physical level.
Example –
Let’s say a table teacher in our database name school, the teacher table require the name, dob, doj in their table so we design a structure as :
Teacher table
name: String
doj: date
dob: date
Above given is the schema of the table teacher.
Difference between Schema and Instance :
Schema Instance
It is the overall description of the database. It is the collection of information stored in a database at a particular moment.
Schema is same for whole database. Data in instances can be changed using addition, deletion, updation.
Does not change Frequently. Changes Frequently.
Defines the basic structure of the database i.e how the data will be stored in the database. It is the set of Information stored at a particular time.
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready. Notes Link:
http://www.tutorialsspace.com/Downloa...