Dark Mode

Recent questions tagged rdbms

0 votes

0 answers

1

Ace workbook dbms

gaddalakonda_ganesh asked in Databases Feb 28

by gaddalakonda_ganesh

118 views

2 votes

1 answer

2

Who manages what? (ACID peoperties)
Which manager manages each of the ACID properties? I found that transaction processing (TP) manager manages Isolation from wikipedia, meanwhile I read from another source that it is managed by concurrency control manager. Also what about the other ... which managers control them? Can you please list down the managers of the properties or any sources know to you?

h4kr asked in Databases Dec 19, 2022

by h4kr

174 views

0 votes

0 answers

3

selfdoubt
can a relationship have a degree of one if both the entities are same and participating in one form? ex: employee helps employee

Khushi vishwakarma asked in Databases Nov 16, 2022

by Khushi vishwakarma

101 views

0 votes

0 answers

4

DBMS -- Book Confusion
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 for all topics. please suggest .

ykrishnay asked in Databases Sep 6, 2022

150 views

0 votes

1 answer

5

DBMS Join | Test Series | MadeEasy
In relational databases, the natural join of two tables: Can be equivalent to cartesian product of these two tables Is combination of union and filtered cartesian product Is combination of selection and filtered cartesian product Is combination of projection and filtered cartesian product MSQ Please describe your choice(s).

anupamsworld asked in Databases Aug 7, 2022

by anupamsworld

166 views

1 vote

0 answers

6

Finding Candidate Keys | Class Practice | Unacademy
Find the candidate key(s) of the relation R(UVWXYZ) with FD set F={UV-->W, XW-->Y, U-->XZ, Y-->U} XW UV, YV, WXV YUV, XV, WV None of these

anupamsworld asked in Databases Jul 29, 2022

by anupamsworld

219 views

1 vote

2 answers

7

Minimum number of tables needed to construct a self referential relation with many to many relationship?

Srken asked in Databases Nov 13, 2021

by Srken

911 views

1 vote

2 answers

8

gradeup quiz question
please explain the question

ajay_rajpurohit asked in Databases Oct 4, 2021

by ajay_rajpurohit

271 views

0 votes

1 answer

9

#DBMS #dependency
What is the number of redundent FD’s possible for given set of FD , A->B, B->C,C->D for relation R(ABCD)?? please explain in detail.

Abhishek tarpara asked in Databases Sep 17, 2021

by Abhishek tarpara

517 views

4 votes

4 answers

10

Doubt on database normalization for relation having all prime attributes
In a relation, if every attribute is prime but key may not be simple then the relation is in ______. A. 1NF B. 2NF C. 3NF D. BCNF

Tuhin Dutta asked in Databases May 27, 2019

2.1k views

0 votes

1 answer

11

VANI Question Bank :DBMS
Minimum number of tables required to represent the relation R where the $A_n$ stands for the primary key of each entity is ___________

Hirak asked in Databases May 25, 2019

by Hirak

476 views

0 votes

2 answers

12

MADE EASY FREE TEST Q47
Find the total number of tables required. Ans given was 4, bit how can it be 4? According to me, E1 and E2 will require 2 tables at begining, then for E3 and E1 we need another table, then for E2 and E3 we need another and for E3 and E2’s many to many relation i need another one. So total =5. But ans given was 4.. explain pls.

Hirak asked in Databases May 4, 2019

by Hirak

261 views

0 votes

0 answers

13

DBMS Korth Edition 6 Exercise 2 Question 4 (Page No. 53)
In the instance of instructor shown below, no two instructors have the same name. From this, can we conclude that name can be used as a superkey (or primary key) of instructor?

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

373 views

0 votes

0 answers

14

ER Diagram
How 1:1 cardinality with total participation of atleast 1 entity needs min no. of tables = 1 ? 1:1 with partial participation of both entities needs min no of tables = 2?

Shamim Ahmed asked in Databases Dec 18, 2018

by Shamim Ahmed

250 views

0 votes

0 answers

15

Database Management System
If NO ATTRIBUTES are common in both relations (R and S) then the result of natural join is ?? a. Empty relation. b. Cartesian Product of the relations.

cidacoder asked in Databases Dec 8, 2018

191 views

0 votes

5 answers

16

UGC NET CSE | July 2018 | Part 2 | Question: 61
In RDBMS, which type of Join returns all rows that satisfy the join condition? Inner Join Outer Join Semi Join Anti Join

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

1.4k views

0 votes

2 answers

17

UGC NET CSE | July 2018 | Part 2 | Question: 62
Consider a relation book (title, price) which contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query? Select title from book as B where (select ... Title of the sixth most expensive books Titles of the seven most expensive books Title of the seventh most expensive books

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

1.6k views

0 votes

1 answer

18

UGC NET CSE | July 2018 | Part 2 | Question: 66
For a database relation $R(a, b, c, d)$ where the domains of a, b, c and d include only atomic values and only the following functional dependencies and those that can be inferred from them hold: $a \rightarrow c$ ... in ____ First normal form but not in second normal form Second normal form but not in third normal form Third normal form BCNF

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

612 views

2 votes

4 answers

19

UGC NET CSE | July 2018 | Part 2 | Question: 67
A many-to-one relationship exists between entity sets $r_1$ and $r_2$. How will it be represented using functional dependencies if $Pk(r)$ denotes the primary key attribute of relation $r$? $Pk(r_1) \rightarrow Pk(r_2)$ ... $Pk(r_2) \rightarrow Pk(r_1) \text{ or } Pk(r_1) \rightarrow Pk(r_2)$

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

759 views

1 vote

1 answer

20

2NF Question.
Given a table $R(ABCDEF)$ $ABC -> D$ $ABD -> E$ $CD -> F$ $CDF -> B$ $BF -> D$ It's candidate keys are $ABC, ACD.$ So while checking for $2NF$, Can I say that $ABD -> E$ is not partially dependent because $ABD$ as a whole is not a part of candidate key even though $AB$ is a part of candidate key.

Rahul Ranjan 1 asked in Databases May 27, 2018

by Rahul Ranjan 1

1.6k views

3 votes

2 answers

21

ER Diagram- min no of relations
How the correct answer is 2?

Shubham Kumar Gupta asked in Databases Jan 19, 2018

by Shubham Kumar Gupta

659 views

1 vote

0 answers

22

Can foreign key be renamed...if yes then what is the effect on relation?

Kamal Raj Praveen asked in Databases Jan 14, 2018

by Kamal Raj Praveen

203 views

2 votes

0 answers

23

database
what is the concept of nested loop join in database????????? link plz or give any example.

akankshadewangan24 asked in Databases Jan 12, 2018

by akankshadewangan24

131 views

0 votes

1 answer

24

ankitgupta.1729 asked in Databases Dec 17, 2017

by ankitgupta.1729

291 views

0 votes

1 answer

25

Number of tables
Number of tables required and also the attribute set of the tables

Mk Utkarsh asked in Databases Dec 12, 2017

294 views

3 votes

1 answer

26

MadeEasy Test Series: Databases - Er Diagram
In the solution they have merged E1 R4 E4 , E2 R3 E3 R5 , R6 E5. MY DOUBT IS , why cant we only merge R4 E4 instead of E1 R4 E4. since there is total participation on the E4 side of the relation and it would also decrease the number of attributes .

shaurya vardhan asked in Databases Dec 4, 2017

by shaurya vardhan

859 views

0 votes

1 answer

27

database self doubt
what does this line means - Let r and s be two relations over the relation schemes R and S respectively and R has attribute A.

iarnav asked in Databases Nov 27, 2017

by iarnav

245 views

6 votes

2 answers

28

One to one relationship with total participation of one entity. Can a single table be formed?
I am confused whether we need to have 2 tables or a single table when 2 strong entities are in 1:1 relationship with one having complete participation. Ex: How is it possible that we join Person and ... Bank Account may refer to some of the Person records which may go away on joining Person and License.

Ashish Sharma 3 asked in Databases Nov 24, 2017

by Ashish Sharma 3

10.1k views

5 votes

1 answer

29

Minimum relations required for ER diagram
How many minimum relations required for the above ER diagram? According to me it should be 7. Please let me know the answer according to you.

Ashish Sharma 3 asked in Databases Nov 24, 2017

by Ashish Sharma 3

2.2k views

Page:

Recent questions tagged rdbms