Once Google functional dependency ,hope it helps www.javatpoint.com/dbms-functional-dependency
@souravkalal38313 жыл бұрын
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...