What do you mean by Schema and Instance in DBMS? Explain both with example.

Question

Suresh Chand · Accepted Answer

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 three types: Logical Schema, Physical Schema, and view Schema. Logical Schema – It describes the database designed at a logical level. Physical Schema – It describes the database design at the physical level. View Schema – It defines the design of the database at the view level. Example – Let’s say a table teacher in our database name school, the teacher table requires 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. Instance: Instances are the collection of information stored at a particular moment. The instances can be changed by certain CRUD operations such as addition, or 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 has a total of 100 records. This is called an instance.

What do you mean by Schema and Instance in DBMS? Explain both with examples.

Leave your Answer:

Hits Counter

Question

What do you mean by Schema and Instance in DBMS? Explain both with examples.

Leave your Answer: