1. Find an example of what you consider an excellent retail website. Comment on
a. The use of color and white space.
b. The ease of navigation.
c. The taxonomy.
d. Whether the site displays its privacy policy.
e. Whether the site displays a security assurance.
f. Your experience walking through the online purchase process (of course, cancel before you commit to the final purchase!). Are you in control and informed at each step?
1. Find an example of what you would consider a poor retail website. Use the same list as for Exercise 1 and note the differences you find.
2. Depending on your web browser, you may be able to locate a folder or a file on your machine that contains cookies. Look through the folder or open the file. List references to three websites you have visited.
4. Using the Employees table of Figure 14.6 what is the result of the following SQL query?
SELECT * FROM Employees WHERE HoursWorked < 100; 5. Write an SQL query that retrieves first and last names and pay rate, ordered by PayRate, from the Employees table of Figure 14.6. 6. Using the Employees table of Figure 14.6 and the InsurancePolicies table of Figure 14.7, what is the result of the following SQL query? (The # marks allow the date to be treated numerically.) SELECT ID, PlanType FROM Employees, InsurancePolicies WHERE Birthdate > #1/01/1980#
AND ID * EmployeelD;
j ? Details j
Line 1: select id, plan typ. Line 2: from employees, insurance policies. Line 3: Where birth date is greater than hash tag 1, 01,
1980 hash tag. Line 4: and id = employee id, semi colon.
7. Using the Employees table of Figure 14.6 and the InsurancePolicies table of Figure 14.7, write an SQL query that retrieves first and last names, hours worked, and insurance plan types for all employees who have worked fewer than 100 hours.
8. Figure 14.8 describes the attributes in an InsurancePlans table. Write some possible tuples for this table.