SESSION 5: Small Database

A database is a collection of data organized to service many applications at the same time by storing and managing data so that they appear to be in one location.

In our lab exercise, we used the database of Products and Supplier.
I brief how this database observes the principles outline that Jenny mentioned.

*Divides your information into subject-based table to reduce redundant data.
*Provides the database management system (e. g ACCESS) with the information it requires to join the information in the table together as needed

We enter the data of product and supplier into below subjects and the function were listed as below

Table-used for data storage
Query-used for selecting and viewing records
Form-used for data input
Report-Used for formatting, calculating, printing, summarizing data

ACCESS collects the data as a small database.
We choose the data that we need due to that reduce redundant data. For designing and generating report, we arrange order that is most important. For example, the selling price is the point that I concern, so I sort the database of selling price data ascending. After the generate report, it was shown the column of selling price first. I check it clearly.

SESSION 4: Effiective and Ineffective Example

First of all, we should know what is internet marketing , the following components should be contained. -Using digital technologies to help sell goods and services -Complements traditional marketing methods such as direct mail, PR and advertising -Beniefits for 24hrs golbal reach, lower cost, trackable and measured results, personalized/one-to-one marketing, more interesting campaigns, seamless experience

Ineffective Example-http://www.nissinfoods.com.hk/ I love it very much and visting there twice a week cause there are a lots of online game and the cartoon are funny. Actually, we can know the products of Nissinfoods more clearly through the site, but it is not very good cause we also can get its product's information here, from supermarket or on TV. Therefore, it can't let the sale revenue increase. In this example, we can't purchase item in this site that why the sales revenue cannot be increased when the the use of frequency increase.

http://www.figleaves.com/uk - I know this site in Yahoo!. It uses RSS works. When i enter the brands of the lingerie. It links to this site immdiately. I can find different kinds of lingerie in here with lower price and i save time to shop everywhere. I can have a overall look in the short time . It provides 24hrs customer service that can help me solve my inquire quickly. It is a two-way communication for pull the markeing. Also, the delivery was provided. I can get the goods within one week and return the good when i am not satisfied. The results can be tracked and measured more closely.

SESSION 3: Customer Relationship Management (CRM) (Revised)

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: Refering to the information from airline's website, we need the following customer data elements generated when a customer interacts with an airline by marking a reservation, using frequent flyer miles and completing a flight
-Origin Place
-Destination
-Depart and Return Date and Time
-Trip Type (Round Trip or One Way)
-Cabin Class (Economcy, First Class)
- Personal Information (Name, Age, nationality etc...)
-Payments Method
-Membership ID
-The Most-wanted Destination
Using the CRM system, we can know the need of customer to plan and promote the journey package for customer. Customer can enjoy more benefit, discount. That can improve
i) the relationship between customers and company
ii)increase customer satisfaction
iii) increase sales revenue
iv) Lower churn rate

What are the benefits of integrating the sales, marketing and customer support function using a single software pacakge and a centralized database ?
We can collect the data and launch different promotion and activities to increased customer satisfaction. We interactive in the internet can reduced direct-marketing costs cause we can employ fewer employee to do the research. It is more effective to the marketing and lower costs for customer aquiaition/retention so that let sales revenue is increased.

The useful software?

I have installed the software that Jenny suggest.
How makes it work?
I wanna to know as soon as possible.

SESSION 2:After viewing the video (Revised)

Hi, Everybody. Did you all view the video? After viewing the video, I could answer the following question which Jenny ask
1.Which departments within the company are integrated within the Order-to-Delivery process?
My answer: In the video, we know that the sale and marketing department and the warehouse department are interated within the Order-to-Delivery process.

2.Which steps are included in the Order-to-Delivery process?
My answer: First of all, the staffs recevied the order from clients, then enter all the order in the system.Because the system is connected to warehouse. After checked, they can know the storage of the warehouse and confirm the order. Secondly, the warehouse department can know the order at the same them and arrange the delivery as soon as possible.

3.What factors would you consider when deciding whether ERP is suitable or not for a small business?
My answer: I consider about the benefit after using the system when deciding whether ERP is suitable or not for a small business such as can the system let us handle the order more smooth, increase efficiency, more communication between the department and improve the performance.
Then i will consider the range of functions and business processes.
First, if my company accepts order in "RENMINBI" but the ERP doesn't support "RENMINBI" payments yet. I will request the software company to add kinds of function for transfer the currency that we need.
Also, the employee's knowledge of using the system is my considration. They use this system hardly and let the job quality worse than before. That means the system is useless.