Using the above relational schema, determine whether the following query is both type and semantically correct:
What will be an ideal response?
```
SELECT CO.orderNo, C.cAddress, OD.itemNo
FROM OrderDetail OD, ClientOrder CO, Client C, Office O, Area A
WHERE CO.clientNo = C.clientNo AND
C.officeNo = O.officeNo AND
O.areaNo = A.areaNo AND
A.areaDescription = ‘SE’ AND
C.cName = ‘J. Smith’;
```
Query graph will show that OrderDetail has no join to the other relations, although it is
connected to the Result. Should conclude that it is not semantically correct.
You might also like to view...
A constructor is a method that __________.
a. returns an object of the class b. never receives any arguments c. performs initialization or setup operations d. removes the object from memory
Reports often include totals and subtotals as well as detailed information.
Answer the following statement true (T) or false (F)
A control is a part of a form or report that you use to enter, edit, or display data
Indicate whether the statement is true or false
Which of the following is NOT part of the EU principles on privacy?
A. Data should be collected in accordance with the law. B. Data should be used for any purpose for which it is needed. C. Data should be used only for a reasonable period of time. D. Information transferred to other organizations can be transferred only if the sharing organization has adequate security in place.