Whereas computers use the Base 2 system, people are used to using the Base ________ system.
Fill in the blank(s) with the appropriate word(s).
ten
You might also like to view...
The Windows __________ allows a user to identify, save, and retrieve files by name.
a. menu bar b. file system c. task bar d. none of the above
The ___________ event allows a user to enlarge and reduce the size of a displayed object by pinching or spreading apart two fingers on the screen.
Fill in the blank(s) with the appropriate word(s).
The _____ is found at the top of the file system used by Windows.
A. root directory B. subfolder C. system folder D. critical directory
Formulate the following queries using SQL:
Consider the following relational schema: Staff (staffNo, name, dept, skillCode) Skill (skillCode, description, chargeOutRate) Project (projectNo, startDate, endDate, budget, projectManagerStaffNo) Booking (staffNo, projectNo, dateWorkedOn, timeWorkedOn) where: Staff contains staff details and staffNo is the key. Skil contains descriptions of skill codes (e.g. Programmer, Analyst, Manager, etc.) and the charge out rate per hour for that skill; the key is skillCode. Project contains project details and projectNo is the key. Booking contains details of the date and the number of hours that a member of staff worked on a project and the key is staffNo/projectNo. (a) (1) List all skills with a charge out rate greater than ?60 per hour, in alphabetical order of description. (2) List all staff with the skill description ‘Programmer’ who work in the ‘Special Projects’ department. (3) For all projects that were active in July 1995, list the staff name, project number and the date and number of hours worked on the project, ordered by staff name, within staff name by the project number and within project number by date. (4) How many staff have the skill ‘Programmer’? (5) List all projects that have at least two staff booking to it. (6) List the average charge out rate. (7) List all staff with a charge out rate greater than the average charge out rate. (b) Create a view of staff details giving the staff number, staff name, skill description, and department, but excluding the skill number and charge out rate.