Recent posts in Databases

Found this note quite useful in clearing my doubts with NULL. Hope this may help you!

http://www-cs-students.stanford.edu/~wlam/compsci/sqlnulls

Here is a concise note on Indexing, B & B+ Tree

http://www.cs.montana.edu/~halla/csci440/n18/n18.html

For this course we will be using the LAB exercises given here which are from Silberschatz book. 
Solutions to Practice Exercises of Silberschatz book.
 

  Day Date Contents Slides Assignments 1 Oct 7 Introduction to Databases- topics to be covered     2 Oct 8 Relational Databases
Tuple, Domain,...

Important Questions

http://gateoverflow.in/questions/database-management?sort=featured

More Questions

Normalization Questions from ETH Zurich

Questions on File Indexing

Split the fd's such that rhs contains single attribute. Find the redundant fd's and remove redundant ones. Find the redundant attributes on lhs and remove them.like AB->C ,A can be deleted if closure of B contains A