Session Five: Assignment One Question

A good database design is, therefore, one that:

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.

* Provides the database management system (e.g. ACCESS) with the information it requires to join the information in the tables together as needed.
In our lab exercise we have used a small database with the data of Products and Suppliers. We organizes data in two-dimensional tables with rows and columns called relations. Each table contains data about an entity and its attributes. The data is stored in tables made up of columns (product name, product category, selling price) and each column must be of a single data type. Those collection values is called a row from the table. Each table also contains a key filed to uniquely identifies instances of that unique record. (e.g. product name:classic 109, coolest 100)
We have data in a same file and join the information together.
* Accommodates your data processing and reporting needs. The database management system for creating, storing, organizing, and accessing data from a database. We use tables to data storage, selecting and viewing records, data input and display (Two display method:"Inventory Status by Product Category"& "Inventory Status by Supplier Name")

Session 3: Assignment One Question

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



All the customer data are collected in a centralized database .It is easy to control and monitor. The company can promote some discount travel package to increased customer satisfaction and improved the customer relationship.
The internet is a 24-hour global channels for the company to launch different promotion which can reduce direct-marketing cost. For this one-to-one marketing is more effective and easier to build up a long relationship with customer. Thus it can increase the revenue of the company for a long-term.

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.


One of an effective example is Samsung, the company's website can help sell their goods by using digital technologies. Firstly, their website is a 24 hours global channels which have all information of their products. Under the WB 500/550 showroom, all the features of the new model camera was showed clearly. For example, when the browser click to the 10x optical zoom function, the pages can show the real affect of this function and the browser can become the first person of the photographer.

Secondly, the next attractive point of this website is the 24 hours Beijing. Most of the customers who want to buy a camera for keep their memories during their travel . Under the 24 hrs Beijing, there are two persons Kim and Josh who had a journey in Beijing. Inside the videos, the application of the multi-functions of the camera was showed in different situations and that was interesting for the browser.

In conclusion, this website is very interesting and user friendly, the browser can totally understand the features and the advantages of the camera after reached the website. http://www.samsungcamera.com/wb550/



Levi's is an ineffective example of the internet marketing. Although its website have provided some general information of the company, they didn't show the catalog of their products. Moreover, they uploaded too many data on the website and therefore the loading time of each page is quite long. Furthermore, the homepage of the website is a bit confusing and difficult to be understood.

In conclusion, the Levi's website is too simply and cannot provide enough information to the browser. In my opinion, they should change the homepage with clear icons to become more user friendly. Also they can set up the catalog list of those products on the website and let the browser realize their products clearly.
http://www.levi.com.hk/

Session 3: Assignment One Question

The Customer Relationship Management (CRM) as a process and as a software application.Based on the CRM concepts learned, answer the following questions:


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 ?

• Personal information (name,address,age,nationality,phone no. ,e-mail),
• Departure and return date (length of the trip),
• Destination (e.g. Australia, New York),
• Type of class (Economy, First Class),
• One-way or Two-ways return,
• Payment method (credit card, cash, e-payment),
• Membership data (ID, redeem points),
• Travel history (where have you been?).

By using the CRM, we can fact find all the customer's data, understand their needs and satisfy it. For example, from the membership record, we know the regular place where the customer always goes to (e.g. England). We can send some information about the England to the customer through E-mail. Moreover, we can promote some discount travel package to the customer as well. Furthermore, we also can recommend some short distance trip to the customer where close to the England. Therefore, CRM can improve the revenue of the company, satisfy customer's needs and enhance the long-term relationship with customer.




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

• Improve the customer relationship
• Reduced the cost
• Easier to control and monitor
• Increase the revenue of the company
• Make tasks more effectively and efficiently