Learn with Nadia

Пікірлер

@9252000lai 5 ай бұрын

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

@levaitherapdragon 5 ай бұрын

you just helped clear a course 🫶🏿🫵🏿

@vihangamuthumal3981 6 ай бұрын

its very helpful in 2024

@knowledgepoint2234 8 ай бұрын

I need for notes this lecture plz

@learnwithnadia1455 8 ай бұрын

It was done over 6 years ago, I will have to dig them up. Need your email to send to you.

@aimanmeer9005 8 ай бұрын

Thanks alot teacher ❤

@learnwithnadia1455 8 ай бұрын

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 KZbin account and teach! But I have not done it regularly. It was just as extra lessons for my students.

@aimanmeer9005 7 ай бұрын

@@learnwithnadia1455 ❤️🤍

@amruthakuruba166 9 ай бұрын

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

@learnwithnadia1455 9 ай бұрын

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

@sandarusampath7463 Жыл бұрын

Very helpful and clear explaination. Thank you🔥

@Pakhtoon_Afghan Жыл бұрын

za za roka sha makh dy rok sha🤔

@hassankhattak3083 2 жыл бұрын

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

@learnwithnadia1455 8 ай бұрын

It was done 6 years ago, if I can find it I will. But how can I send it to you anyway.

@sulemanmasood1382 2 жыл бұрын

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

@IBRAHIM-vz1un 3 жыл бұрын

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.

@gulhussain657 3 жыл бұрын

Good job

@im0122 3 жыл бұрын

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

@learnwithnadia1455 3 жыл бұрын

One of my students opened the account for me as he really wanted me to.. but I have been slow in production ;--)

@alvisceratortheultimate1660 3 жыл бұрын

This is truly helpful, thank you.

@sumedhakarunarathna426 3 жыл бұрын

Thank you this was really useful...

@someoneleo230 4 жыл бұрын

Very cute and informative.

@learnwithnadia1455 4 жыл бұрын

Thanks Leo :-)

@TheRoyalRat778 4 жыл бұрын

Thank you!

@pakadamtv693 4 жыл бұрын

PAK ADAM TV appreciates your work

@pakadamtv693 4 жыл бұрын

NYC effort

@karansagar7870 5 жыл бұрын

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

@chillichipkingawsome7078 5 жыл бұрын

Thanks for the vid

@shafiullahsyed4255 5 жыл бұрын

wow what a sweet voice and thanks for the lecture

@qasimateeq729 5 жыл бұрын

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

@learnwithnadia1455 5 жыл бұрын

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!

@akshar17 6 жыл бұрын

how does the computer decide the random number, do you know that algorithm????

@learnwithnadia1455 6 жыл бұрын

No I don't know the algorithm, Java random number generator uses to generate these numbers - sorry

@MIqbalHossain 6 жыл бұрын

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

@learnwithnadia1455 6 жыл бұрын

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.

@jyotikhadse596 6 жыл бұрын

It helped me lot in learning HTML Thanks

@learnwithnadia1455 6 жыл бұрын

Jyoti Khadse hope you gain more from the rest of my HTML videos - -sorry my typing sounds like drums 😀

@kseeroo 6 жыл бұрын

Wow Nadia, such a nice way to teach!!

@kseeroo 6 жыл бұрын

I hope you were the tutor, i got DB exam today about ERD Diagram and conversion. I should have contacted you earlier

@afzaalawan 6 жыл бұрын

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

@learnwithnadia1455 6 жыл бұрын

Thanks Afzaal, but I am in Australia.

@afzaalawan 6 жыл бұрын

Too far. Any of here drop me a msg.

@ubermensche60 6 жыл бұрын

Now this was very helpful.....

@learnwithnadia1455 6 жыл бұрын

Great to know Fardeen

@husnimasha3324 6 жыл бұрын

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

@learnwithnadia1455 6 жыл бұрын

Thanks for your feedback

@teresayow6096 2 жыл бұрын

Hello

@maramj8670 7 жыл бұрын

thank you so much, that was helpful!

@learnwithnadia1455 7 жыл бұрын

Glad to hear! You are welcome.

@maramj8670 7 жыл бұрын

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

@learnwithnadia1455 7 жыл бұрын

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.

Ең жақсы KZbin

Пікірлер