Time Left - 10:00 mins
GATE CS 2018 - Database Quiz- 4 (Relational Algebra)
Attempt now to get your rank among 521 students!
Question 1
Consider the following relational database: employee(e-name, street, city)
works(e-name, c-name, salary)
company(c-name, city)
manages(e-name, m-name)
Query: Find the name of all the employees who works in First Corporation bank.
Which of the following is true wrt to tuple relational calculus.
works(e-name, c-name, salary)
company(c-name, city)
manages(e-name, m-name)
Query: Find the name of all the employees who works in First Corporation bank.
Which of the following is true wrt to tuple relational calculus.
Question 2
Consider two relations 
and 
where 
Find the number of attributes that appears in R/S.
and where Find the number of attributes that appears in R/S. Question 3
Consider the selection of the form σA≤100 (r) where r is a relation with 1000 tuples. Assume attribute values of A among the tuples are uniformly distributed in interval [1, 500]. Finds the number of tuples return by given query.
Question 4
Consider a banking database with following relation loan(branchName, loan_no, amount)
Find the loan number of each loan where an amount is greater than 10000.
Find the loan number of each loan where an amount is greater than 10000.
Question 5
The following functional dependencies hold for relations R(A, B, C) and S(B, D, E)
B
A,
A
C
The relation R contains 200 tuples and the relation S contains 100tuples. What is the maximum number of tuples possible in the natural join R
S?
B
A, A
C The relation R contains 200 tuples and the relation S contains 100tuples. What is the maximum number of tuples possible in the natural join R
S? - 521 attempts
- 1 upvote
- 9 comments
Tags :
GATE & PSU CSDatabasesMar 30GATE & PSU CS
