Your Department table won't work as you'll end up with repeating groups as you have EmployeeID in it. If you have a "Customer" Department for example and two employees then the "Customer" department would be repeated. You need an EmployeeDepartment table so a department can have multiple employees.
You missed that (FirstName, LastName) -> Initials The Initials depend on other attributes (the name) that are not primary keys hence 3NF is not yet satisfied !!
"Optimization" is really amiguous here !! You can optimize for less redundancy -> normalize You can optimize for speed and performance -> _denormalize_ Normalization is not necessarily "better"
Thanks for the video. I would also like to ask a question. Is there a text or standard for normalization forms? I've noticed, after viewing multiple references to relational database design and normalization, that almost every person who writes and article, makes a video or lectures, almost always have a different definition of 1NF, 2NF, 3NF.... I know this is technology and software but is there an actual strict standard.
Wow this is much more detailed, than the videos I watched. Thank you for this 🙏
1:14 1st Normal Form
2:24 2nd Normal Form
3:19 3rd Normal Form
For the future me. Maybe.
Very well explained in a concise format.
Very clear compared to other videos out there
Thank you for this video. I wish I would've found it 6 hours ago. :/
Your Department table won't work as you'll end up with repeating groups as you have EmployeeID in it. If you have a "Customer" Department for example and two employees then the "Customer" department would be repeated. You need an EmployeeDepartment table so a department can have multiple employees.
You missed that
(FirstName, LastName) -> Initials
The Initials depend on other attributes (the name) that are not primary keys hence 3NF is not yet satisfied !!
thank you for this video. it's clear my all doubt.
Out of curiosity. What software or website are you using to build your model?
you saved me bro 😍
Isn’t initials dependent on first name and last name for 3NF
But I needed to see how you perform the 3NF! not just saying which will be which..
this is a really good video
Are you using Lucidchart?
Draw.io 😀
"Optimization" is really amiguous here !!
You can optimize for less redundancy -> normalize
You can optimize for speed and performance -> _denormalize_
Normalization is not necessarily "better"
Brilliant stuff, thank you.
Well done . Thank you!
it was really helpful
What application did you use to make this database
Database: MySQL + Drawing tool: draw.io
Thank you for watching the video.
Which software you are using
Draw.io
What program is that?
i need the pdf please
I can't find any videos where there's a Employee and Customer primary key.. that's what we need !! 💔
Thanks for the video. I would also like to ask a question. Is there a text or standard for normalization forms? I've noticed, after viewing multiple references to relational database design and normalization, that almost every person who writes and article, makes a video or lectures, almost always have a different definition of 1NF, 2NF, 3NF.... I know this is technology and software but is there an actual strict standard.
It is more a definition of the normal forms. A good reference is: ISBN-13: 978-0133970777
@@srenspangsbergjrgensen2419 Thanks a lot.
Thanks 💯
thanks a lot
thank you very much! this was quite easy to comprehend, even for an ol' fool like me, hehe :)) cheers!
ممكن تفعيل الترجمة للفيديو
Thanks man