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

[@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

[@KushagraJain-fc3nt]

watching a day before exam! Now these are the videos a guy can really rely on for the last day prep :))

[@akshara_cs]

Glad this video can help!

[@Dinesh10-r8p]

Best video I have never seen before for my final examination✨✨

[@serhattatas5123]

Great video dude ! 1000x Better than my prof.

[@abhivishwa112]

What a neat explanation!!
Thank you 🙏

[@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.

[@akshara_cs]

Thank you Harees

[@maheezthariq]

🚶

[@zulfaharees9272]

@@maheezthariq .....!

[@AshishhShettyy]

Lol rookie number ,i have exam in 20 minutes

[@varadcr8271]

Excellent video. Thank you for making it simple.

[@akshara_cs]

Thank you

[@lehaswinipalla3365]

Best video on this topic

[@likhithS2321]

thank you sir! you saved me from the internals

[@oscarwong5226]

Thank you, watching this before my quiz

[@um.e.habiba4903]

Same condition here bro

[@muneebnaeem3918]

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

[@akshara_cs]

Thank you Naeem

[@hafsaqaiser8615]

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

[@MohanDas-ne4ci]

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

[@Sahnas_05]

Thanks Alot 🇱🇰❤️

[@blessy_clicks]

Too perfect sir,awesome

[@akshara_cs]

Thank you

[@kyriakoskyprianou4743]

very good video, thank you very much you saved me!!!

[@artgaming4271]

Excellent work!

[@grishrana8432]

Hello sir! About the multivalued attribute in DEPT_LOCATIONS Dnumber is brought from DEPARTMENT relation so it is a foreign key. Do we need to underline it twice one with st. line and another with dashed line?

[@akshara_cs]

We should not use the dashed line . Dept_locations is a relation . Not the entity. If we have any entity which has a partial key. Then we have to use a dashed line.

[@surenderm6122]

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

[@soapmactavish6001]

explained very well sir, thank you

[@ENagamani-yl1ub]

Thank u for wonderful video😊

[@5pointpulse-75]

Thank you so much! ☺

[@tayyabali129]

you are great sir g

[@LaulentMathias]

Thanks sir 👍

[@poojashreent629]

Thank you so much sir 🤩

[@MrAqeel_Advice_Motion]

Thank you so much 🥰 Sir

[@asmij2078]

thank you sir 😄😄

[@bl0ndigemini]

what if relation is total, does it not affect the schemas, no more modifying?

[@akshara_cs]

If we have total participation then add the primary in that entity table. In the above example the department has a total participation in manages relationship so we modified the department table( means we add SSN as foreign key in the department table).
Note: if we have partial participation both side we can modify(add foreign) any one of the relation. But if we have any relationship with total participation then that need to be modified(add foreign key in that relation)
Refere at 6:20

[@adityasareen5638]

why didnt we consider dependents_of in the 1:N relationships?

[@akshara_cs]

@@adityasareen5638 that is already covered while covering weak entity dependent.
Please check from 4:50

[@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.

[@akshara_cs]

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

[@PODOCAST-TUBE]

Thank you sir

[@ChaitraHosamani-sk4ct]

Watching in 2025 Attandance here❤

[@HsYxyx]

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

[@khalidmuzemil9020]

thank you very very very very very very much sir

[@akshara_cs]

Thank you 🙂

[@akremomer4540]

Yeah it’s really nice of you sir

[@Supreetvajjaramatti]

thank you sir

[@vkhs562]

Can I get notes

[@cecewow]

THANK YOUUU

[@oshadhaedirisinghe1455]

Thank you

[@cs-3-5d8ch.satwik6]

can u provide the text book link what u follow

[@akshara_cs]

Fundamentals of Database Systems
Book by Ramez Elmasri

[@cs-3-5d8ch.satwik6]

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

[@FaizzaKanjati]

Well helped

[@nikitakarthik9931]

thank you so much

[@jeevanmv4529]

🔥🔥🔥

[@mahadsohail7205]

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

[@akshara_cs]

Thank you

[@akashsivatejajayampu2444]

Sir what about weak entity

[@akshara_cs]

Weak entity starts at @ 4:15 minutes

[@chanchalkaushik0777]

SIR PLEASE UPLOAD PDF DOCUMENT FOR THIS LECTURE AS WELL

[@Mehiko007]

nice

[@saadzaffarlaghari1811]

watching this 20 Minutes before exam, Hope this helps 😭

[@akshara_cs]

I hope this helps you with your exam! Good luck!

[@KON.yoyo_pro]

I can't getting😅😅

[@begnazarhasan]

whose exam is tomorrow😂