Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
DBMS Korth Edition 6 Exercise 6 Question 9 (Page No. 252)
ajaysoni1924
asked
in
Databases
Mar 26, 2019
edited
Mar 26, 2019
by
ajaysoni1924
306
views
0
votes
0
votes
Describe how to translate join expressions in SQL to relational algebra.
databases
korth-edition6
relational-model
relational-algebra
sql
ajaysoni1924
asked
in
Databases
Mar 26, 2019
edited
Mar 26, 2019
by
ajaysoni1924
by
ajaysoni1924
306
views
answer
comment
Follow
share this
share
0 Comments
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
0
Answers
← Previous
Next →
← Previous in category
Next in category →
Related questions
0
votes
0
votes
0
answers
1
ajaysoni1924
asked
in
Databases
Mar 26, 2019
976
views
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)
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
976
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
votes
0
answers
2
ajaysoni1924
asked
in
Databases
Mar 26, 2019
322
views
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 per-department maximum salary computed by the preceding query.
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
322
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
votes
0
answers
3
ajaysoni1924
asked
in
Databases
Mar 23, 2019
265
views
DBMS Korth Edition 6 Exercise 2 Question 9 (Page No. 55)
Consider the bank database given below. a. What are the appropriate primary keys? b. Given your choice of primary keys, identify appropriate foreign keys. branch(branch name, branch city, assets) customer (customer name, ... (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number)
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
265
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
votes
0
answers
4
ajaysoni1924
asked
in
Databases
Mar 26, 2019
229
views
DBMS Korth Edition 6 Exercise 4 Question 9 (Page No. 154)
SQL allows a foreign-key dependency to refer to the same relation, as in the following example: create table manager (employee name varchar(20) not null manager name varchar(20) not null, primary key employee name, foreign ... every manager also be an employee. Explain exactly what happens when a tuple in the relation manager is deleted.
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
229
views
databases
korth-edition6
relational-model
sql
Subscribe to GATE CSE 2023 Test Series
Subscribe to GO Classes for GATE CSE 2023
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
From Rank 4200 to 64: My Journey to Success in GATE CSE Exam
What are the key things to focus on during the final 10-15 days before the GATE exam to improve performance?
All India GO Classes Mock test
NTA UGC NET JRF December 2022 Apply Online Form 2023
Life happens, just chill and do hardwork
Subjects
All categories
General Aptitude
(2.5k)
Engineering Mathematics
(9.3k)
Digital Logic
(3.3k)
Programming and DS
(5.8k)
Algorithms
(4.6k)
Theory of Computation
(6.7k)
Compiler Design
(2.3k)
Operating System
(5.0k)
Databases
(4.6k)
CO and Architecture
(3.8k)
Computer Networks
(4.6k)
Non GATE
(1.3k)
Others
(2.4k)
Admissions
(649)
Exam Queries
(842)
Tier 1 Placement Questions
(17)
Job Queries
(74)
Projects
(9)
Unknown Category
(853)
Recent Blog Comments
I want to buy the test series today but I want to...
@mahendrapatel The more you give those (some...
@ChatGPT bhai muze vo test bhi dena tha...
AIMT is live now:...
It is at 9:30. Test Link will be available at...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy
