How to normalise and draw an Entity Relationship Diagram #normalisation #youtube #1NF #2NF #3NF #first normal form #databases
Пікірлер: 43
@im01223 жыл бұрын
you havent posted in 3 years but you r still helping ,thank you
@learnwithnadia14553 жыл бұрын
One of my students opened the account for me as he really wanted me to.. but I have been slow in production ;--)
@IBRAHIM-vz1un3 жыл бұрын
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.
@shafiullahsyed42555 жыл бұрын
wow what a sweet voice and thanks for the lecture
@husnimasha33246 жыл бұрын
Powerful lecture. I understood you more than I do to my lecturer Thanks alot
@learnwithnadia14556 жыл бұрын
Thanks for your feedback
@teresayow60962 жыл бұрын
Hello
@sandarusampath7463 Жыл бұрын
Very helpful and clear explaination. Thank you🔥
@vihangamuthumal39815 ай бұрын
its very helpful in 2024
@ubermensche606 жыл бұрын
Now this was very helpful.....
@learnwithnadia14556 жыл бұрын
Great to know Fardeen
@sumedhakarunarathna4263 жыл бұрын
Thank you this was really useful...
@alvisceratortheultimate16603 жыл бұрын
This is truly helpful, thank you.
@someoneleo2303 жыл бұрын
Very cute and informative.
@learnwithnadia14553 жыл бұрын
Thanks Leo :-)
@kseeroo6 жыл бұрын
Wow Nadia, such a nice way to teach!!
@kseeroo6 жыл бұрын
I hope you were the tutor, i got DB exam today about ERD Diagram and conversion. I should have contacted you earlier
@aimanmeer90058 ай бұрын
Thanks alot teacher ❤
@learnwithnadia14557 ай бұрын
Nice to be address as a teacher again. I have not been teaching since 2021. I miss my students 😭. In fact it was a student that got me to create a KZfaq account and teach! But I have not done it regularly. It was just as extra lessons for my students.
@aimanmeer90056 ай бұрын
@@learnwithnadia1455 ❤️🤍
@afzaalawan6 жыл бұрын
Excellent Nadia.. wiesh to be your student if you are in UK
@learnwithnadia14556 жыл бұрын
Thanks Afzaal, but I am in Australia.
@afzaalawan6 жыл бұрын
Too far. Any of here drop me a msg.
@9252000lai5 ай бұрын
can you explain why tour_id is the foreign key of customer?
@MIqbalHossain6 жыл бұрын
2:49 ... why custId (001) have 2 entries? Customer ID is primary key, so there is a duplication.
@learnwithnadia14556 жыл бұрын
M Iqbal Hossain - that is unnormalised data where the same customer can be listed more than once. Later on when it is normalised it will only appear once.
@amruthakuruba1668 ай бұрын
there are two primary keys in a table custid and tourid how its possible
@learnwithnadia14558 ай бұрын
@amruthakuruba166 in some cases we need to combine two PKs from different tables to ensure a record is unique. This is called a composite key.
@levaitherapdragon5 ай бұрын
you just helped clear a course 🫶🏿🫵🏿
@maramj86706 жыл бұрын
thank you so much, that was helpful!
@learnwithnadia14556 жыл бұрын
Glad to hear! You are welcome.
@maramj86706 жыл бұрын
We are studying a course which we have to create a system and we assigned to do a normalization, EDR and DFD for it, but the issue is that we studied database normalization way too back and we don't have our books and now we are confused about it, we remember just a little things. idk why i am telling you all this nonsense story but i just wanna know if we have to do 1NF, 2NF and 3NF also? or just one table would be enough? thank you so much for your time..
@learnwithnadia14556 жыл бұрын
If it is a course, I assume there are marks allocated for showing step by step normalisation. If not you can ensure all the requirements are met and reach 3NF at once and show only the final form.
@sulemanmasood13822 жыл бұрын
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 normalized.....but it is still working fine...on LAN and on cloud as well ... what will be future of my db... can u help me...
@TheRoyalRat7784 жыл бұрын
Thank you!
@knowledgepoint22347 ай бұрын
I need for notes this lecture plz
@learnwithnadia14557 ай бұрын
It was done over 6 years ago, I will have to dig them up. Need your email to send to you.
@karansagar78705 жыл бұрын
Are foreign keys shown in er diagram as attribute widout normalizing?
@qasimateeq7295 жыл бұрын
In 1st normal form u form 3 tables but in customer table "Cust_Id 001" is again repeated
@learnwithnadia14555 жыл бұрын
Qasim Ateeq 1NF can have that. Sorry I can see why you were confused. I should have shown the unnormalised form in another way. Repeating fields are not quite clear in my video- thanks for your query! I will do another video with another example!
@hassankhattak30832 жыл бұрын
Can I have these files in png or jpg form ASAP?
@learnwithnadia14557 ай бұрын
It was done 6 years ago, if I can find it I will. But how can I send it to you anyway.