Databases

June 21, 2015 by Arjun Suresh 7 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

14,182 total views, 9 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()

QA
Questions
Aptitude

Answered: GATE1994_9

[youtube https://www.youtube.com/watch?v=1A_NcXxdoCc] [youtube https://www.youtube.com/watch?v=wbH2V [...]

Which of the following are context free ?

$L1 = a^i b^i c^j$ such that i>=1 and j>=1 $L2 = a^i b^i c^j$ such that j>=1 $L3 = a^i b^i [...]

Answered: Co doubt

I solved it this way: For the first instruction format, the opcode is of 6 bits. So, this gives $2^6 [...]

Answered: Decidability property.

Intersection of languages produced by two DCFG may or may not be DCFL. Which means it could be CSL o [...]

Answered: Ace test series

Outermost loop will run for $n$ times , will not effect $2^{nd}$ and $3^{rd}$ loop. outermost loop w [...]

Which of the following are context free ?

$L1 = a^i b^i c^j$ such that i>=1 and j>=1 $L2 = a^i b^i c^j$ such that j>=1 $L3 = a^i b^i [...]

Decidability property.

Intersection of languages produced by two DCFG is a DCFL . Decidable or not ? Please give reference [...]

Ace test series

for (i=n ; i>0 ; i--) { for ( j=1;j [...]

Please explain.. [...]

https://gateoverflow.in/118698/gate2017-1-01 Contra positive of ~p -> ~q is q->p inverse of [...]

Answered: Choose the lettered word or phrase that is most nearly opposite in meaning

INTEGRAL : Crucial ABET: mollify [...]

Verbal Reasoning / Verbal Analogy HELP

CLANDESTINE is to SECRECY as .... ERUDITE is to IGNORANCE FRIGID is to TEMPERATURE FELONIOUS is to A [...]

Answered: CAT1994-21

The meaningful sentence that will form here is : But masterpiece is more likely to come as the cul [...]

Answered: CAT1994-54

Let x : Number of persons reading only Anandbazar y : Number of persons reading only Ganasha [...]

Answered: CAT1994-56

Given same parameters , Volume of right circular cone = 1/3 π r2 h = 2/3 π r3 [ As h = [...]

%d bloggers like this: