Register

DBMS Korth Edition 6 Exercise 4 Question 2 (Page No. 152)

266 views
0 votes
0 votes
Outer join expressions can be computed in SQL without using the SQL
outer join operation. To illustrate this fact, show how to rewrite each of the
following SQL queries without using the outer join expression.

a. select* from student natural left outer join takes
b. select* from student natural full outer join takes
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
2
ajaysoni1924 asked Mar 26, 2019
373 views
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.
Explain why, when a manager, say Satoshi, grants an authorization, thegrant should be done by the manager role, rather than by the user Satoshi.
User Avatar
0 votes
0 votes
0 answers
4
ajaysoni1924 asked Mar 26, 2019
405 views
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.
Show how to define a view tot credits (year, num credits), giving the totalnumber of credits taken by students in each year.
User Avatar
Link Copied!