The maximum number of records in a B-tree of degree 5 and height 2 is ______.

Match the following aggregate functions with what they compute:

I. Avg II. Sum III. Count IV. Min V. Max A. Counts the number of values in a column B. Average of a column C. Returns the lowest value D. Returns the highest value E. Totals the items in a column

An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table shown in Figure 14.20 lists the time spent by agency staff working at various hotels. The National Insurance Number (NIN) is unique for every member of staff.

What will be an ideal response?