[sql]

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 () for AND, set union () for OR, and set difference (-) for NOT.

1. Query: Return the names of the departments whose addresses are 'MCS' or 'HOH'.

1. In plain English, write down the first query unit.

Answer:

2. In plain English, write down the second query unit.

Answer:

3. What should be the set operator to combine the first and second query units.

Answer:

Based on your answers above, provide the complete query statement. SQL command

------------------------------------------------------------------------------------------------------------------------

Department (DeptId, DeptName, DeptAddress, Chair); PK: DeptId; FK: Chair refs Faculty.

Faculty (FacName, FacSSNo, OfficeAddress, Worksfor); PK: FacSSNo; FK: Worksfor refs Department.

DegreeProgram (ProgId, ProgramName, ProgType, Coordinator, UnivReq, CollReq); PK: ProgId; FK: Coordinator refs Faculty.

Student (Sid, SSNo, Sname, CurAddress, Major, StuLevel, Gpa); PK: Sid; FK: Major refs DegreeProgram; UNIQUE: SSNo.

DDoffers (DeptId, ProgId, DeptReqrmnt), PK: (DeptId, ProgId); FK: DeptId refs Department, ProgId refs DegreeProgram.