Normalization 0NF 1NF 2NF 3NF - Database - AL ICT ප්‍රමතකරනය in Sinhala [FOR AL ICT Students]

Official Website: dsit-academy.com/
This video is created for Educational Purposes only.
Re-usage of content or the video is strictly prohibited.
All these videos are property of the "Deshan Sumanathilaka IT Academy" UA-cam Channel.
In any need of reusing the content please contact [e-mail].
Videos By: Deshan K Sumanathilaka
(BTech Computer Science & Engineering, MCS(Reading) )
Assistant Lecturer, IIT
Editing: Camtasia 2019
UA-cam Channel: / @ds-it-academy
Official Website: dsit-academy.com/
Python in English: • Introduction to python...
python is sinhala: • Python Introduction in...
Operating Systems: • Shortest Job First (SJ...
Number Systems: • Number Systems Introdu...
Logic gates: • AND OR NOT Gates in Si...
Sorting Algorithms: • Sorting algorithms Int...
Database and SQL: • AL ICT - Database in S...
Network : • AL ICT Network- IP Add...
PHP: • AL ICT - PHP Sinhala
Model Paper: • AL ICT - Model Questions
DFD: • AL ICT - Data Flow Dia...
HTML : • AL ICT - HTML
OSI Model : • AL ICT - OSI Model
AL Past Papers : • AL Past Paper Discussion
Flow Chart and Pseudo Code : • AL ICT - Flow chart an...
C programming: • C programming [Introdu...
Java : • JAVA Sinhala - UG
E-commerce : • AL ICT Ecommerce
OOP with Java : • OOP with Java - UG
OL : • Ordinary Level (OL)

[@ireshnimantha2603]

3nf එකේ ගත්ත table එකේ project No එක repeat වෙනවනේ... 3nf එකට ගත්ත table එක 2nf වෙලා නෑ වගේ නැද්ද? 🥲🙏

[@arunisenevirathna2547]

Thank you Sir... Ur explanation is very clear.... 👍

[@amda7194]

සර්..3nf උදාහරනයෙදී emp no. එකයි project no එකයි එකතු කරලා project name හදුනගන්න පුලුවන් වෙද්දී ආය ඒ ප්‍රාතමික යතුරෙ කොටසක් වෙන project no එකෙන් project name එක හදුනන්න පුලුවන් නිසා ඒක 1nf ආකාරයේ තියෙනව කියල ගන්න බැරිද සර්..අනේ කියන්නකෝ ලොකු ගැටලුවක් සර්.එහෙම ගන්න බැරි හේතුවත් කියන්නකෝ❤️❤️❤️❤️❤️

[@DS-IT-ACADEMY]

E kiyne oya partial dependency ekk hdanna ynwwada. Prathamika yathurak widiyta attribute ekk gniddi, eka attribute ekn eka krnna puluwn nm dekka thunak dnna ynne naa... dekk use krnne, eka variable ekein determine krnna bari nm withrai

[@amda7194]

@@DS-IT-ACADEMY aaaa hri hriii sirr thank youu❤️❤️❤️❤️❤️❤️❤️

[@mevinimunaweera9841]

Thank you so much sir.Great explanation 👍🙂

[@manelpura2603]

thank you very much sir i watched whole video

[@dulmisawindi2535]

Thank u very much sir.sirge video balala thamyi exam paper eke prshny lassanata liyagaththe.🥺❤️🔥

[@shimraameen5493]

thank you sir very clear explanation.

[@mohomedrameesmohomedraheem9841]

Hodatama teruna ❤️

[@Hiranyaa_02]

❤❤

[@hiranchamara6201]

🙂

[@Cassidy_luv]

Thanks sir kalin video el therun na mek maru

[@BenTennyson-xh4fx]

good

[@glenperera9025]

Thank you sir❤️

[@dulmisawindi2535]

Thank you sir ❤️🔥

[@anjanaravishan4383]

Sir hodatma theerena widihat kiyala denwa ❤❤

[@DS-IT-ACADEMY]

❤️

[@rashmikadeshan6705]

Thank you so much, Sir.

[@maduabewardana7900]

thank you sir

[@dhanapara2856]

thnx a lot sir.....

[@shamaliroshan0206]

super😍😍😍

[@pasindumaduranga9247]

thank u very much sir ♥️🥰

[@vidushimirihana2804]

1

[@naseefahamad4821]

22.14 (in the video) sir in this employee table is project no a foreign key of project table

[@DS-IT-ACADEMY]

Yes

[@misterag2326]

Thank you Sir ❤️
❤️❤️❤️

[@heavenworld145]

14:45 methandi kynwne data repeat wenne nh kyl. Eth id & dep_id repeat wlne.. plz eka pahadili krl dennko.
Thanks to your videos.

[@DS-IT-ACADEMY]

Ethnadi id department id denna ekk widiyta consider kralai api gnna ona, e dennama thamai table eka composite key ekk wenne

[@heavenworld145]

Thank You...

[@cobraclutch9686]

god bless all

[@sanjugayan6673]

💜️

[@indunilherath8132]

Thank you sr

[@Lovelyn777]

Thank you so much ! Sir ❤️

[@AviatorLK]

22:05 Methana Employee table eke projNo no field eke data repeat wela thiyana eka prashnayak nedda sir?

[@DS-IT-ACADEMY]

Ehma issue ekk naa @movie paradise

[@AviatorLK]

@@DS-IT-ACADEMY OK sir. Thank you!

[@methshimendis3535]

thank u sir it was very usefull

[@saveepalliyaguruge3830]

Thank you very much sir!

[@salindasandaruwan1872]

Thank you very much......!

[@arunisenevirathna2547]

Thank u sir

[@sandasimanage1072]

❤💫

[@thusithamiyuranga4784]

නියමයි සර් ..Good luck ❤️

[@user-ft5pu6fl7x]

❤

[@anujarangana6677]

thank you so much sir ♥️

[@GG-xe9hf]

Gammak sir ❤🎉

[@WasanthaDissanayake-s9c]

Thankyou so much sir

[@gaveesha123]

🎉

[@chamodyavogsjanith8141]

Thanks sir❤️

[@Back_coding]

meke questions tikak karannko sir plzz ✨

[@DS-IT-ACADEMY]

Database past paper dicussion tka balanna

[@Back_coding]

@@DS-IT-ACADEMY ok

[@ODI_113]

❤❤❤

[@uditharandula8967]

Thank you sir ❤️😍

[@lktips1026]

❤❤