[SARAL GYAN] : E-R Model to Relational Model Mapping

This video will facilitate the viewers about the steps required to convert an Entity Relational Model (E-R Model) into a Realtional Model or How we can create tables from an E-r Model. The viewers may leave their queries in the comment box.

[@SARALGYAN_pkumar]

Thanks everyone for your likes and comments 😀😀

[@shashiram9889]

Thanks doc ...white board would be appreciated

[@lakshjeetpandit1817]

The Best. I repeat “The Best” explanation on this topic.

[@shafinsarwar6448]

Best video of Relational Model Mapping on internet...

[@SARALGYAN_pkumar]

Thanks Shafin

[@sachthadani292]

A much underrated video, I had watched almost 5 videos before this and didn't understood anything, but this made a lot of concepts clear

[@devesh819]

This was the best and the complete video on er diagram that i watched uptill now . Thanks for it .
I am blessed that I watched it .

[@SARALGYAN_pkumar]

Thanks

[@sandeeps6997]

Sir this video really helped me a lot in understanding the concepts of the relational model mapping. Thanks a lot for making an such a useful video sir...:)

[@sankethb.k642]

Was looking for this kind of video and found yours , this is exactly what I wanted. Thank you sir.

[@SARALGYAN_pkumar]

Thanks dear

[@Aleem533]

Wow! Great sir, happy to see this informative channel. Very well explained 👏

[@prasannavenkatesh9856]

Great detailed explanation sir.. Thank you🙏

[@GovindKumar-xj9yw]

Such a graceful explanation 🙏

[@apoorvsharma6932]

thank you sir. Precise explanation

[@Sanguine3466]

Sir this was very helpful 🙂.... This helped me a lot , all the cocepts are clear now 🤗 Thankyou so much.

[@PMARQS]

this lecture is very good if we learn it with intrest i like it

[@muskandodmani3579]

Thanks a lot sir for such a helpful video!!

[@shubhamladha0337]

Very helpful...was searching for this kind of video on this topic.

[@usmanrahat4785]

Thank you so much.
Please discuss the case of 1:N (with both sides are partial participation) and 1:N (with Total Participation only on side1).

[@shrivatsarao9481]

Best tutorial for relational schema

[@083samarthgupta9]

Very helpful video...Each and every seconds of video are important.Covers all important things which required for creating table.Thank you so much

[@SARALGYAN_pkumar]

Thanks dear

[@babashankarsn1477]

Crystal clear explanation

[@srvgr8]

One of the most relevant video for understanding er to relation model.

[@SARALGYAN_pkumar]

Thanks

[@yevgeniydiriyenko4457]

I wasted about six hours scavenging the internet for pictures and texts or slides about certain special cases and scenarios trying to solve 1 problem. I was still left confused. However after watching this video solving the problem in together with studying this video only took me about an hour.

[@pallavihs6904]

Really superb sir well explained!!!!!
I was really understanding each line , u made it easy for us.
Every line was very clear.
Thanks a lot sir

[@SARALGYAN_pkumar]

Thanks

[@devikasathyan1333]

great video sir 🙏

[@bigunhettiarachchi853]

It helped me a lot
Thanks

[@cb350_]

Best tutorial for ER to relational mapping.

[@SARALGYAN_pkumar]

thanks

[@kushagratomar5896]

Sir apne bhahot achese sikha diya

[@SARALGYAN_pkumar]

Thanks

[@nirbhay6638]

You explained the concept in a very precise and easy way.Thank you sir!

[@SARALGYAN_pkumar]

Thanks

[@vigneshchenna555]

What is there exists a one-to-one relationship between two entities, and the relationship between them has one or many attributes, then how do we represent them as a relational schema?

[@amruthapoojary3928]

Full descriptive explanation thank you sir.☺️

[@SARALGYAN_pkumar]

Thanks Amrutha 😊

[@AdarshKumar-nb4kj]

Best video ever on relational model 🙏🙏

[@SARALGYAN_pkumar]

Thanks Adarsh

[@AdarshKumar-nb4kj]

@@SARALGYAN_pkumar sir can u have another video on EER DATABASE TO RELATIONAL MODEL 🙏🙏

[@parthwaghmare468]

Thank you for sharing this mapping knowledge💯📖📚📝 this will definitely help me in exams

[@SARALGYAN_pkumar]

Thanks

[@mansijoshi4938]

Thank you for helping us out during our exams 🙏

[@SARALGYAN_pkumar]

Thanks

[@priyanjali2857]

Thank you thank you thank you verrrrryyy muchhhh

[@SARALGYAN_pkumar]

Thanks

[@hinaasghar6298]

JazakAllah..Clearly explained

[@SARALGYAN_pkumar]

Thanks

[@shashiram9889]

Perfect and easy explanation

[@SARALGYAN_pkumar]

Thanks Navdeep

[@sammunta1543]

thanks alot sir ,no need to tell me to subscribe this channel ,i have done it already kkkkkk i like this video
more especially on mapping 1to 1,N, and M to N .our Lecturer missed them

[@gowthamisupriya6952]

Thanks ..this lecture helps me a lot for my exam

[@SARALGYAN_pkumar]

Thanks

[@171KAMLESH]

Really it is conceptual ............

[@brincykuriakose8445]

video is more effective .....thank u so much ....

[@SARALGYAN_pkumar]

Thanks dear

[@Robin-me7nv]

Very nice way to make us understand ....... sir please make a video for EER to Relational Model as well.

[@SARALGYAN_pkumar]

Soon I will upload

[@ramadaskamat6418]

Very helpful video sir

[@PMARQS]

the method of learning is very intresting

[@SARALGYAN_pkumar]

Thanks Adnan

[@dhaneshpt8641]

Thank you sir.

[@bebo3552]

devru ;) thanks

[@c.o.dmobile5061]

Thank you Sirr 💜💜

[@ua2324]

thank you 👍❤️❤️❤️

[@nehauk5241]

Thank you sir it was very helpful ♥️

[@SARALGYAN_pkumar]

Thanks Neha

[@deepikasharma7996]

COMPLETE DESCRIPTIVE INFORMATION ☑

[@trjaka]

Perfect !

[@SARALGYAN_pkumar]

Thanks

[@uzairrashid7724]

good job! it looks awesome video and it makes me understand the topic very well. now I would like to have the presentation file .. please share the link.

[@SARALGYAN_pkumar]

Thanks dear

[@161tashleenkaur6]

This video is just amazingggggg

[@SARALGYAN_pkumar]

Thanks

[@GauravGupta-zw7hz]

ThankYou Sir!

[@SARALGYAN_pkumar]

Thanks Gaurav

[@srikanthd3480]

superb Explanation......

[@SARALGYAN_pkumar]

Thanks srikanth

[@rishhh3217]

Superb explanation 😄

[@SARALGYAN_pkumar]

Thanks Rishabh

[@shahariarsarkar3433]

Sir, I have a question.. please clarify it... The total participation and partial participation are not considerable in 1:N relationship. Because, if the relationship is in 1:N then 1 side primary key will be the foreign key of N side. Is it Right? If the total participation in the 1 side and partial participation in the N side, what should be done?

[@shrutiiyer5824]

hello.. can you put more videos on dbms like for sql or for normalization etc.
this video helped me a lot
thank you :)

[@SARALGYAN_pkumar]

Thanks.
ruclips.net/video/_WQ3_6yecko/видео.html

[@SARALGYAN_pkumar]

Check this video on FDs

[@_reddyr2530]

Thank you so much sir🙏

[@SARALGYAN_pkumar]

Thanks dear

[@vatsaldoshi7282]

Best video out there

[@SARALGYAN_pkumar]

Thanks😊

[@pankajkalam3182]

When cardinality is written in min max form
What should one do for relational database mapping

[@SARALGYAN_pkumar]

If cardinality is given in Min-Max form then very easily it can be represented into 1:N, 1:1, N:1 and M:N

[@DAIS_AnishBKakathkar]

Well explained

[@SARALGYAN_pkumar]

Thanks

[@shahariarsarkar3433]

Sir, If there is any Generalization and Specialization What show we do to convert that?.

[@SARALGYAN_pkumar]

This video is for the ER model to Relational model conversion. Generalization and Specialization are used in the EER model. There are some rules for EER to Relational model as well:
Rule 1: If we have total or partial generalization/specialization relationships as well as
disjoint or overlap generalization/specialization relationships.
Rule 2: If there is total or full
participation between the superclass and the subclasses or there is a disjoint relationship
Rule 3: if there is a disjoint relationship between the superclass and subclasses
Rule 4: General rule for both overlap and disjoints
Hopefully, I will create and post the video on that soon.

[@shahariarsarkar3433]

@@SARALGYAN_pkumar Thanks a lot sir.

[@nandinipanchani3717]

Sir can you make series for file organization?? I have doubt in it please.... 🙏

[@SARALGYAN_pkumar]

I am planning for it.

[@RoshanKumar-yd5xg]

Best video

[@SARALGYAN_pkumar]

Thanks

[@C__FahadMunna]

joss

[@anupamachaubey159]

Nice video sir

[@SARALGYAN_pkumar]

Thanks dear

[@be_13_rahulprajapati73]

Please upload more videos on dbms🎉

[@be_13_rahulprajapati73]

Thank you sir 👍

[@fitnessfounders504]

Sir make video for EER too

[@SARALGYAN_pkumar]

Soon

[@faizalam5706]

Hello sir, can you answer this
Can you answer this question:
Q:design the relational schema for E-R diagram that you have drawn for part question
enter about 5 sets of meaningful data in each of the relations
identify the domain of various attributies

[@SARALGYAN_pkumar]

Dear,
domain means the range and type of values an attribute can store.
E.g. if data type of an attribute is Number, so it can hold only digits from 0 to 9.
So as per the domain of the attributes, fill the values in the tables which you will get after converting er model into relational model.

[@muhammadkashif2239]

sir these slide give me

[@jamesmorgan4019]

The only video on UTUBE which I understood 😑
Other channels should die 😑

[@SARALGYAN_pkumar]

Thanks a lot

[@laxmimuttennavar3872]

Thank you sir, your explanation is great

[@SARALGYAN_pkumar]

Thanks