Instance and Schema in DBMS in Hindi
Instance and Schema in DBMS in Hindi
DBMS Schema
Definition of schema:
किसी Database का Design Schema कहलाता है। Schema तीन प्रकार के होते है :
1. Physical schema,
2. logical schema
3. view schema
For example:
following diagram में, हमारे पास एक schema है जो दिखाता है 3 Table के बीच Relation: Course, Student and Section। diagram केवल Database का Design दिखाता है, यह उन में मौजूद Data को नहीं दिखाता है table। Schema Database का केवल एक structural view (design) है जैसा कि इसमें दिखाया गया है
DBMS Instance :
Definition of instance:
Database में एक particular moment में stored Data को Database का Example कहा जाता है। Database Schema variable को define करता है
Related Post
- DBMS And RDBMS concepts in Hindi (Database Management System in Hindi)
- DBMS Concepts And Architecture Introduction in Hindi
- Database Approach v/s Traditional File Accessing Approach in Hindi
- Advantages of Database Management System in Hindi
- Data Models in DBMS in Hindi
- Instance and Schema in DBMS in Hindi
- Database Languages and Interfaces in DBMS in hindi
- Functions of Database Administrator (DBA) in DBMS in Hindi
- Generalization, Specialization and Aggregation in ER Model in Hindi
- Converting ER Diagram to tables in DBMS in Hindi | Reduction of ER diagram to Table in Hindi
- Characteristics of Database Management System | Characteristics of DBMS in Hindi
- Types of Databases in Hindi
- Three Schema Architecture of DBMS in Hindi