Question 1: Watch the following video about Supply Chain Management (SCM): (Links to an external site.)Links to an external site. and read the paper Supply Chan Simulation: Collaborative Design System based on SOA – A Case Study in Logistic Industry by HaiJin, WenJu, and Zhen (SupplyChain Case Study.pdf). What is the importance of SCM? Can we use Web Services to improve SCM? How?

Question 2: Use Information Line (408-752-8052) to

• get driving directions between two bastions of higher education: Caltech (1201 East California Boulevard, Pasadena, CA) and Pasadena City College (1570 East Colorado Boulevard, Pasadena, CA)
• find the latest price for a share of stock in Oracle Corporation
• listen to your horoscope
• listen to today's top news stories

Experiment with the Information Line as much as possible. May be you can try to use the system from a quite location and then try to use it from a noisy location. Also try to speak with different accent and see if that makes any difference in the way the system respond to your voice. Write a brief report about your experience. In the report include a brief analysis of its performance and user friendliness.

Question 3: Assume that you have given the task of creating a web site for publishing cooking recipes. How will you make your web site accessible to mobile users? Note that mobile user is a user who is using hand held device like smartphone to access your web site.

Question 4: Again, assume that you have given the task of creating a web site for publishing cooking recipes. Based on your experience with using the Information Line, come up with a list of three services that can be provided by your web site that will be valuable to telephone users using voice communication only. You may find the following guidelines useful:

• It is difficult for users to log on. With voice applications, entering a username is even more tedious and error-prone. You may want to restrict your voice services to ones that can be accessed by the entire community and not just registered users. An alternative to the standard username/password authentication is to assign a numeric user_id and pin to each registered user, but that makes it more cumbersome to do Web/mobile/phone services all in one.
• It is easy to give information to the user, but it is hard for them to give information back to your service. It is typically practical for them to pick options from a menu, but impractical for them to provide any meaningful unstructured data.

MySQL Lab 4:

1. Write a statement to display the shipment ID, destination city, destination state and shipping costs of all shipments destined for Salt Lake City, Utah.

2. Repeat Exercise (1), but include appropriate (your choice) column aliases.

3. Write a statement to display the city of destination and the average cost of shipping to each city of destination.

4. Repeat Exercise (3), but sort the displayed cities in descending order.

5. Write a statement to display the city of destination, the shipping company and the estimated shipping date for all UPS shipments.

6. Repeat Exercise (5), but further restrict your output to estimated shipping dates occurring after January 20, 2001. (Hint: your date restriction will require a format identical to the one displayed from Exercise (5), and it must be in single quotes – for example: ’2001-01-20’).

7. Write a statement to display the shipment ID, average weight and average shipping cost of all shipment items. Group your output by the shipment ID.

8. Repeat Exercise (7), but restrict your output to records having average shipping costs in excess of $10.00.