Web Page

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.

$$\scriptsize{\overset{{\large{\textbf{Mark Distribution in Previous GATE}}}}{\begin{array}{|c|c|c|c|c|c|c|c|}\hline
\textbf{Year}& \textbf{2022} & \textbf{2021-1}&\textbf{2021-2}&\textbf{2020}&\textbf{2019}&\textbf{2018}&\textbf{2017-1}&\textbf{2017-2}&\textbf{2016-1}&\textbf{2016-2}&\textbf{Minimum}&\textbf{Average}&\textbf{Maximum}
\\\hline\textbf{1 Mark Count} & 3 &2&1&2&2&2&2&2&3&2&1&2.1&3
\\\hline\textbf{2 Marks Count} & 2&3&3&3&3&2&3&3&1&2&1&2.5&3
\\\hline\textbf{Total Marks} & 7 &8&7&8&8&6&8&8&5&6&\bf{6}&\bf{7.1}&\bf{8}\\\hline
\end{array}}}$$

Most viewed questions in Databases

0 votes
0 answers
4111
0 votes
0 answers
4113
Can a tuple in unary-relationship set be in relation with itself. For example, take a tuple T1 in an entity E1 and this entity E1 is related to itself. Now can the Tuple ...
0 votes
0 answers
4115
2 votes
1 answer
4116
0 votes
0 answers
4117
0 votes
0 answers
4118
Last level isnt consider as index ? is it because it does not point to any block ? but it does point to record right then why we dont consider it as index level ?( may ...
0 votes
0 answers
4119
differnce between .year≥2009(takes) join studentyear≥2009(takes join student)with example
0 votes
0 answers
4121
0 votes
0 answers
4122
“If there is deadlock in a schedule then it will never be Serializable “??if yes why?
1 votes
0 answers
4123
R(A,B,C,D,E)F={A→BCD,BC→D,D→BDecompose to BCNF.
0 votes
0 answers
4126
0 votes
0 answers
4128
0 votes
0 answers
4129
What is the difference between primary multilevel index and B tree?