Database Systems: Design, Implementation, & Management
11th Edition
ISBN: 9781285196145
Author: Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 9RQ
Program Plan Intro
UNION set operator:
The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.
Syntax: QUERY UNION QUERY;
INTERSECT set operator:
The INTERSECT set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that are common in both the tables.
Syntax: QUERY INTERSECT QUERY;
MINUS set operator:
The MINUS set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that appear in the first table but not in the second table. The word “EXCEPT” can also be used in the place of “MINUS”.
Syntax: QUERY MINUS QUERY;
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Write expressions of relational algebra to answer the following queries:
The following SQL queries use the instances of R1 of "Reserves" the instances of B1 of "Boats", and the instances of S1 of "Sailors" relation.
An instance R1 of Reserves
bid
101
103
103
day
10/10/96
11/12/96
10/11/96
12/01/96
12/05/96
10/10/09
10/10/98
104
10/07/98
11/10/98
09/08/98
09/05/98
09/08/98
SIC
22
22
31
31
22
22
31
64
64
74
103
102
104
102
101
102
103
An instance B1 of Boats
bid
101
102
103
bname
Interlake
Interlake
Clipper
Marine
104
bcolor
blue
red
green
red
An instance S2 of Sailors
SIG
28
31
21
44
26
58
22
22
29
29
22
32
2
64
21
74
85
95
71
sname
yuppy
Tubber
guppy
rusty
Dustin
Brutus
Andy
Horte
Horatio
Zorba
Art
Bob
Amy
rating
81
5
10
11
1
&
|10||
El
3
115
age
35
155
135
135
45
33
25
135
18
25
635
46
1.If we wish to list out only the names and ratings of the sailors, we can write this in SQL statement as
2.Find out only the names and ages of sailors.
3.To find out the names and ratings of sailors with a rating above 8, we can combine two of the preceding queries as:…
Can someone help me with this? Please use relational algebra.
Chapter 8 Solutions
Database Systems: Design, Implementation, & Management
Ch. 8 - What is a cross join? Give an example of its...Ch. 8 - What three join types are included in the outer...Ch. 8 - Using tables named T1 and T2, write a query...Ch. 8 - Prob. 4RQCh. 8 - Prob. 5RQCh. 8 - Prob. 6RQCh. 8 - Prob. 7RQCh. 8 - What does it mean to say that SQL operators are...Ch. 8 - Prob. 9RQCh. 8 - Prob. 10RQ
Ch. 8 - Prob. 11RQCh. 8 - Prob. 12RQCh. 8 - Prob. 13RQCh. 8 - Given the employee information in Question 11,...Ch. 8 - Prob. 15RQCh. 8 - Prob. 16RQCh. 8 - Prob. 17RQCh. 8 - Prob. 18RQCh. 8 - What string function should you use to list the...Ch. 8 - Prob. 20RQCh. 8 - Prob. 21RQCh. 8 - Prob. 22RQCh. 8 - Prob. 23RQCh. 8 - Prob. 24RQCh. 8 - Prob. 1PCh. 8 - Insert the data into the tables you created in...Ch. 8 - Prob. 3PCh. 8 - Prob. 4PCh. 8 - Prob. 5PCh. 8 - Prob. 6PCh. 8 - Prob. 7PCh. 8 - Prob. 8PCh. 8 - Prob. 9PCh. 8 - Modify the CUSTOMER table to include two new...Ch. 8 - Prob. 11PCh. 8 - Prob. 12PCh. 8 - Prob. 13PCh. 8 - Prob. 14PCh. 8 - Prob. 15PCh. 8 - Prob. 16PCh. 8 - Write a trigger to update the customer balance...Ch. 8 - Write a procedure to delete an invoice, giving the...Ch. 8 - Prob. 19PCh. 8 - Prob. 20PCh. 8 - Prob. 21PCh. 8 - Prob. 22PCh. 8 - Prob. 23PCh. 8 - Prob. 24PCh. 8 - Prob. 25PCh. 8 - Prob. 26PCh. 8 - Prob. 27PCh. 8 - Create a trigger named trg_line_total to write the...Ch. 8 - Create a trigger named trg_line_prod that...Ch. 8 - Create a stored procedure named prc_inv_amounts to...Ch. 8 - Create a procedure named prc_cus_balance_update...Ch. 8 - Modify the MODEL table to add the attribute and...Ch. 8 - Prob. 33PCh. 8 - Modify the CHARTER table to add the attributes...Ch. 8 - Write the sequence of commands required to update...Ch. 8 - Write the sequence of commands required to update...Ch. 8 - Write the command required to update the...Ch. 8 - Write the command required to update the...Ch. 8 - Write the command required to update the...Ch. 8 - Prob. 40PCh. 8 - Create a trigger named trg_char_hours that...Ch. 8 - Create a trigger named trg_pic_hours that...Ch. 8 - Create a trigger named trg_cust_balance that...Ch. 8 - Alter the DETAILRENTAL table to include a derived...Ch. 8 - Alter the VIDEO table to include an attribute...Ch. 8 - Update the VID_STATUS attribute of the VIDEO table...Ch. 8 - Alter the PRICE table to include an attribute...Ch. 8 - Prob. 48CCh. 8 - Prob. 51C
Knowledge Booster
Similar questions
- Consider the following expressions, which use the result of a relational algebra operation as the input to another operation. For each expression, explain in words what the expression does. a. year 2009 (takes) ▷ student b. year 2009 (takes ▷ student) C. ID.name, course_id (student takes)arrow_forwardA phone company has set up the following database in order to be able to send detailed bills to its customers: CUSTOMER(Phone#,FirstName, LastName, City), CALL(CallerPhone#, CalledPhone#, Date, Time, Duration, Cost), The keys of the relations are underlined. Answer must be written in relational algebra On which days did all the customers make at least one call? Is there a way to write this in relational algebra without using count? Subject: MYSQLarrow_forwardThe course I'm taking is database management. I need help with part A and B please. I am using APEX Oracle compiler. I have attached the employee table. Part A - Implement a procedure in PL/SQL to check if employee is eligible to a salaryincrement depending on his period of service. If he had served for 6 months ormore he is eligible for an increment. Use an if-else statement and print if he iseligible for increment or not . Hint: add_months(hiredate, 6) function will give you the date after 6 months ofhiredate.sysdate is used in oracle instead of the curdate() function in SQL to get the currentdate. Part B - Write a procedure to add 2 numbers and display the resultarrow_forward
- What is the difference between scalar function and vector function in SQL DATABASE? Note: Question is based on SQL DATABASE.arrow_forwardWhat is the result of first performing the Cartesian product of student and advisor, and then performing a selection operation on the result with the predicates_id = ID? (Using the symbolic notation of relational algebra, this query can bewritten as σs_id=ID(student × advisor).)arrow_forwardWhat happens if we don’t specify the WHERE clause in an SQL DELETE FROM statement? a) statement compilation causes a “Syntax error”, and the statement is not executed. b) all the tuples of the relaton are deleted. c) none of the tuples of the relation is deleted. d) all the tuples not satisfying the condition are deleted. e) none of the above. Which one(s) of the following is(are) procedural? a) Relational Algebra b) Relational Calculus c) Tuple Relational Calculus d) Domain Relational Calculus e) SQL f) (a) and (e) e) (b) and (e).arrow_forward
- What is the result of first performing the cross product of student and advisor, and then performing a selection operation on the result with the predicate s_id = ID? (Using the symbolic notation of relational algebra, this query can be written as asid-ID(student x advisor).) marrow_forwardWhich of these statements is true about relation partitioning? It places different rows from the same table on different machines, allowing for the computing of different query predicates in parallel on different machines. It places different columns from the same table on different machines, which allows for computing different query predicates in parallel on different machines. It places certain tables on one machine and others on a different machine, allowing different query subexpressions in the same plan to be computed in parallel on different machines. It replicates and indexes data, which generally improves query performance.arrow_forwardConsider the following SQL Query: SELECT FNAME, DNAME FROM EMP AS E, DEPT AS D WHERE E.DNO = D.DNUMBER AND D.DNAME='CCI' AND SALARY > 15000; Draw the initial query tree for the above SQL query, and then show how the query tree is optimized by applying the Heuristic Rules. (You need to show the tree after applying a rule).arrow_forward
- Explain ALIGN & ASSUME.arrow_forwardTrue or False below: Given two relations named A and B, if we q-JOIN A and B, the maximum number of attributes in the result relation could be (the number of attributes of A) times(*) the number of attributes of B). * in an SQL SELECT statement means “all the tuples”. In relational algebra, Cartesian Product (X) can be implemented using the q-JOIN operator. Cartesian Product ISA q-JOIN where q-condition always evaluates to true. SQL is based on Predicate Calculus. A query in SQL always specifies what should be included in the query result.arrow_forwardWrite the relational algebra formula to apply a UNION relational operator to the tables shown in Figure Q3.13.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education