Lec-5: What is Schema | How to define Schema | Database management system in Hindi

Name: Lec-5: What is Schema | How to define Schema | Database management system in Hindi
Uploaded: 2018-07-30T10:07:15.000Z
Duration: 8 min 34 s

What is Schema in a Database?

Introduction to Schema

The speaker introduces the topic of schema in databases, emphasizing its simplicity yet importance across various contexts and questions related to databases.

Definition of Schema

A schema is defined as a logical representation of a database, contrasting with the physical storage of data on hard drives or backend servers.

Logical Representation in RDBMS

In Relational Database Management Systems (RDBMS), data is logically represented through tables or relations, such as entities and their relationships in an Entity-Relationship (ER) model.

Designing a Student Schema

The speaker illustrates how to design a schema for a student entity, highlighting attributes like roll number, name, and address that form the structure of this entity.

Course Schema Design

Similarly, when designing a course schema, key attributes include course ID, course name, and duration. This showcases how different entities can be structured logically.

Implementation of Schema

Conceptual vs Physical Representation

The distinction between logical representation (tables with attributes like roll number and name) versus physical storage on hard disks is discussed.

Three-Schema Architecture

The three-schema architecture includes a middle layer known as the conceptual schema which represents data logically.

SQL Implementation

To implement schemas practically, SQL (Structured Query Language), particularly Data Definition Language (DDL), is utilized for commands like create table, alter table, or drop table.

Summary of Key Points

Playlists: DBMS (Database Management system) Complete Playlist

Video description

A database schema defines how data is organized within a relational database; this is inclusive of logical constraints such as, table names, fields, data types, and the relationships between these entities. -------------------------------------------------------------------------------------------------------------------------------------- Timestamps: 0:00 - Introduction 0:24 - Schema in DB 2:16 - Logical representation 2:55 - Implementation of Schema -------------------------------------------------------------------------------------------------------------------------------------- 🔹 Gate Smashers Shorts: Watch quick concepts & short videos here: https://www.youtube.com/@GateSmashersShorts 🔹 Subscribe for more shorts and motivational content: https://www.youtube.com/@varunainashots ►Database Management System(Complete Playlist): https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y Other subject-wise playlist Links: -------------------------------------------------------------------------------------------------------------------------------------- ►Design and Analysis of algorithms (DAA): https://www.youtube.com/playlist?list=PLxCzCOWd7aiHcmS4i14bI0VrMbZTUvlTa ►Computer Architecture (Complete Playlist): https://www.youtube.com/playlist?list=PLxCzCOWd7aiHMonh3G6QNKq53C6oNXGrX ► Theory of Computation https://www.youtube.com/playlist?list=PLxCzCOWd7aiFM9Lj5G9G_76adtyb4ef7i ►Artificial Intelligence: https://www.youtube.com/playlist?list=PLxCzCOWd7aiHGhOHV-nwb0HR5US5GFKFI ►Computer Networks (Complete Playlist): https://www.youtube.com/playlist?list=PLxCzCOWd7aiGFBD2-2joCpWOLUrDLvVV_ ►Operating System: https://www.youtube.com/playlist?list=PLxCzCOWd7aiGz9donHRrE9I3Mwn6XdP8p ►Structured Query Language (SQL): https://www.youtube.com/playlist?list=PLxCzCOWd7aiHqU4HKL7-SITyuSIcD93id ►Discrete Mathematics: https://www.youtube.com/playlist?list=PLxCzCOWd7aiH2wwES9vPWsEL6ipTaUSl3 ►Compiler Design: https://www.youtube.com/playlist?list=PLxCzCOWd7aiEKtKSIHYusizkESC42diyc ►Number System: https://www.youtube.com/playlist?list=PLxCzCOWd7aiFOet6KEEqDff1aXEGLdUzn ►Cloud Computing & BIG Data: https://www.youtube.com/playlist?list=PLxCzCOWd7aiHRHVUtR-O52MsrdUSrzuy4 ►Software Engineering: https://www.youtube.com/playlist?list=PLxCzCOWd7aiEed7SKZBnC6ypFDWYLRvB2 ►Data Structure: https://www.youtube.com/playlist?list=PLxCzCOWd7aiEwaANNt3OqJPVIxwp2ebiT ►Graph Theory: https://www.youtube.com/playlist?list=PLxCzCOWd7aiG0M5FqjyoqB20Edk0tyzVt ►Programming in C: https://www.youtube.com/playlist?list=PLxCzCOWd7aiGmiGl_DOuRMJYG8tOVuapB ►Digital Logic: https://www.youtube.com/playlist?list=PLxCzCOWd7aiGmXg4NoX6R31AsC5LeCPHe --------------------------------------------------------------------------------------------------------------------------------------- Our social media Links: ► Subscribe to us on YouTube: https://www.youtube.com/gatesmashers ►Subscribe to our new channel: https://www.youtube.com/@varunainashots ► Like our page on Facebook: https://www.facebook.com/gatesmashers ► Follow us on Instagram: https://www.instagram.com/gate.smashers ► Follow us on Instagram: https://www.instagram.com/varunainashots ► Follow us on Telegram: https://t.me/gatesmashersofficial ► Follow us on Threads: https://www.threads.net/@gate.smashers -------------------------------------------------------------------------------------------------------------------------------------- ►For Any Query, Suggestion or notes contribution: Email us at: gatesmashers2018@gmail.com #Schema#SchemaSQL#DBMS#gate#ugcnet#nielit#dsssb#collegeUniversityexams