menu
Recent questions tagged databases
Login
Register
My account
Edit my Profile
Private messages
My favorites
Register
Recent questions tagged databases
All Activity
Q&A
Questions
Unanswered
Tags
Categories
Users
Ask a Question
Blogs
Previous Year
Exams
Recent questions tagged databases
0
votes
0
answers
44
views
DBMS,serializability
Is it possible to have a conflict serial schedule with Blind write?
stupid_hacker
asked
in
Databases
Aug 19, 2021
by
stupid_hacker
5
points
44
views
databases
self-doubt
0
votes
0
answers
50
views
#Gateapplied
Consider the following schedule S: S: R1(X); R2(Z); R1(Z); R3(X); R3(Y); W1(X); W3(Y); R2(Y); W2(Z); W2(Y); Here Ri(D) denotes that transaction i is reading the data item D while Wi(D) denotes that transaction i is writing ... of the transaction can be added in the end of schedule S in an appropriate order such that S is recoverable. The number of such orders possible are ______
eleven11
asked
in
Databases
Jul 13, 2021
by
eleven11
5
points
50
views
databases
0
votes
0
answers
33
views
Please explain the step by step polygraph solution to check for view serializability for this schedule:
CheSin
asked
in
Databases
Jul 7, 2021
by
CheSin
5
points
33
views
self-doubt
databases
0
votes
0
answers
42
views
from gradeup quiz.
Consider the relation R(ABCDEF) with dependecies F: {A->C, C->D, B->E, E->F} The number of tables present in its 2NF decomposition are _______.
swami_9
asked
in
Databases
Jul 7, 2021
by
swami_9
5
points
42
views
databases
normalization
0
votes
0
answers
84
views
(Made easy test series) Topic name is total specialization in ER diagram in DBMS
Jaykumar12
asked
in
Databases
Jun 29, 2021
by
Jaykumar12
5
points
84
views
databases
er-diagram
0
votes
0
answers
19
views
#self-doubt dbms confused between navathe or korth or raghuramakrishnan
ykrishnay
asked
in
Databases
Jun 27, 2021
by
ykrishnay
103
points
19
views
databases
0
votes
0
answers
14
views
this is my assignment
For the following information systems determine the entities of interest, their attributes and the relationships that exist between the entities. Draw the E-R diagram for the system. Peoples Information Systems for a village/ward(that stores information about peoples)
nasima0058
asked
in
Databases
Jun 5, 2021
by
nasima0058
5
points
14
views
databases
0
votes
1
answer
41
views
How to draw the serializability graph if transactions are getting commited
Lekhraj
asked
in
Databases
Jun 4, 2021
by
Lekhraj
9
points
41
views
databases
0
votes
0
answers
19
views
DBMS Serializability
Consider the following (incomplete) schedule S: T1:R(X), T1:R(Y), T1:W(X), T2:R(Y), T3:W(Y), T1:W(X), T2:R(Y) If all three transactions eventually commit, show the serializability graph.
Lekhraj
asked
in
Databases
Jun 3, 2021
by
Lekhraj
9
points
19
views
databases
indexing
self-doubt
1
vote
1
answer
42
views
Tga test series
It is 2NF or not ? Just explain this portion.
Enolx.21
asked
in
Databases
Jun 2, 2021
by
Enolx.21
53
points
42
views
self-doubt
databases
database-normalization
0
votes
0
answers
21
views
Indexing (DBMS)
Lets suppose, we define a schema with no primary key but there is an attribute(s) with unique and not null constraints. Now default indexing i.e primary indexing is not possible here because of no primary key. Now, at the time of Database design, ... necessary to input records in sorted order? or is there any other way possible to apply clustering index over a given database file?
bhardwaj.aakash_420
asked
in
Databases
May 30, 2021
by
bhardwaj.aakash_420
5
points
21
views
databases
self-doubt
indexing
0
votes
0
answers
35
views
my sir give this assignment
Consider the following relations concerning a driving school. The primary key of each relation is in boldface. STUDENT(S_Name,Class_No,Th_Mark,Dr_Mark) S_Name - student name, Th-Mark - Theory mark, Dr_Mark - driving mark STUDENT_DRIVING_TEACHER(S_Name,Dr_T_Name) ... marks than average theory mark of class 8. f)Find the list of teachers who can drive all the vehicles.
nasima0058
asked
in
Databases
May 29, 2021
by
nasima0058
5
points
35
views
databases
0
votes
0
answers
33
views
Selfdoubt(Relational Algebra and SQL)
Is the JOIN operations(natural , left , right) in relational algebra and SQL same or is there any difference based on the condition? Please provide reference.
samir757
asked
in
Databases
May 27, 2021
by
samir757
29
points
33
views
databases
sql
joins
self-doubt
0
votes
0
answers
36
views
Self-doubt(DBMS)
How to find the number of relations required for a self-referential relationship with all the cardinalities mapped with total and partial participation? Please provide links to the same.
samir757
asked
in
Databases
May 27, 2021
by
samir757
29
points
36
views
self-doubt
databases
e-r-diagram
0
votes
0
answers
53
views
gate 2001 DBMS(normalization)
R(A,B,C,D) is a relation. FD given is:{ AB->C , C->AD } is it in 2NF? is it in 3NF?
rishabh8797
asked
in
Databases
May 2, 2021
by
rishabh8797
5
points
53
views
databases
self-doubt
0
votes
1
answer
57
views
Exam operating system
When switching the CPU between two processes.. which of the following applies A. The PCB is both, saved and reloaded, only for the interrupted process that is existing the CPU B. The PCB is saved for the process that is scheduled for the CPU C. The PCB is reloaded for the process that is scheduled for the CPU D. No PCB is saved or reloaded E. None of the above
Malak
asked
in
Operating System
May 2, 2021
by
Malak
5
points
57
views
tifr-2021
self-doubt
databases
drdo
probability
0
votes
0
answers
74
views
Made Easy Book on DBMS, Geeks for Geeks
So recently I have been studying minimization of ER diagrams and have come across a big confusion. So if 2 entities, E1 and E2 are related to each other with one to one cardinality and E1 has Total participation and E2 has Partial participation, ... is 1, but some sources also say that answer should be 2. Also for GATE exam which one should be considered ?
Palash0007
asked
in
Databases
Apr 25, 2021
by
Palash0007
5
points
74
views
databases
self-doubt
admission
0
votes
0
answers
75
views
Gate pyq cse
Why in this question use B-->A ,A-->C ?
Enolx.21
asked
in
Databases
Apr 23, 2021
by
Enolx.21
53
points
75
views
self-doubt
databases
0
votes
0
answers
31
views
B+ tree right replication policy
What is right replication policy in database? And how is it different from right biasing?
dragonball
asked
in
Databases
Apr 19, 2021
by
dragonball
12
points
31
views
databases
0
votes
1
answer
75
views
self doubt database management system
is it true that “every strict schedule is cascadeless schedule”?
adas7099
asked
in
Databases
Apr 17, 2021
by
adas7099
9
points
75
views
self-doubt
databases
transaction
0
votes
0
answers
88
views
Applied Gate CSE DBMS Subject Test
Relation R (A,B,C,D) with FD'S { A->B, B->C, C->D, D->A } then relation R is decomposed into two relations R1 and R2 such that it is satisfying second normal form, third normal form and BCNF and decomposition is lossy. Then how the attributes are distributed in these two decomposed relations R1 and R2? Note: U is the set of all attributes. 1. 2. 3. 4.
samir757
asked
in
Databases
Mar 14, 2021
by
samir757
29
points
88
views
databases
normalization
0
votes
0
answers
62
views
Applied Course GATE CS - DBMS Practice test 3
Given 3 T1, T2 and T3 transactions which have (2,2), (3,2), (4,2) read and write operations respectively the no of schedules possible using these three transactions are A. 1260 B. 630630 C. 6 D. 63000
samir757
asked
in
Databases
Mar 9, 2021
by
samir757
29
points
62
views
databases
transactions
0
votes
0
answers
147
views
Past exam paper MSU 2020 Advanced databases
Given the following relations and SQL query: Student (sid, name, age, address, date of birth, level) Book(bid, title, author) Checkout(sid, bid, date_borrowed, date_returned) SELECT S.sid, S.level, C.date_borrowed, C.date_returned FROM Student ... query using a Relation Connection Graph.[5 marks] d) Represent the query above using a query tree. [5 marks]
Drackelyone
asked
in
Databases
Mar 6, 2021
by
Drackelyone
5
points
147
views
databases
1
vote
2
answers
158
views
Made easy workbook
Suppose we have two entity sets person, Email and use a relationship Owns. A person own atmost one email account but an email account can be owned by multiple persons. Which of the following is an ER diagram based on above description.
IrfanRza
asked
in
Databases
Mar 2, 2021
by
IrfanRza
9
points
158
views
databases
1
vote
1
answer
143
views
Self Doubt regarding ER diagram
What is degree of Self Referential Relationship? Unary or Binary?
adas7099
asked
in
Databases
Feb 24, 2021
by
adas7099
9
points
143
views
self-doubt
sql
databases
3
votes
3
answers
88
views
Made easy self dought
Q. R(A,B,C,D,E,F) with {A,BC,CD} candidate keys.How many super keys possible?
Enolx.21
asked
in
Databases
Feb 23, 2021
by
Enolx.21
53
points
88
views
self-doubt
databases
0
votes
0
answers
55
views
How to convert this problem statement to ER model
Can Somebody know how to design ER Diagram from this ?
ghostman23111
asked
in
Databases
Feb 21, 2021
by
ghostman23111
5
points
55
views
databases
sql
4
votes
4
answers
963
views
GATE CSE 2021 Set 2 | Question: 6 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
963
views
gate2021-cse-set2
databases
relational-model
1
vote
2
answers
564
views
GATE CSE 2021 Set 2 | Question: 31 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
564
views
gate2021-cse-set2
databases
sql
easy
0
votes
2
answers
715
views
GATE CSE 2021 Set 2 | Question: 32 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
715
views
gate2021-cse-set2
databases
transaction-and-concurrency
conflict-serializable
0
votes
1
answer
617
views
GATE CSE 2021 Set 2 | Question: 40 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
617
views
gate2021-cse-set2
multiple-selects
databases
database-normalization
5
votes
2
answers
1.0k
views
GATE CSE 2021 Set 1 | Question: 13 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
1.0k
views
gate2021-cse-set1
multiple-selects
databases
transaction-and-concurrency
1
vote
1
answer
1.7k
views
GATE CSE 2021 Set 1 | Question: 23 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
1.7k
views
gate2021-cse-set1
databases
sql
numerical-answers
0
votes
1
answer
520
views
GATE CSE 2021 Set 1 | Question: 27 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
520
views
gate2021-cse-set1
databases
relational-algebra
3
votes
3
answers
487
views
GATE CSE 2021 Set 1 | Question: 32 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
487
views
gate2021-cse-set1
databases
transaction-and-concurrency
conflict-serializable
1
vote
5
answers
940
views
GATE CSE 2021 Set 1 | Question: 33 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
940
views
gate2021-cse-set1
databases
database-normalization
lossless-decomposition
1
vote
0
answers
48
views
Gate 2020 question
Consider a database implemented using B+ tree for file indexing and installed on a disk drive with block size of 4 KB. The size of search key is 12 bytes and the size of tree/disk pointer is 8 bytes. Assume that the database has one million ... each record fits into one disk block. The minimum number of disk accesses required to retrieve any record in the database is ______.
Enolx.21
asked
in
Databases
Feb 13, 2021
by
Enolx.21
53
points
48
views
self-doubt
databases
0
votes
0
answers
39
views
Made easy test
In this question, it is asked to retrieve the name of each employee who has a dependent with the same first name and is the same sex as employee. How Q1 will give the correct result, coz inside IN() the condition Essn=D,Essn is not there. Can anybody explain.
Ankita87077
asked
in
Databases
Feb 6, 2021
by
Ankita87077
11
points
39
views
test-series
databases
0
votes
0
answers
70
views
Made easy test series
Consider the following table: A B C a1 b1 c1 a1 b1 c2 a2 b1 c1 a2 b1 c3 Number of non-trivial functional dependencies exists in the above Table ___________.
vikashrajpoot0100
asked
in
Databases
Feb 4, 2021
by
vikashrajpoot0100
5
points
70
views
normalization
databases
test-series
0
votes
0
answers
51
views
self doubt Databases : What do partial dependencies really mean ?
ashutoshbsathe
asked
in
Databases
Feb 2, 2021
by
ashutoshbsathe
5
points
51
views
databases
normalization
Page:
1
2
3
4
...
15
next »
Ask a Question
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Recent Posts
New GATEOverflow PDFs
Guidelines to users
No Recent Blog Comments
Search GATE CSE Doubts