Lecture 7: Relational Model Explained || DBMS for Placements

Lecture 7: Relational Model Explained || DBMS for Placements

This Video gives a glimpse of Relational Model in DBMS There is a lot to learn, Keep in mind “ Mnn bhot karega k chor yrr apne se nahi hoga ya maza nahi aara, Just ask 1 question “ Why I started ? “ Visit Crio: https://www.crio.do/redeem/fc944a7/ Notes & Slides Link: https://drive.google.com/drive/folder... Discord Server Link:   / discord   Do provide you feedback in the comments, we are going to make it best collectively. Connect with me here: Instagram:   / lovebabbar1   Twitter:   / lovebabbar3   Telegram Group Link: Love Babbar CODE HELP https://telegram.me/lovebabbercodehelp Connect with Lakshay: Instagram: https://www.instagram.com/lakshayk12/... LinkedIn:   / lakshay-kumar-368a06146   My Editor: https://www.instagram.com/rishu.rsing... Intro Sequence: We have bought all the required Licenses of the Audio, Video & Animation used. TimeStamps: 00:00 - Introduction 00:35 - Promo 01:27 - What is Relation, its attributes, tuple? 05:00 - Degree of a relation 05:10 - Cardinality of a relation 05:37 - Designing Database schema using ER model and Relational Model 08:15 - What are RDBMS? 11:50 - Properties of Relation/Table in Relational Model 14:45 - Relational Keys, Super Key, Candidate Key, Primary Key, Alternate Key. 21:00 - What is Foreign Key? 27:17 - Composite Key, Compound Key 27:50 - What is Surrogate Key? 30:00 - Why Integrity Constraints? 33:20 - Domain Constraints 34:00 - Entity Constraints 34:22 - Referential Constraints 42:15 - Can Foreign Key have NULL values? 45:05 - Key Constraints #DBMSBusted #LoveBabbar #Lakshay