Schema Diagrams

DBMS: Schema Diagrams
Topics discussed:
1. Analogy to understand the need for schema diagrams.
2. Theoretical aspects of schema diagrams.
3. Difference between schema diagram and ER diagram.
4. Example schema diagram pertaining to the University database.
Follow Neso Academy on Instagram: @nesoacademy(bit.ly/2XP63OE)
Contribute: www.nesoacademy.org/donate
Memberships: bit.ly/2U7YSPI
Books: www.nesoacademy.org/recommend...
Website ► www.nesoacademy.org/
Forum ► forum.nesoacademy.org/
Facebook ► goo.gl/Nt0PmB
Twitter ► / nesoacademy
Music:
Axol x Alex Skrindo - You [NCS Release]
#DBMSByNeso #DBMS #SchemaDiagrams

[@sreyashtari6824]

I recognised this sir by his voice, saved me an year ago in CN , now same with DBMS , thank you sir, grateful to have people like you on RUclips

[@Unknown-ck7fi]

Do not stop , plz.DataBase has become exciting

[@hanzalamansoor]

Explanation is clean 👍

[@myintzumaung814]

Thank u for every vd u posted

[@VISHAGANVLOGS3752]

Crystal clear sir

[@JitendraSingh-qd7jk]

You guys are really epic>>>

[@nikolastheodorou6373]

Can you make a video tutorial converting ER diagram to Schema Diagram?

[@monicabhattacharya9029]

Please upload videos on this course

[@user-nh1ph2no9v]

Thank❤you

[@user-lm3yw6gg9r]

which type of schema diagram is it, relational schema or database schema

[@TrendingShortS00313]

sir your lecture is like Video Format of Database System Concepts by.(Abraham silberschataz,henry and S.sudarshan)

[@gadwalsamson7426]

Hi , how to i get your full course of data structure and discreet mathematics and others gate and UGC net concept please give me permission

[@eminence_Shadow]

Study from books

[@eminence_Shadow]

Follow neso academy

[@sathya9494]

In previous video u said we cannot define more than one primary key in single table sir? But here we are defining

[@bullpuppy7455]

Multiple columns in a table can contribute to the overall Primary Key. For example, in the Classroom table he has 'building' and 'room_no' working together to form the primary key. So you can have the same building # listed, as long as each of the room #'s are unique within that building. Similarly, the same room # can be used, but only if that room # appears in unique building #'s.
So, when the two columns are combined, the following entries are each unique within the table:
Building 1, Room 1
Building 1, Room 2
Building 2, Room 1
Building 2, Room 2
Since the 2 columns work together as the Primary Key, you could NOT have:
Building 1, Room 1
Building 1, Room 1 (