ER to Relational mapping- ER diagram conversion into Tables(Relations)-Logical Database Design

This video explains about how to convert ER diagrams into Relations(Logical Database Design)
DBMS Full PlayList
• Introduction to Databa...
Data Structures and Algorithms PlayList
• Data Structures
Deep Learning PlayList
• Introduction to Neural...
Data Analytics Full PlayList
• Playlist
Cryptography and Network Security PlayList
• Introduction to Inform...
#AksharaDeepLearning
#ER to tables conversion
#Logical database design
#ER to relational mapping
#1:1 relationship conversion
#1:N relationship conversion
#Conversion of ER diagram
#M:N relationship conversion
#Relational database design
#gate dbms
#many to many relationship
#Database management systems
#ER diagrams to relational tables conversion
#er diagrams to tables

[@vijayraj6957]

Watching this 2hrs before the exam, Thank you! Saved

[@xsba7]

Thank you so so so muchhhh, tomorrow's my exam and you've been really helpful with explaining

[@abhivishwa112]

What a neat explanation!!
Thank you 🙏

[@MohanDas-ne4ci]

Thank you sir.. You have explained it very well.

[@likhithS2321]

thank you sir! you saved me from the internals

[@artgaming4271]

Excellent work!

[@varadcr8271]

Excellent video. Thank you for making it simple.

[@aksharacsit]

Thank you

[@surenderm6122]

Thank you so much sir, such a great and understanding explanation

[@soapmactavish6001]

explained very well sir, thank you

[@lehaswinipalla3365]

Best video on this topic

[@zulfaharees9272]

Thank you so much sir for this great,clear and well understanding explaination ! It's my exam in 4 days and I was trying a similar question of yours and this video helped me reached far and far. Thank you sir, may god bless you in everything.

[@aksharacsit]

Thank you Harees

[@maheezthariq]

🚶

[@zulfaharees9272]

@@maheezthariq .....!

[@ashishshetty3512]

Lol rookie number ,i have exam in 20 minutes

[@muneebnaeem3918]

You're doing great work Sir. It's really sad to see such low reach. Best of luck for future endeavours

[@aksharacsit]

Thank you Naeem

[@ENagamani-yl1ub]

Thank u for wonderful video😊

[@serhattatas5123]

Great video dude ! 1000x Better than my prof.

[@5pointpulse-75]

Thank you so much! ☺

[@hafsaqaiser8615]

THANK YOU SO MUCH SIR. THIS VIDEO IS VERY HELPFUL FOR ME ... LOVE FROM PAKISTAN 🇵🇰

[@poojashreent629]

Thank you so much sir 🤩

[@MrAqeel_Advice_Motion]

Thank you so much 🥰 Sir

[@tayyabali129]

you are great sir g

[@nikitakarthik9931]

thank you so much

[@oscarwong5226]

Thank you, watching this before my quiz

[@um.e.habiba4903]

Same condition here bro

[@cemilcesur1713]

THANK YOUUU

[@asmij2078]

thank you sir 😄😄

[@user-oj6qd8ie2x]

Thanks sir 👍

[@PODOCAST-TUBE]

Thank you sir

[@oshadhaedirisinghe1455]

Thank you

[@blessy_clicks]

Too perfect sir,awesome

[@aksharacsit]

Thank you

[@user-dm1zy2qj5r]

Well helped

[@jeevanmv4529]

🔥🔥🔥

[@user-ut6jl7jm3s]

Do you have like this video but for other example? Library or hospital or something

[@Mehiko007]

nice

[@mahadsohail7205]

Best explanation w.r.t (Ramez Elmasri, Fundamentals of Database Systems (7 th Edition)) book

[@aksharacsit]

Thank you

[@khalidmuzemil9020]

thank you very very very very very very much sir

[@aksharacsit]

Thank you 🙂

[@akremomer4540]

Yeah it’s really nice of you sir

[@MSDHONI-gd8nr]

DEPENDENTS OF is also 1:N relation but why we haven't included it

[@aksharacsit]

It is already covered while converting weak entity conversion

[@MSDHONI-gd8nr]

@@aksharacsit Thank u sir

[@cs-3-5d8ch.satwik6]

can u provide the text book link what u follow

[@aksharacsit]

Fundamentals of Database Systems
Book by Ramez Elmasri

[@cs-3-5d8ch.satwik6]

@@aksharacsit if u don't mind please provide the text book link for easy download

[@khalidmuzemil9020]

sir I want to ask do we always ignore the derived attribute

[@abduraheemhussein3872]

In ER (Entity-Relationship) mappings, derived attributes are typically not included as separate attributes in the entity model. Derived attributes are calculated or derived from other attributes in the entity, and they do not represent stored data in the database. Instead of including derived attributes in the entity model, they often calculated on-the-fly when needed or stored in a separate table or view. Including derived attributes in the entity model can lead to redundancy and potential data inconsistency.

[@aksharacsit]

Yes derived attributes will not be stored in database, but derived attribute values will be calculated based on already existing data. So in this relational mapping we will ignore derived attributes.

[@khalidmuzemil9020]

thank you

[@akashsivatejajayampu2444]

Sir what about weak entity

[@aksharacsit]

Weak entity starts at @ 4:15 minutes

[@Mayuurrr]

sir sorry.... but we feel sleepy....we see youtube channels because we sleep in class,but what is the use if we feel the same here too..plz do refer gate smashers

[@aksharacsit]

Thank you for suggestion.

[@Supreetvajjaramatti]

thank you sir