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

1 votes
0 answers
163
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
0 votes
1 answer
164
In Query1, how mid is projected from did.?????????/
0 votes
0 answers
165
How to identify many to many relationship.Can R2 be one to one.
0 votes
0 answers
167
can a relationship have a degree of one if both the entities are same and participating in one form?ex: employee helps employee
0 votes
1 answer
169
Can anyone explain in detail about the concepts of sencondary indexing in dbms??
0 votes
1 answer
171
Match List I with List II :$\begin{array}{ll} \text{List I} & \text{List II} \\ \\\text {(A) BCNF } & \text { (I) It removes multivalued dependency } \\\text {(B) 3} \mat...
6 votes
0 answers
172
Consider a multi-dimensional array A [90][30]40] with base address start at 1000, calculate the address of A[10][20][3] in row major order and column major order. Assume ...
1 votes
2 answers
174
If two schedules are conflict equivalent then can we definitely say that they are also view equivalent?
1 votes
1 answer
176
0 votes
1 answer
179
0 votes
0 answers
180
which is best book for DBMS korth or navathe ?since i know that both book is great but i wanted to follow 1 particular book that is easy to understand and simple language...