Register

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

Filter

Recent questions in Databases

1 votes
3 answers
3331
general normalisation
Can anyone explain me the conditions of 2NF, 3NF and BCNF.....in short.....and how to find normalisation in fastest way possible......
Can anyone explain me the conditions of 2NF, 3NF and BCNF.....in short.....and how to find normalisation in fastest way possible......
User Avatar
6 votes
2 answers
3332
Normalisation
R(ABCDEF) AB->C DC->AE E->F how to find the highest normalization of the above relation.......?? and also tell me the difference between prime attribute, non-prime attribute and candidate key with examples.....??
R(ABCDEF)AB->CDC->AEE->Fhow to find the highest normalization of the above relation.......??and also tell me the difference between prime attribute, non-prime attribute a...
User Avatar
0 votes
1 answer
3333
ER model
User Avatar
–4 votes
0 answers
3334
er modal
[email protected]
[email protected]
User Avatar
–3 votes
0 answers
3335
file structure
[email protected]
[email protected]
User Avatar
1 votes
2 answers
3336
data base system
Find highest normal form? R(ABCDE) FD={AB-->C, C-->A, C-->D, BD-->E} here I have doubt that BD-->E is partial dependency or not? BD-->E is 1nf or 2nf or 3nf?
Find highest normal form?R(ABCDE)FD={AB >C, C >A, C >D, BD >E}here I have doubt that BD >E is partial dependency or not?BD >E is 1nf or 2nf or 3nf?
User Avatar
0 votes
2 answers
3337
Transaction concurrency
Getting A)
Getting A)
User Avatar
3 votes
1 answer
3338
MadeEasy Test Series: Databases - Sql
i think neither of the queries can implement given specification. plz confirm!
i think neither of the queries can implement given specification. plz confirm!
User Avatar
0 votes
1 answer
3339
DataBase B+tree
Is the Analysis Correct ... Can Any Please help from where to Study About B+ tree Insertion and Deletion .. Its Somewhat confusing too me ...
Is the Analysis Correct ... Can Any Please help from where to Study About B+ tree Insertion and Deletion .. Its Somewhat confusing too me ...
User Avatar
0 votes
1 answer
3341
DBMS ER-model
User Avatar
0 votes
1 answer
3342
DBMS ER-model
What is structural constraint of relationship type and give some examples of it....or any link...???
What is structural constraint of relationship type and give some examples of it....or any link...???
User Avatar
1 votes
2 answers
3343
DBMS er-model
User Avatar
7 votes
1 answer
3344
ER-model No of tables
User Avatar
0 votes
2 answers
3346
Database:
Consider f is AB->C, C->A, BC->D, ACD->B, BE->C, CE->FA, CF->BD, D->E then find the canonical cover.
Consider f is AB->C, C->A, BC->D, ACD->B, BE->C, CE->FA, CF->BD, D->E then find the canonical cover.
User Avatar
10 votes
2 answers
3347
GATE CSE 1990 | Question: 2-iv
Match the pairs in the following questions: ...
Match the pairs in the following questions:$$\begin{array}{|ll|ll|}\hline (a) & \text{Secondary index} & (p) & \text{Function dependency} \\\hline (b) & \text{Non-proced...
User Avatar
0 votes
0 answers
3348
functional dependency
can anyone help counting the total FDs |F+| or FD set closure as given 43 FD's in below example
can anyone help counting the total FDs |F+| or FD set closure as given 43 FD's in below example
User Avatar
0 votes
1 answer
3349
#UPPCL
User Avatar
Page: