Syllabus
- ER‐model. Relational model: relational algebra, tuple calculus, SQL.
- Integrity constraints,
- normal forms.
- File organization, indexing (e.g., B and B+ trees).
- Transactions and concurrency control.
Book
Choose one of:
Video
Web Links
- Home page of Database Systems Concepts
- SQL and other portions
- ER to Relational Model
- Normal Forms Quick View
- Normalization Slides
- Canonical Cover
- Indexing
- B+ Tree Insertion and Deletion
- NULLs
Previous Year Questions
http://gateoverflow.in/questions/database-management
Important Questions
http://gateoverflow.in/blog/560/important-questions-in-databases
Recommended Tests
- https://gateoverflow.in/exam/244/go-2021-databases-1
- https://gateoverflow.in/exam/50/test-by-bikram-database-systems-1
- https://gateoverflow.in/exam/85/test-by-bikram-database-systems-2
GATE CSE Discussions
37,918 total views, 12 views today