Dbms schema & instance

This PPT is database management system schema and instance.

1. DBMS Schema and Instance

2. DBMS Schema and Instance DBMS Schema : - The overall description of the database is called DBMS Schema. OR The Logical representation of database is called DBMS Schema. RDBMS Roll Name Age 11 Papan 18 SQL Example :

3. DBMS Schema and Instance DBMS Sub-Schema : - Sub-schema is used to create very different and personalized view of the Same data. DBMS Schema Sub-Schema Sub-Schema User-1 User-2 User-3 Roll Name Age 11 Papan 18 Name Papan Example :

4. DBMS Schema and Instance DBMS Instance : - The data stored in a database at a particular moment is called Instance of the database. Date : 1/1/2019 Student Table : Records = 50 Date : 1/2/2019 Student Table : Records = 300