Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Search results for made-easy+databases
0
votes
1
answer
1
Made Easy Test Series
Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?
Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?
Mrityudoot
144
views
Mrityudoot
asked
Jan 12
Databases
made-easy-test-series
databases
functional-dependency
+
–
0
votes
1
answer
2
made-easy
Rohit Chakraborty
116
views
Rohit Chakraborty
asked
Jan 6
Databases
made-easy-test-series
databases
test-series
+
–
0
votes
6
answers
3
made easy test series
Consider a relation $R(ABCDEFGH)$. How many superkeys will be there in relation $R$ if the candidate keys for relation are ${A, BC, CDE, EF}$?
Consider a relation $R(ABCDEFGH)$.How many superkeys will be there in relation $R$ if the candidate keys for relation are ${A, BC, CDE, EF}$?
kaustubh7
858
views
kaustubh7
asked
Sep 20, 2023
Databases
databases
superkeys
database-normalization
made-easy-test-series
+
–
1
votes
1
answer
4
Made Easy
Amy and Bob are working on a project vehicle rental system, they have a file consisting of 10000 records, having block size 1024 bytes, record size 100 bytes. Search key size 9 bytes, pointer 7 bytes. They want to implement single level indexing. ... dense index, however Amy suggested to implement sparse index. How many blocks are saved by Amy considering only 1st level index ________?
Amy and Bob are working on a project vehicle rental system, they have a file consisting of 10000 records, having block size 1024 bytes, record size 100 bytes. Search key ...
suvasish114
460
views
suvasish114
asked
Dec 9, 2023
Databases
indexing
databases
file-system
made-easy-test-series
+
–
0
votes
1
answer
5
MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right? For example, in the above question - The ... the same below) Can anyone please explain whether I am approaching this right, or if I am missing something?
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right?For example, in the...
tishhaagrawal
407
views
tishhaagrawal
asked
Dec 16, 2023
Databases
databases
sql
query
gate-preparation
rdbms
doubt
made-easy-test-series
+
–
1
votes
1
answer
6
MADE EASY TEST SERIES
Unique not null is equivalent to primary key. Relational Algebra and SQL has same expressive power. Which of the above statements are False?
Unique not null is equivalent to primary key.Relational Algebra and SQL has same expressive power.Which of the above statements are False?
Sajal Mallick
355
views
Sajal Mallick
asked
Nov 5, 2023
Databases
made-easy-test-series
databases
sql
true-false
+
–
0
votes
0
answers
7
Made easy DBMS
amitarp818
215
views
amitarp818
asked
Dec 5, 2023
Databases
made-easy-test-series
databases
conflict-serializable
+
–
0
votes
0
answers
8
Made easy DBMS
amitarp818
172
views
amitarp818
asked
Dec 5, 2023
Databases
made-easy-test-series
databases
+
–
0
votes
0
answers
9
madeeasy ots
Sajal Mallick
175
views
Sajal Mallick
asked
Nov 20, 2023
Databases
made-easy-test-series
transaction-and-concurrency
conflict-serializable
databases
+
–
0
votes
0
answers
10
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.
Sajal Mallick
178
views
Sajal Mallick
asked
Nov 20, 2023
Databases
made-easy-booklet
databases
transaction-and-concurrency
conflict-serializable
+
–
0
votes
0
answers
11
ER Diagram
Can someone please provide me with the correct explanation for this question
Can someone please provide me with the correct explanation for this question
practicalmetal
374
views
practicalmetal
asked
Oct 26, 2023
Databases
er-diagram
databases
made-easy-test-series
er-to-relational
+
–
0
votes
1
answer
12
madeeasy
nihal_chourasiya
219
views
nihal_chourasiya
asked
Oct 14, 2023
Databases
made-easy-test-series
databases
+
–
0
votes
2
answers
13
MADE EASY TEST SERIES
Consider the following relations and query given below: Emp( Id, Name, Sex, Salary) Proj(No, Name, Dno) and Works_on(No, IDs) contains atleast one tuples. Consider the following query: Select Name From Emp Where NOT Exists ((Select No From Proj where Dno = 106) EXCEPT (select No from works_on where Id = IDs)); What does this query return?
Consider the following relations and query given below:Emp( Id, Name, Sex, Salary)Proj(No, Name, Dno) andWorks_on(No, IDs) contains atleast one tuples.Consider the follow...
learner 2102
526
views
learner 2102
asked
Jan 5, 2022
Databases
databases
made-easy-test-series
sql
+
–
0
votes
2
answers
14
Made Easy Test Series | 3NF | True/False
A relation is in 3NF if every non-prime attribute of R is fully functionally reliant on every key of R TRUE FALSE
A relation is in 3NF if every non-prime attribute of R is fully functionally reliant on every key of RTRUEFALSE
Souvik33
530
views
Souvik33
asked
Jan 14, 2023
Databases
made-easy-test-series
databases
true-false
+
–
1
votes
1
answer
15
Made easy || Database
Consider a relation schema r(A, B, C, D, E, F) and attribute A is element of every candidate key of r. Maximum number of possible candidate keys of r is ________.
Consider a relation schema r(A, B, C, D, E, F) and attribute A is element of every candidate key of r. Maximum number of possible candidate keys of r is ________.
Shreya2002
1.5k
views
Shreya2002
asked
Aug 9, 2022
Databases
made-easy-test-series
databases
candidate-key
+
–
1
votes
1
answer
16
MadeEasy Test Series 2018: Databases - Relational Algebra
Consider the following database table Supplier (Sid, Sname, rating) Parts (Pid, Pname, color) Catalog (Sid Pid, cost) Which of the following SQL query correct representation to retrieve Sid’s who supplied every red part.
Consider the following database tableSupplier (Sid, Sname, rating)Parts (Pid, Pname, color)Catalog (Sid Pid, cost)Which of the following SQL query correct representation ...
nikkey123
1.6k
views
nikkey123
asked
Jan 29, 2018
Databases
databases
relational-algebra
made-easy-test-series
+
–
0
votes
1
answer
17
Databases
Somebody please verify the answer
Somebody please verify the answer
Overflow04
403
views
Overflow04
asked
Jul 6, 2022
Databases
databases
made-easy-test-series
database-normalization
+
–
0
votes
0
answers
18
Databases
What is the meaning of first option
What is the meaning of first option
Overflow04
337
views
Overflow04
asked
Jul 6, 2022
Databases
databases
made-easy-test-series
database-normalization
+
–
0
votes
2
answers
19
MadeEasy Subject Test: Databases - Sql
Arnabi
391
views
Arnabi
asked
Jan 28, 2017
Databases
databases
sql
made-easy-test-series
+
–
1
votes
2
answers
20
MadeEasy Workbook: Databases - Er Diagram
The minimum number of tables needed to represent M,N,P,R1,R2 is … The given ans is 2. I think the ans should be 3.
The minimum number of tables needed to represent M,N,P,R1,R2 is …The given ans is 2.I think the ans should be 3.
Harsh Kumar
1.1k
views
Harsh Kumar
asked
Dec 11, 2018
Databases
databases
er-diagram
made-easy-booklet
+
–
Page:
1
2
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register