Summary :::: full dependency : using primary key or composite primary key we can drive all attribute partial dependency : when their is one composite primary key having 2 keys each can identify some relationship among other attribute separate it we get (2NF) transversal dependency : when the attribute are not dependent on any primary key or composite primary key remove those attribute to get (3NF) I Hope I am correct on this 😁😁😁
You sir, are the GOAT!!!!! This is so simple and straightforward. Thank you so much!!!!
This is hands down the best video explanation I've seen. Even my professor didn't explain it this well. Thank you!!
You are a legend! Best explanation on Normalization!!
you are awesome, i spent so much time reading through the book and didn't understand it. but then i found your vid and it helped so much. thank you !
Your video triggered me to hunt for cengage book and in turn both helped me very much. Thanks a ton
Excellent job
Thank you so much. This video helped out so much!
This video is very helpful! Thank you!
thank you sir, your explanation is clear and understandable
Thank you so much, this is very clear!
Thank you 🙏
This is so helpful! TYSM
Thank you! This video was really helpful!!
thank you ❣️
Thanks, a lot that really helped ... but I have confusion on charge dependency on emp_num or job_class
thank you so much!
tamang puyat lang sabel 👁️👄👁️ HAAHAHAHA same -pv
good
Summary ::::
full dependency : using primary key or composite primary key we can drive all attribute
partial dependency : when their is one composite primary key having 2 keys each can identify some relationship among other attribute separate it we get (2NF)
transversal dependency : when the attribute are not dependent on any primary key or composite primary key remove those attribute to get (3NF)
I Hope I am correct on this 😁😁😁
There is no consistent transitive dependency
104 Sales rep earns 50 bucks and 429 sales rep earns 40 bucks :p
I saw that but I think it was an error in this video because in the textbook, every job class has a specific charge no matter the project
Thank you so much!