Normalisation and ERD

How to normalise and draw an Entity Relationship Diagram

#normalisation
#youtube
#1NF
#2NF
#3NF
#first normal form
#databases

[sandarusampath]

Very helpful and clear explaination. Thank you🔥

[shafiullahsyed]

wow what a sweet voice and thanks for the lecture

[IBRAHIM-vzun]

Thank you very much Nadia! 👍🏼
God bless you 🤲🏼 This is gonna help me in my final exam.
You have a beautiful voice and accent, along with explaining things in an amazing way.

[im]

you havent posted in 3 years but you r still helping, thank you

[karansagar]

Are foreign keys shown in er diagram as attribute widout normalizing?

[husnimasha]

Powerful lecture. I understood you more than I do to my lecturer
Thanks alot

[kseeroo]

Wow Nadia, such a nice way to teach!!

[sulemanmasood]

sir my db is in mysql using MYISAM.... No foreign keys implemented with some columns repeating in tables as well... i have approximatelly 40 tables and all containns approx 500 rows.... but two or 3 tables contains above one million rows....db is not it is still working fine...on LAN and on cloud as well ... what will be future of my db... can u help me...

[lai]

can you explain why tour_id is the foreign key of customer?

[amruthakuruba]

there are two primary keys in a table custid and tourid how its possible

[qasimateeq]

In 1st normal form u form 3 tables but in customer table "Cust_Id 001" is again repeated

[afzaalawan]

Excellent Nadia.. wiesh to be your student if you are in UK

[MIqbalHossain]

2:49 ... why custId (001) have 2 entries? Customer ID is primary key, so there is a duplication.

[hassankhattak]

Can I have these files in png or jpg form ASAP?