the divide-and-conquer method to construct it. First, based on the keyword found in the query condition, we divide the original query requirement into multiple single-unit queries. We can then construct the single-unit queries separately using the method presented in Section 1 Constructing Single Unit Queries. After the single-unit queries are constructed, they can be combined using the set operator corresponding to the keywords found in the query condition: set intersect (C) for AND, set union (E) for OR, and set difference (-) for NOT. (1) Query: Return the names of the departments whose addresses are "MCS' or 'HOH'. a) In plain English, write down the first query unit. Answer: b) In plain English, write down the second query unit. Answer: c) What should be the set operator to combine the first and second query units. Answer: d) Based on your answers above, provide the complete query statement. You can write it as a relational algebraic expression or SQL command. Answer: (2) Query: For students majoring programs named 'Comp Sci' or 'Soft Engr', return their snames. a) In plain English, write down the first query unit. Answer: b) In plain English, write down the second query unit. Answer: c) What should be the set operator to combine the first and second query units. Answer: d) Based on your answers above, provide the complete query statement. You can write it as a relational algebraic expression or SQL command. Answers the divide-and-conquer method to construct it. First, based on the keyword found in the query condition, we divide the original query requirement into multiple single-unit queries. We can then construct the single-unit queries separately using the method presented in Section 1 Constructing Single Unit Queries. After the single-unit queries are constructed, they can be combined using the set operator corresponding to the keywords found in the query condition: set intersect (C) for AND, set union (E) for OR, and set difference (-) for NOT. (1) Query: Return the names of the departments whose addresses are "MCS' or 'HOH'. a) In plain English, write down the first query unit. Answer: b) In plain English, write down the second query unit. Answer: c) What should be the set operator to combine the first and second query units. Answer: d) Based on your answers above, provide the complete query statement. You can write it as a relational algebraic expression or SQL command. Answer: (2) Query: For students majoring programs named 'Comp Sci' or 'Soft Engr', return their snames. a) In plain English, write down the first query unit. Answer: b) In plain English, write down the second query unit. Answer: c) What should be the set operator to combine the first and second query units. Answer: d) Based on your answers above, provide the complete query statement. You can write it as a relational algebraic expression or SQL command. Answers