Session 5 - Assignment One Question

A database is a structured collection of records or data that is stored in a computer system. The structure is achieved by organizing the data according to a database model. The model that is most commonly used today is the relational model.

The small database that we used in our lab exercise of Products and Suppliers are observes the following principles: -

1. Divides information into subject-based tables to reduce redundant data – in our exercise we can see that it’s a safety and convenience software for input data of products and suppliers. When you duplicate the entries like name or individual ID, it will shows that the wrong entry and let you know. It can reduce redundant data and any incorrect error by entry duplicate. That’s will make efficiency and to decrease affect of operational.

2. Accommodates the data processing and reporting needs – using database can get the report by simply sort the information/data that you need. It can save more time to complete data processing and operation efficiency.

Session 4 - Assignment One Question

Cathay Holidays is the one I think particularly effective business of Internet marketing. In the pass, everyone who needs to have a trip must go to the branch of airlines or travel agency to making reservation of flight tickets, hotels, etc. But now, you can just make the reservation online like Cathay Holidays. You just input the data as destination, departure & arrival date and time, which airlines/flights you want to select and also which hotel you interested, etc.

Then they will show all package suitable for your decided. You can find the package by destination/activity or any special offer of it. The flight number and time that available for booking will also shown on the site. You can select one of your choices and get the online reservation on it. Input all your information to confirm and they will send you a confirmation of booking. After that you can choose the delivery option by courier or pick it up at Cathay Holidays Office too. It's a convenience way to those frequent flyers and expands of loyalty customer segmentation to them.

http://www.cxholidays.com

However, Physical Fitness and Beauty Centre is an ineffective example. Formerly the members can search the group exercise schedule on the website of each centre. And choose the one they want to take or arrange time for which they needs in the coming few days. But now, Physical just like an advertisement page only. You can't find details information on it, if you need more information only can contact them “BY PHONE”.

That's a very ineffective nowadays in Hong Kong. Cause maybe you want to get details information then go to join them but you must ask them by phone to the center or go over there to attempt the course you want or not. In this situation, it's inconvenience for you because this maybe confusing your arrangement of daily schedule. And also they don't have reality special offer for existing members when the time for renew contract. That's why I had quit it last year too. hahaha~~~

http://www.physical.com.hk

Session 3 - Assignment One Question

1.(a) When a customer making a reservation of airline ticket, they need to input individual data such as name, mailing address, email address, contact number, itinerary date and time…… After the verification, airlines will be contact them to reconfirm the reservation and also provide the suitable package or special offer customize. Airlines will know about the customers’ need and keep the information for reference to improve service and keep connection with customers of other promotions. And also update the customers’ travel record to interpret their habitual.

(b) Airlines can be understood about frequent flyer’s habitual like: often destinations, frequency of traveling, etc by using frequent flyer miles information. It can know customer’s intention of pricing and expectation of service. According to these information can help airlines making decision on special offer or promotion for those loyalty customers.

(c) When complete the flight, airline can using questionnaire through email, fax or by phone to comprehend customer’s satisfaction or complain to improve and maintain services. It can makes more profitable of business and expand of loyalty customer segmentation.

2. CRM provides support to front office business processes, e.g. to sales, marketing and service staff. Interactions with customers are generally stored in customers' contact histories, and staff can retrieve customer information as necessary. The contact history provides staff members with immediate access to important information on the customer, eliminating the need to individually obtain this information directly from the customer. Reaching to the customer at right time at right place is preferable. Hence to increasing customer’s satisfaction, improve marketing effectively to attaining customer intimacy and service, keeping good relationship with customers.

Session 2 - Assignment One Question

1. In this example, Sales, Warehouse and Delivery Department are within the company are integrated within the Order-to-Delivery process.
   
   
2. When the sales manager received the order, he/she used the SAP Business ONE to access the real time inventory data to confirm the items aren’t on stock. He/she just input the information about the order. When the order has been already confirmed, the software will be automatically runs to the warehouse. Then the warehouse manager can easily to drop the information and print the delivery note and pick list to the delivery department. The delivery department received the order and arrange to delivery the products same day. After that, the software will automatically update the status and the Sales manager can find the update status then confirm the client to complete the order.
   
   
3. First of all, I will base on the business nature whether it is suitable to use ERP system or not. Is that the revenue of company and operational efficiency after used ERP system? It’s more important consideration to decide rather than the scale of business. ERP system is integrates key business processes of an entire firm into a single system and assemble an overall view of operations to the managerial stratum and also process globally. The business can be used it to improving service and get excellence operation. In my opinion, ERP should be suitable for airlines, fashion, toy, mobile phone and also courier business, etc using ERP system.

Session 1 - Assignment One Question

PPS (Payment by Phone Service) is the most useful channel for paying bills in Hong Kong. PPS introduced phone channel in 1993 jointly by EPS Company (Hong Kong) Ltd. and PCCW's subsidiary, Hong Kong Telecommunications (HKT) Ltd. As the internet marketplace grows and steps forward, PPS introduced the online service in 1999 for attaining customer intimacy and upgrading services. Nowadays, information systems are widely used in our everyday lives: working, searching information, communications, shopping, etc. PPS is a convenient and simple phone and online bill payment solution that lets you pay your way anytime and anywhere.

http://www.ppshk.com/hkt/revamp2/English/GlancePPS.html

You can have better protection under its "two-factors authentication" launched since 26 July 2007. You can enjoy a more secure and reliable environment for online transactions with its function that uses two different types of information to verify your identity being the transaction. Therefore, PPS currently records millions of transactions monthly, for over a wide variety of merchants ranging from public utilities, Government/statutory organizations, banks, telecommunication companies, to educational institutions and charity organizations. You can use it to pay bills anytime. This not only saves times, but also let the user pay in time to avoid the penalty for late payment.

Due to PPS becomes to popularize for everyone, it unceasingly to expand its customer base, PPS launched a value-added service – PPS Shop & Buy. With this service, you can make online purchase through PPS system to purchase top-up game points card, arrange fund transfer to securities accounts and buy tickets directly. And also this system allows you to purchase movie tickets of UA cinemas at www.cityline.com.hk or www.uacinemas.com.hk through PPS directly, giving you extra convenience.

http://www.ppshk.com/hkt/revamp2/English/ipg_intro.html

For above, we can see that PPS is a great system. I am one of its frequent users as I pay all of bills through PPS every month. This is certainly a great solution for such busy and lazy guys like me. Hahaha.......

First time......

Hello all! This is my first official school blog! I am so excited to get this started with our class. Thank you to Jenny for leading the way with blogging and helping us here.

I am sure we will learn heaps through this revolutionary method of learning. I am also sure that we can contribute so much.

I look forward to seeing what you and the classmates do with this wonderful opportunity.

My Name : Lam Ho Yan, Kathy

Student ID : 10425329