Log in Sign up

Home
RGPV
CSE
5th Semester
CS-502
Unit 3 Notes

CS-502 Database Management Systems Unit 3 Notes

Notes and important questions for unit 3: Database Design and Query Optimization.

Unit 3 · Short notes Database Design and Query Optimization Introduction to normalization, normal forms, functional dependency · Decomposition, dependency preservation and lossless join · Problems with null‑valued and dangling tuples, multivalued dependencies · Query optimization: introduction, steps of optimization, algorithms for select, project and join · Optimization methods – heuristic based and cost‑estimation based

More for CS-502

Database Management Systems subject page

Other 5th semester CSE subjects

All CSE 5th semester subjects