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}}}$$

Recent questions in Databases

0 votes
2 answers
4201
i know how to find whether the decomposition is lossless or lossy . but in this type of question they are actually not defining how they decompose . they are only giving ...
1 votes
1 answer
4206
0 votes
1 answer
4207
The database can be configured to do ordered indexing on Ap or hashing on Ap. Which of the following statements is TRUE?(A) Ordered indexing will always outperform hashin...
0 votes
1 answer
4208
1 votes
1 answer
4213
Weak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity..plz clarify this........
0 votes
5 answers
4214
0 votes
1 answer
4216
I am not getting that how many attributes must be there in the Borrowed by table which actually represents a table since we have the constraint that one user can borrow o...
1 votes
1 answer
4217
Since candidate key is a minimal key and it is a proper subset of a super-key , then how is it that for a candidate key ,its proper subset is not a super key ?
4 votes
1 answer
4219