The Gateway to Computer Science Excellence
For all GATE CSE Questions
Toggle navigation
Email or Username
Password
Remember
Login
Register

I forgot my password
Activity
Questions
Unanswered
Tags
Subjects
Users
Ask
Prev
Blogs
New Blog
Exams
Recent questions tagged relationalmodel
+3
votes
2
answers
1
UGCNETJune2019II: 32
Which of the following features is supported in the rational database model? Complex datatypes Multivalued attributes Associations with multiplicities Generalization relationships
asked
Jul 3, 2019
in
Databases
by
Arjun

663
views
ugcnetjune2019ii
relationalmodel
0
votes
1
answer
2
Doubt
Do we need to find closure of functional dependencies of original relation to check whether the decomposed tables are in 2NF . I know that we have to do the above process for 3NF and BCNF . If yes , please give a example where we need to do it
asked
Mar 31, 2019
in
Databases
by
ashunimbz

66
views
databasenormalization
relationalmodel
0
votes
1
answer
3
DBMS Korth Edition 6 Exercise 3 Question 24 (Page No. 111)
Consider the query: with dept total (dept name, value) as (select dept name, sum(salary) from instructor group by dept name), dept total avg(value) as (select avg(value) from dept total) select dept name from dept total, dept total avg where dept total.value >= dept total avg.value; Rewrite this query without using the with construct.
asked
Mar 30, 2019
in
Databases
by
ajaysoni1924

127
views
databases
korthedition6
relationalmodel
sql
0
votes
0
answers
4
DBMS Korth Edition 6 Exercise 3 Question 23 (Page No. 111)
Consider the query: select course id, semester, year, sec id, avg (tot cred) from takes natural join student where year = 2009 group by course id, semester, year, sec id having count (ID) >= 2; Explain why joining section as well in the from clause would not change the result.
asked
Mar 30, 2019
in
Databases
by
ajaysoni1924

74
views
databases
korthedition6
relationalmodel
sql
descriptive
0
votes
1
answer
5
DBMS Korth Edition 6 Exercise 3 Question 22 (Page No. 110)
Rewrite the where clause where unique (select title from course) without using the unique construct.
asked
Mar 30, 2019
in
Databases
by
ajaysoni1924

64
views
databases
korthedition6
relationalmodel
sql
descriptive
0
votes
0
answers
6
DBMS Korth Edition 6 Exercise 6 Question 17 (Page No. 254)
Let R = (A, B) and S = (A, C), and let r (R) and s(S) be relations. Write SQL Queries equivalent to the following domain relational calculus expressions: a. {< a >  $\exists b (< a, b > \epsilon¸r \wedge b$ = 17)} b. ... ))}
asked
Mar 30, 2019
in
Databases
by
ajaysoni1924

45
views
databases
korthedition6
relationalmodel
relationalcalculus
sql
0
votes
0
answers
7
DBMS Korth Edition 6 Exercise 7 Question 25 (Page No. 321)
Consider the relation schemas are shown below, which were generated from the ER diagram in Figure given below. For each schema, specify what foreign key constraints, if any, should be created. teaches (ID, course id, sec id, semester, ... room number) inst dept (ID, dept name) stud dept (ID, dept name) course dept (course id, dept name)
asked
Mar 30, 2019
in
Databases
by
ajaysoni1924

113
views
databases
korthedition6
relationalmodel
erdiagram
descriptive
0
votes
0
answers
8
DBMS Korth Edition 6 Exercise 6 Question 18 (Page No. 254)
Let R = (A, B) and S = (A, C), and let r (R) and s(S) be relations. Using the special constant null, write tuplerelationalcalculus expressions equivalent to each of the following: a. r $ROJ$ s b. r $FOJ$ s c. r $LOJ$ s
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

66
views
databases
korthedition6
relationalmodel
relationalalgebra
relationalcalculus
0
votes
0
answers
9
DBMS Korth Edition 6 Exercise 6 Question 19 (Page No. 254)
Give a tuplerelationalcalculus expression to find the maximum value in relation r (A).
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

88
views
databases
korthedition6
relationalmodel
relationalcalculus
0
votes
0
answers
10
DBMS Korth Edition 6 Exercise 6 Question 16 (Page No. 254)
Let R = (A, B) and S = (A, C), and let r (R) and s(S) be relations. Write relationalalgebra expressions equivalent to the following domainrelational calculus expressions: a. {< a >  ∃ b (< a, b > ∈ r ∧ b = 17)} b. {< a, b, c >  ... < a, c > ∈ s ∧ ∃ b1, b2 (< a, b1 > ∈ r ∧ < c, b2 > ∈ r ∧ b1 > b2))}
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

70
views
databases
korthedition6
relationalmodel
relationalcalculus
relationalalgebra
0
votes
0
answers
11
DBMS Korth Edition 6 Exercise 6 Question 15 (Page No. 253254)
Consider the employee database shown here. Give expressions in tuple relational calculus and domain relational calculus for each of the following queries: a. Find the names of all employees who work for First Bank Corporation . b ... (person name, company name, salary) company (company name, city) manages (person name, manager name)
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

107
views
databases
korthedition6
relationalmodel
relationalalgebra
relationalcalculus
tuplerelationalcalculus
0
votes
0
answers
12
DBMS Korth Edition 6 Exercise 6 Question 14 (Page No. 253)
Consider the following relational schema for a library: member(memb_no, name, dob) books(isbn, title, authors, publisher) borrowed(memb_no, isbn, date) Write the following queries in relational algebra. a. Find the names of members ... if a member does not borrow any books, then that member does not appear in the borrowed relation at all.
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

197
views
databases
korthedition6
relationalmodel
relationalalgebra
0
votes
0
answers
13
DBMS Korth Edition 6 Exercise 6 Question 13 (Page No. 253)
Consider the relational database shown here. Give a relationalalgebra expression for each of the following queries: a. Find the company with the most employees. b. Find the company with the smallest payroll. c. Find those ... works (person name, company name, salary) company (company name, city) manages (person name, manager name)
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

110
views
databases
korthedition6
relationalalgebra
relationalmodel
0
votes
0
answers
14
DBMS Korth Edition 6 Exercise 6 Question 12 (Page No. 253)
Using the university example, write relationalalgebra queries to find the course sections taught by more than one instructor in the following ways: a. Using an aggregate function. b. Without using any aggregate functions.
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

76
views
databases
korthedition6
relationalmodel
relationalalgebra
0
votes
0
answers
15
DBMS Korth Edition 6 Exercise 6 Question 11 (Page No. 252)
Consider the relational database shown here, where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all employees who work for First Bank ... works (person name, company name, salary) company (company name, city) manages (person name, manager name)
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

280
views
databases
korthedition6
relationalmodel
relationalalgebra
0
votes
0
answers
16
DBMS Korth Edition 6 Exercise 6 Question 10 (Page No. 252)
Write the following queries in relational algebra, using the university schema. a. Find the names of all students who have taken at least one Comp. Sci. course. b. Find the IDs and names of all students who have ... instructor. d. Find the lowest, across all departments, of the perdepartment maximum salary computed by the preceding query.
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

82
views
databases
korthedition6
relationalmodel
relationalalgebra
0
votes
0
answers
17
DBMS Korth Edition 6 Exercise 6 Question 9 (Page No. 252)
Describe how to translate join expressions in SQL to relational algebra.
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

71
views
databases
korthedition6
relationalmodel
relationalalgebra
sql
0
votes
1
answer
18
DBMS Korth Edition 6 Exercise 6 Question 8 (Page No. 251)
Consider the relational database given below where the primary keys are underlined. Give an expression in tuple relational calculus for each of the following queries: a. Find all employees who work directly for Jones. b. Find all ... works (person name, company name, salary) company (company name, city) manages (person name, manager name)
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

133
views
databases
korthedition6
relationalmodel
relationalalgebra
relationalcalculus
tuplerelationalcalculus
0
votes
0
answers
19
DBMS Korth Edition 6 Exercise 6 Question 7 (Page No. 251)
Let R = (A, B) and S = (A,C), and let r (R) and s(S) be relations.Write expressions in relational algebra for each of the following queries: a. {< a >  ∃ b (< a, b > ∈ r ∧ b = 7)} b. {< a, b, c >  < a, b > ∈ r ∧ < ...  ∃ c (< a, c > ∈ s ∧ ∃ b1, b2 (< a, b1 > ∈ r ∧ < c, b2 > ∈ r ∧ b1 > b2))}
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

40
views
databases
korthedition6
relationalmodel
relationalalgebra
relationalcalculus
0
votes
0
answers
20
DBMS Korth Edition 6 Exercise 6 Question 5 (Page No. 251)
Let the following relation schemas be given: R = (A, B,C) S = (D, E, F) Let relations r(R) and s(S) be given. Give an expression in the tuple relational calculus that is equivalent to each of the following: a. $\prod _A(r)$ b. $\sigma _{B =17} (r )$ c. r × s d. $\prod _{A,F} (\sigma _{C = D}(r × s))$
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

50
views
databases
korthedition6
relationalmodel
relationalalgebra
0
votes
0
answers
21
DBMS Korth Edition 6 Exercise 6 Question 4 (Page No. 250)
(Division operation): The division operator of relational algebra, , is defined as follows. Let r (R) and s(S) be relations, and let S ⊆ R; that is, every attribute of schema S is also in schema R. ... using division. (By doing so, you would have shown how to define the division operation using the other relational algebra operations.)
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

31
views
databases
korthedition6
relationalmodel
relationalalgebra
0
votes
0
answers
22
DBMS Korth Edition 6 Exercise 6 Question 3 (Page No. 250)
The natural outerjoin operations extend the naturaljoin operation so that tuples from the participating relations are not lost in the result of the join. Describe how the thetajoin operation can be extended so that tuples from the left, right, or both relations are not lost from the result of a theta join.
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

52
views
databases
korthedition6
relationalalgebra
relationalmodel
0
votes
0
answers
23
DBMS Korth Edition 6 Exercise 6 Question 2 (Page No. 250)
Consider the relational database given below, where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all employees who live in the same ... works (person name, company name, salary) company (company name, city) manages (person name, manager name)
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

62
views
databases
korthedition6
relationalmodel
relationalalgebra
0
votes
0
answers
24
DBMS Korth Edition 6 Exercise 6 Question 1 (Page No. 249)
Write the following queries in relational algebra, using the university schema. a. Find the titles of courses in the Comp. Sci. department that have 3 credits. b. Find the IDs of all students who were taught by an ... enrollment, across all sections, in Autumn 2009. g. Find the sections that had the maximum enrollment in Autumn 2009.
asked
Mar 27, 2019
in
Databases
by
ajaysoni1924

47
views
databases
korthedition6
relationalmodel
relationalalgebra
0
votes
0
answers
25
DBMS Korth Edition 6 Exercise 4 Question 17 (Page No. 155)
Explain why, when a manager, say Satoshi, grants an authorization, the grant should be done by the manager role, rather than by the user Satoshi.
asked
Mar 26, 2019
in
Databases
by
ajaysoni1924

42
views
databases
korthedition6
relationalmodel
sql
0
votes
0
answers
26
DBMS Korth Edition 6 Exercise 4 Question 16 (Page No. 155)
Referentialintegrity constraints as defined generally involve exactly two relations. Consider a database that includes the relations shown below . Suppose that we wish to require that every name that appears in address appears in either ... (name, office, phone, salary) hourly worker (name, hourly wage) address (name, street, city)
asked
Mar 26, 2019
in
Databases
by
ajaysoni1924

59
views
databases
korthedition6
relationalmodel
sql
0
votes
0
answers
27
DBMS Korth Edition 6 Exercise 4 Question 14 (Page No. 155)
Show how to define a view tot credits (year, num credits), giving the total number of credits taken by students in each year.
asked
Mar 26, 2019
in
Databases
by
ajaysoni1924

37
views
databases
korthedition6
relationalmodel
sql
0
votes
0
answers
28
DBMS Korth Edition 6 Exercise 4 Question 13 (Page No. 155)
Under what circumstances would the query select * from student natural full outer join takes natural full outer join course include tuples with null values for the title attribute?
asked
Mar 26, 2019
in
Databases
by
ajaysoni1924

76
views
databases
korthedition6
relationalmodel
sql
0
votes
0
answers
29
DBMS Korth Edition 6 Exercise 4 Question 12 (Page No. 155)
For the database shown below, write a query to find those employees with no manager. Note that an employee may simply have no manager listed or may have a null manager. Write your query using an outer join and then write ... city) works (employee name, company name, salary) company (company name, city) manages (employee name, manager name)
asked
Mar 26, 2019
in
Databases
by
ajaysoni1924

36
views
databases
korthedition6
relationalmodel
sql
0
votes
0
answers
30
DBMS Korth Edition 6 Exercise 4 Question 10 (Page No. 154)
SQL provides an nary operation called coalesce, which is defined as follows: coalesce(A1, A2, . . . , An) returns the first non null Ai in the list A1, A2, . . . , An, and returns null if all of A1, A2, . . ... name and address, and that the solution is correct even if some tuples in a and b have null values for attributes name or address.
asked
Mar 26, 2019
in
Databases
by
ajaysoni1924

61
views
databases
korthedition6
relationalmodel
sql
Page:
1
2
3
next »
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
Recent Posts
IITD MS CSE (Systems) Experience
IIT Bombay M.Tech. (RA)  Interview Experience
Interview Experience for MS(R)IIT Delhi (School of Information Technology)
How am I preparing
PGEE 2020 (CSE) Experience
Subjects
All categories
General Aptitude
(2k)
Engineering Mathematics
(8.2k)
Digital Logic
(2.9k)
Programming and DS
(5k)
Algorithms
(4.4k)
Theory of Computation
(6.2k)
Compiler Design
(2.2k)
Operating System
(4.6k)
Databases
(4.2k)
CO and Architecture
(3.4k)
Computer Networks
(4.2k)
Non GATE
(1.2k)
Others
(1.5k)
Admissions
(595)
Exam Queries
(562)
Tier 1 Placement Questions
(23)
Job Queries
(71)
Projects
(19)
Unknown Category
(1k)
Recent questions tagged relationalmodel
Recent Blog Comments
Please add this one in the list too! IISc CDS...
Very helpful. can't thank you enough! :) :)
@toxicdesire I don't remember the exact...
Will you please tell what they answered to your...
@commenter max marks for part A was 75. They did...
Network Sites
GO Mechanical
GO Electrical
GO Electronics
GO Civil
CSE Doubts
52,345
questions
60,510
answers
201,919
comments
95,350
users