Databases

June 21, 2015 by Arjun Suresh 9 Comments

Syllabus

ER-model, Relational model (relational algebra, tuple calculus)
Database design (integrity constraints, normal forms)
Query languages (SQL)
File structures (sequential files, indexing, B and B+ trees)
Transactions and concurrency control

Book

Choose one of:

Video

Web Links

Previous Year Questions

http://gateoverflow.in/questions/database-management

Important Questions

http://gateoverflow.in/blog/560/important-questions-in-databases

GATE CSE Discussions

18,018 total views, 16 views today

Related

Akash Kanase

A formal approach for ER to Relational Model This link is not working !
- Arjun Suresh
  
  yes. I guess these course links are getting removed after every semester. I’ll update when I get new.
Akash Kanase

@arjunsuresh:disqus
Generic B & B+ Tree concepts. Like m ary B+ tree, B Tree. How to count no of Internal nodes, Leaf nodes.

Though I’ll like discussion on following question.. (It’ll be good if you can solve them if possible at least )
http://gateoverflow.in/1331/gate2009_45 => If you can explain this in discussion once, It’ll be great. Your answer is available
http://gateoverflow.in/1259/gate2007_61 => Answer is there , though I’m not happy with interpretation
http://gateoverflow.in/2279/gate1997_19 B+ Tree
http://gateoverflow.in/2510/gate1994_14 B+ Tree
http://gateoverflow.in/1520/gate1999_21 B Tree
http://gateoverflow.in/3828/gate2005-it_66 => Thinking this question is part of SE maybe
http://gateoverflow.in/3641/gate2006-it_85 => How to solve it, what is correct answer !
http://gateoverflow.in/1847/gate2006_69 => Query Execution Plans
Pingback: Best Video Lectures for GATE in CSE - Gate Helpline()
Pingback: Best Books for GATE CSE – GATE CSE()
Pingback: GATE CSE 2016 Syllabus – GATE CSE()
Pingback: Best Video Lectures for GATE CSE – GATE CSE()
Rishabh Gupta

@arjunsuresh:disqus Sir, This link is also good: db-book.com
This is the website of the database book by Korth. And slides given there are like notes which cover the complete chapters.
- Arjun Suresh
  
  Thanks. Added

GATE Overflow
Aptitude Overflow

Answered: GATE2007-50

Consider n=8 elements in an array {1,4,5,8,3,2,7,9} Lets make a tournament bracket for them, where a [...]

New IITs direct admission last ranks

Can anyone share details of the last rank/cutoff for the direct M Tech admit in the new IITs (IIT Ro [...]

My Gate score (2018) is 671 category-general Branch-CSE What are best options available to me right [...]

ISI PCB 2016 C2 A

Consider sending a large file of 360,000 bits from Host A to Host B, connected through a router. Ass [...]

caching and virtual memory

I am having troble with these following questions. Please I need help [...]

Can a 4:1 MUX operate as 2:1? (I understand 4:1 can be realized using 2:1 Mux but is reverse possib [...]

Answered: CAT1996-107

Let 'a' ltr be taken from first container and 'b' ltr be taken from second. $\fr [...]

Answered: CAT1995-81

$AB\perp BC$ & $BD \perp AC$ ∴$\measuredangle ABC = 90^{\circ} $ & $\measuredangle BDA = [...]

Answered: CAT2003-1-126

Assuming the total no. of goats are $x$ if percentage of adding (increase) i.e $p$ = $10\%$ & p [...]

Answered: CAT1995-155

Performance Total Average Good Excellent Male $\color{blue}{16}$ $\color [...]

Answered: CAT1995-154

Performance Total Average Good Excellent Male $\color{blue}{16}$ $\color [...]

Answered: CAT1995-153

Performance Total Average Good Excellent Male $\color{blue}{16}$ $\color [...]

%d bloggers like this: