Explain when you would use a Total row and when you would use a totals query.
What will be an ideal response?
A total row will only provide a grand total, average, etc. However, if you want to add grouping levels (by department, or by county for example) then you would use a totals query to view the data in more detail.
You might also like to view...
A(n) __________ algorithm is a technique for stepping through an array and rearranging its contents in order.
Fill in the blank(s) with the appropriate word(s).
Translate the brokerage into an SQL schema. Use the necessary SQL machinery to express all constraints speci?ed in the E-R model.
We will start with the diagram in Figure 4.30. In translating this E-R diagram, we choose to combine IsHandledBy with Account, WorksIn with Broker,and Office with ManagedBy. The rationale for these combinations is that in each case the entity type is a key role in the corresponding relationship. The reason why ManagedBy is combined with Office rather than Broker (which also happens to be a key role in the ManagedBy relationship) is that it is more likely for an o?ce to have a manager than it is for a broker to be a manager. Therefore, combining Office with ManagedBy into one table is unlikely to lead to many null values being stored with the Office table. In contrast, combining ManagedBy with Broker is likely to cause a situation where the value of the attribute Manages of the table Broker would be mostly NULL.
Assume that the size of the base font on a system is 12 points.
a) How big is 36-point font in ems? b) How big is 8-point font in ems? c) How big is 24-point font in picas? d) How big is 12-point font in inches? e) How big is 1-inch font in picas?
URL stands for Uniform Resource ____.
A. Logical B. Locator C. Link D. Lookup