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{2024-1}& \textbf{2024-2} &\textbf{2023} &\textbf{2022} & \textbf{2021-1}&\textbf{2021-2}&\textbf{Minimum}&\textbf{Average}&\textbf{Maximum}
\\\hline\textbf{1 Mark Count} &4&4&1& 3 &2&1&1&2.5&4
\\\hline\textbf{2 Marks Count} &2&2&2& 2&3&3&2&2.33&3
\\\hline\textbf{Total Marks} & 8&8&5& 7 &8&7&\bf{5}&\bf{7.16}&\bf{8}\\\hline
\end{array}}}$$

Filter

Questions without answers in Databases

0 votes
0 answers
2
Dbms indexing
User Avatar
0 votes
0 answers
3
View serializable
S2: R1(x);r2(z);r3(x);r1(z);r2(y);r3(y);w1(x);w2(z);w3(y);w2(y) Please help
S2: R1(x);r2(z);r3(x);r1(z);r2(y);r3(y);w1(x);w2(z);w3(y);w2(y)Please help
User Avatar
0 votes
0 answers
4
B- tree in DBMS
User Avatar
1 votes
0 answers
5
Relational Database
Give an appropriate tree-structure diagram for the following relational database: Employee (person_name, street, city) Works (person_name, company_name, salary) Company (company_name, city) Manages (person_name, manager_name)
Give an appropriate tree-structure diagram for the following relational database:Employee (person_name, street, city)Works (person_name, company_name, salary)Company (com...
User Avatar
0 votes
0 answers
11
#dbms
User Avatar
4 votes
0 answers
13
GO Classes Test Series 2024 | Mock GATE | Test 14 | Question: 40
Consider the following schema (primary keys are underlined): Which of the following queries returns the department numbers of those departments for which there are no courses being offered?
Consider the following schema (primary keys are underlined):Which of the following queries returns the department numbers of those departments for which there are no cour...
User Avatar
0 votes
0 answers
16
Memory Based GATE DA 2024 | Question: 58
DBMS question: One SQL query is given. Based on the query which data structure can be used involving hashing, B+ tree, etc?
DBMS question: One SQL query is given. Based on the query which data structure can be used involving hashing, B+ tree, etc?
User Avatar
0 votes
0 answers
20
Topic name:Finding number of Cnadiadte and Super Keys
r=(a1,a2,a3,...a8) assumne that a1a2a3 is a canidate key and other cks we dont know.Then find the number of possible candidate keys and number of superkeys?
r=(a1,a2,a3,...a8) assumne that a1a2a3 is a canidate key and other cks we dont know.Then find the number of possible candidate keys and number of superkeys?
User Avatar
0 votes
0 answers
21
testbook
Can you help me understand the last 2 options
Can you help me understand the last 2 options
User Avatar
0 votes
0 answers
24
Made easy DBMS
User Avatar
0 votes
0 answers
25
#foreign key#normalization
If in a relationship an entity totally participates, and if it contains a foreign key then the foreign key can not be null in relation table format?
If in a relationship an entity totally participates, and if it contains a foreign key then the foreign key can not be null in relation table format?
User Avatar
0 votes
0 answers
27
madeeasy workbook
According to me answer is 2.Is it right? Suggestion is needed how to approach this if it is given in more complexity.
According to me answer is 2.Is it right? Suggestion is needed how to approach this if it is given in more complexity.
User Avatar
0 votes
0 answers
28
https://www.javatpoint.com/dbms-reduction-of-er-diagram-into-table
How can I represent the ER model in tabular form? , in java point, the tabular form doesn't seem to be correct. Ref. https://www.javatpoint.com/dbms-reduction-of-er-diagram-into-table
How can I represent the ER model in tabular form? , in java point, the tabular form doesn't seem to be correct.Ref. https://www.javatpoint.com/dbms-reduction-of-er-diagra...
User Avatar
To see more, click for the full list of questions or popular tags.