for Every dept_name,budget and building is same e.g. every physics dept_name has watson building and 70000 budget which is same whenever u get physics as dept_name....so we can decompose it into inst_dept to avoid data redundancy and inconsistency...
Thank you sir it helps me a lot
4:10 - 7:45
Thankyou good lecture
Anyone please explain the concept at 11:18
Once Google functional dependency ,hope it helps www.javatpoint.com/dbms-functional-dependency
for Every dept_name,budget and building is same e.g. every physics dept_name has watson building and 70000 budget which is same whenever u get physics as dept_name....so we can decompose it into inst_dept to avoid data redundancy and inconsistency...