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
- What is Data Independence in DBMS in Hindi
- Database Languages and Interfaces in DBMS in hindi
- Functions of Database Administrator (DBA) in DBMS in Hindi
- ER Data Model in DBMS in Hindi | Entities and Attributes in DBMS in Hindi
- What is an Entity in DBMS in Hind | Entity type in DBMS in Hindi | what is Entity set 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
- What is Data Model in DBMS in Hindi | Types of Data Models in DBMS in Hindi
- What is DBMS in Hindi | What is Database Management System in Hindi | Introduction of DMBS in Hindi
- Characteristics of Database Management System | Characteristics of DBMS in Hindi
- Advantages and Disadvantages of Database Management System in Hindi
- Types of Databases in Hindi
- Three Schema Architecture of DBMS in Hindi