Lec-5: What is Schema | How to define Schema | Database management system in Hindi
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.
👉Subscribe to our new channel:https://www.youtube.com/@varunainashots
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.
0:00 - Introduction
0:24 - Schema in DB
2:16 - Logical representation
2:55 - Implementation of Schema
In the video you will get knowledge about Schema in DBMS, What is Schema, Why we use it, Schema Kya hota. All the points explained with real life examples.
â–º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
