Session 5：Assignment One Question : Think of the small database we used in our lab exercise - Products and Suppliers. Briefly describe how this database observes any two of the four design principles outlined above.

According to our lab exercise of the Products and Suppliers. We used the small databasae to develop a table for the relation data, which is the primary step to input the data to the system. We do set up the rows and columns on the each table to divide the items and description and each table only for one object.

So, we have to set up a several database if the object is more than one. we don't combine the different data by one table. There have two princiles for the relational database, duplicate information, correctness and completeness of information which is very important and can't make any mistakes. Otherwise the general reorts will be contain incorrect information and misinformed.

Session 4：Assignment One Question Find one example of Internet marketing that you think is particularly effective and one example that is ineffective. Explain your reasons, for example, you can describe how well the effective example takes advantage of the Internet's properties (e.g. interactivity, personalization, greater hold on user's interest). For the ineffective ad, you may describe how you can improve on it. NOTE: You are free to use your own examples, or any of the examples I shared with you in class or in the class blog.

http://www2.cinema.com.hk/revamp/html/index.php

I would like to share this website with all of yours because I feel this is very effective for me to use their on-line service. This is because people can easier to check and buy the tickets of their desired movies. This webpage have providing a lot of function for the customers to check when to buy the tickets. You can select different movies, then to watch the trailer and read the outline of the story before purchase that.

You can select the location of each theater and pick up the times and dates you want. You don't have to worry about if you are not sure the location of the theater, because they are providing the map / parking area to see where is the nearest Mtr station. The facilities icon is for you see the size of the theater, number of the seats and sound system. You also can select your seat area and via the credit card to settle the payment. You might only required a few minutes to buy the movies tickets on-line and do your reservation as well.. Everyone can save a lot of time!

http://www.baleno.com.hk/

I think Balenco is an ineffective of the internet’s properties and there have a several action task should be input to their webpage to become more attractive. Because, new inspiration, Stylish, Color are most important of the fashion industry... But, nothing you can find from this area... And nothing interesting to movtivate you to go to buy anything from their stores.. I am suggest the followings to improve thier webpage.

First, input some fashion element inside the website, like to launch their new development products for Men, Women and Kids. Because you have tell all the customers what kind the products you can supply in the stores right now and what are the upcoming products for the next season.. Second, Stylish & Color is the major successful factor to attract the new customers. They should insert more new styling products online for selection. Meantime, provide the purchase on-line service.

So, people can purchase their desire items and via the internet to buy immediately.. I will input the open forum for everyone to share and express any new ideas or comments of our products. That is my suggestion would like to share with everyone ....

Session 3 - Assigment One Question

This week we talked about Customer Relationship Management (CRM) as a process and as a software application. Based on the CRM concepts learned, answer the following questions:

1. List the customer data elements generated when a customer interacts with an airline by (a) making a reservation, (b) using frequent flyer miles, and (c) completing a flight. How does information from CRM improve these interactions?

Answer : Related to the customer data an airline by making a reservation, that is including the name of the customer, departure date and time, destination, seat class, telephone, e-mail address those information will be apply to the CRM system to interaction with the customer. There is an opportunity to begin or maintain a relationship with customers. For the flyer miles, once the information build up to the CRM system, the company is able to track all the customers data, which is the best analytical tools, such as…. the customer behavior prediction to the segmentation and targeted marketing. What they can see is the customer is travel by business or tourist and where is hottest place they most to travel. Who are our most loyal and profitable customers. Such information is useful for the company to analyze the market direction easily and accurate.

2. What are the benefits of integrating the sales, marketing and customer support function using a single software package and a centralized database?

Answer : Like I said, once the date input to the CRM system, they can set up customer’s chain to maintain the relationship with their customers. The marketer can base on the customer behavior to offer another service to their loyalty customers and offer some promotion tickets to retention the old customers. So, the sales team can base on the direction from the marketing team to approach the customer and sales the production according to their buying behavior. So, that can maintain the old customer and also increased sales revenue. The customer support department is able to follow up the comments from the customers after used their service. Like the food, condition, service to able the company can keep improving that to better than other competitor.

Session 2 - Assigment One Question

Question 1

Which departments within the company are integrated within the Order-to-Delivery process?

According to the OCE Computer company, there hv several paries are integrated within the Order-to-Delivery proceed. Like the Sales department with Warehouse and Logoistics department are getting involvied to the Order-to-delivery process from the daily basis...

Question 2

Which steps are included in the Order-to-Delivery process?

For example, there hv one new order which is just confirmed by the Sales department. They can quickly input the order requirments to the system such quantity, modle, price, delivery and address to issue an order sheet. The whole information will be rapriclly received by the Warehouse people from the system to do the inventory checking to see whether the stock is available or not. They can quickly to ensure the goods is in stock and prepare the delivery notice/packing list from the input data.. Once the goods is delivered, the Sales department will got the tracking nurmber from the warehouse people to inform their customer to receive the goods according to the tracking number.

Question 3

What factors would you consider when deciding whether ERP is suitable or not for a small business?

This is very subjust to the nature of the business instead of the size of the business.. The ERP is most suitable for the company which they hv their own supply chain business to co-operation and organization all the parties in one frame on the daily basis... This is very good to monitoring the status on-line and everybody know what's going on and how is the business running.. As u know, time is money... is your employee more efficiency they can do more... if the people can save the time from paperwork.. this is no doubt to enhance the business...... As as result ERP is good to apply for the small business if they hv own supply chain...

Session 1: Assignment One Question

Question: Think of a business or organization that you admire, and then describe two examples of how that business is supported by information systems. For example, do they use it for operational excellence? Or do they use it to create new products and services?

Nowadays credit card is a necessity of our life. This is one of the best banking product and service in the world, the people no need to bring cash or cheque anymore, and you just take a card can purchase whatever you want.... How convenient? People can use credit card to buy anything in everywhere. …. all general place are accepted a credit card. Moreover, people can remote purchase any products that they want, for it enables people to purchase products and services remotely via the internet or phone. When people using a credit card shopping by telephone or in the Internet can speed delivery and simplify a return or exchange. People can shop closer to home and got a 30days credit period to settle the bill.

The second advantages of using a credit card are save time. The credit card is really easy to use. You just slice the card and sign your name, and then the transaction will go through. You can use it to pay all the bills such as gas and electric fee, cell phone, home phone, water service, parking ticket and other expenses. Also, the entire card holder can earn some cash back monthly. Additional benefits such as insurance cover on purchases, cash back, air miles and some store discounts.

Another advantage of using a credit card to proceed international transaction.. . For example, Visa and Master Card are use for any countries. No need to concern about the exchanges when you travel to different countries... one card to walk through the world without any trouble...

This is my first blog of my life.... let see how to do...

14-May

... is still under construction !!!!