menu
Recent questions and answers in Databases
Login
Register
My account
Edit my Profile
Private messages
My favorites
Register
Recent questions and answers in Databases
All Activity
Q&A
Questions
Unanswered
Tags
Categories
Users
Ask a Question
Blogs
Previous Year
Recent questions and answers in Databases
0
votes
1
answer
192
views
DBMS Relations
Consider the following assumptions for the relation employee( eid , ename,dept,grade,sal,age,address) and find the candidate key of the relation. I. Each employee has unique id. II. An employee can work on one dept only III. Employees salary depends on his age and grade ... salary or can be of same age. a.eid only b.eid,(age,address) c.(grade,age) d.eid,dept Anyone please clarify.
anirbanroy.c
answered
in
Databases
May 25
by
anirbanroy.c
5
points
192
views
databases
0
votes
0
answers
45
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
45
views
databases
self-doubt
0
votes
0
answers
49
views
self study
if a relation is given and no fds are given then it is in which form?
deep_bansal_04
asked
in
Databases
Aug 8, 2021
by
deep_bansal_04
5
points
49
views
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
36
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
36
views
self-doubt
databases
0
votes
0
answers
45
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
45
views
databases
normalization
0
votes
0
answers
91
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
91
views
databases
er-diagram
0
votes
0
answers
20
views
#self-doubt dbms confused between navathe or korth or raghuramakrishnan
ykrishnay
asked
in
Databases
Jun 27, 2021
by
ykrishnay
103
points
20
views
databases
0
votes
0
answers
108
views
Made Easy DBMS Practice Set - Normalisation - Question 53
10nikhilsharma01
asked
in
Databases
Jun 14, 2021
by
10nikhilsharma01
9
points
108
views
normalization
0
votes
0
answers
81
views
Made Easy DBMS practice set - Normalization - Question 45
10nikhilsharma01
asked
in
Databases
Jun 14, 2021
by
10nikhilsharma01
9
points
81
views
normalization
0
votes
1
answer
65
views
ACE Academy Test series gate 2021
Consider the following relation R(XYZ) with X as the primary key and Z as the foreign key referencing X with a delete cascade. X Y Z X1 Y1 X7 X3 Y1 X2 X5 Y4 X3 X2 Y2 X1 X9 Y5 X3 X7 Y3 X8 X4 Y2 X2 Suppose tuple (X2, Y2, X1) is deleted, as a result what will be the number of tuples in R after deletion?
Subhajit Panday
answered
in
Databases
Jun 9, 2021
by
Subhajit Panday
11
points
65
views
ace-academy-test-series
0
votes
1
answer
90
views
Ace Academy test series gate 2021
A relation R (ABCDE) with functional dependency F= {AB ->CD, A->E, C->D} The decomposition of R into R1(ABC), R2(BCD) and R3(CDE) (i) lossless join (ii) lossy decomposition (iii) dependency preserving (iv) not dependency preserving (A) i & ii (B) i & iv (C) ii & iii (D) ii & iv
Subhajit Panday
answered
in
Databases
Jun 9, 2021
by
Subhajit Panday
11
points
90
views
ace-academy-test-series
0
votes
1
answer
41
views
How to draw the serializability graph if transactions are getting commited
Subhajit Panday
answered
in
Databases
Jun 7, 2021
by
Subhajit Panday
11
points
41
views
databases
1
vote
1
answer
44
views
Tga test series
It is 2NF or not ? Just explain this portion.
Deepak Poonia
answered
in
Databases
Jun 2, 2021
by
Deepak Poonia
1.7k
points
44
views
self-doubt
databases
database-normalization
0
votes
0
answers
43
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
43
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
44
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
44
views
self-doubt
databases
e-r-diagram
1
vote
1
answer
91
views
Normalization,2NF
Suppose, R(ABCDE) is a relation, and {AB,CD} are the candidate keys, then: the functional dependency, AC->E a partial dependency? Edit: Actually i wanted to ask if AC->E is in 2NF?
Deepak Poonia
answered
in
Databases
May 24, 2021
by
Deepak Poonia
1.7k
points
91
views
normalization
1
vote
2
answers
173
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.
immanujs
answered
in
Databases
May 12, 2021
by
immanujs
5
points
173
views
databases
0
votes
0
answers
59
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
59
views
databases
self-doubt
0
votes
1
answer
76
views
Previous year question paper
Consider the following set of Functional dependencies for relational schema R{A,B,C} F={A->BC, B->C, A->B, AB->C} (i) Find the key of relation R
zimgateoverflow
answered
in
Databases
Apr 25, 2021
by
zimgateoverflow
5
points
76
views
programming
0
votes
0
answers
76
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
76
views
self-doubt
databases
0
votes
1
answer
76
views
self doubt database management system
is it true that “every strict schedule is cascadeless schedule”?
Konan-kun
answered
in
Databases
Apr 17, 2021
by
Konan-kun
71
points
76
views
self-doubt
databases
transaction
0
votes
0
answers
90
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
90
views
databases
normalization
1
vote
1
answer
157
views
Self Doubt regarding ER diagram
What is degree of Self Referential Relationship? Unary or Binary?
holla
answered
in
Databases
Mar 12, 2021
by
holla
5
points
157
views
self-doubt
sql
databases
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
3
votes
3
answers
89
views
Made easy self dought
Q. R(A,B,C,D,E,F) with {A,BC,CD} candidate keys.How many super keys possible?
Devhaan
answered
in
Databases
Mar 6, 2021
by
Devhaan
5
points
89
views
self-doubt
databases
0
votes
0
answers
47
views
Gate Applied test series
Love Barot
asked
in
Databases
Mar 3, 2021
by
Love Barot
7
points
47
views
natural-join
0
votes
0
answers
30
views
Data base management system
Hello sir/mam, Today I've been told by our sir that we can write into ROM. Is that specified for mobile ROM or Computer ones or none of them please do clarify my doubt!
Sai Manognya
asked
in
Databases
Feb 27, 2021
by
Sai Manognya
5
points
30
views
self-doubt
0
votes
0
answers
58
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
58
views
databases
sql
0
votes
0
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
0
votes
0
answers
565
views
GATE CSE 2021 Set 2 | Question: 31 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
565
views
gate2021-cse-set2
databases
sql
easy
0
votes
0
answers
725
views
GATE CSE 2021 Set 2 | Question: 32 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
725
views
gate2021-cse-set2
databases
transaction-and-concurrency
conflict-serializable
0
votes
0
answers
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
0
votes
0
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
0
answers
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
0
answers
522
views
GATE CSE 2021 Set 1 | Question: 27 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
522
views
gate2021-cse-set1
databases
relational-algebra
0
votes
0
answers
488
views
GATE CSE 2021 Set 1 | Question: 32 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
488
views
gate2021-cse-set1
databases
transaction-and-concurrency
conflict-serializable
0
votes
0
answers
941
views
GATE CSE 2021 Set 1 | Question: 33 | Video Solution
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
1.4k
points
941
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
To see more, click for all the
questions in this category
.
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.
Top Users
2022 Jun 20 - 26
Weekly Top User (excluding moderators) will get free access to
GATE Overflow Test Series for GATE 2021
Recent Posts
New GATEOverflow PDFs
Guidelines to users
No Recent Blog Comments
Recent questions and answers in Databases
Search GATE CSE Video Solutions