Schema Refinement | What are database design guidelines? | Dependencies | Update anomalies | DBMS
This video Lecture targets the informal guidelines for schema refinement along with the discussion on the Functional, Partial and Transitive dependencies that one must know in order to normalize a relation in DBMS. Violation of the discussed guidelines may lead to the update anomalies i.e. insertion, modification and deletion anomaly.
