"There are two basic principles behind relational database design. The first principle is that duplicate information (also called redundant data) is bad, because it wastes space and increases the likelihood of errors and inconsistencies. The second principle is that the correctness and completeness of information is important. If your database contains incorrect information, any reports that pull information from the database will also contain incorrect information. As a result, any decisions you make that are based on those reports will then be misinformed."
"A good database design is, therefore, one that:
* Divides your information into subject-based tables to reduce redundant data.
* Provides the database management system (e.g. ACCESS) with the information it requires to join the information in the tables together as needed.
* Helps support and ensure the accuracy and integrity of your information.
* Accommodates your data processing and reporting needs."
(Reference: http://office.microsoft.com/en-us/access/HA012242471033.aspx?pid=CH100645691033#Good)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.
Ans:
2009年6月25日星期四
2009年6月18日星期四
Session 4~Assignment one answer
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.
Ans:
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.
Ans:
2009年6月2日星期二
Session 3~Assignment one answer
Q: 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 ? 
Ans: Cathay Pacific is a selection of oneworld and non-oneworld carriers can be booked online. You can book most flights up to 10 months prior to departure, or just 3 hours before you fly.
Online booking process:
1.check schedules 
2.select flights
3.fill in the passengers details
4.payment
5.get the confirmation and print out the e-ticket
How to check-in online↓
http://downloads.cathaypacific.com/cx/olci/EN/1_Welcome_en.html
Currently, they can only handle new bookings made directly online. If you aleardy have a ticket, then we need to contact the travel agent or our reservations office to confirm our travel dates.
2.What are the benefits of integrating the sales, marketing and customer support function using a single software pacakge and a centralized database ?
Ans: CRM software is used to support these processes; information about customers and customer interactions can be entered, stored and accessed by employees in different company departments. Typical CRM goals are to improve services provided to customers, and to use customer contact information for targeted marketing.
2009年5月24日星期日
Session 2~Assignment one answer
Q: Visit the SAP Small Business web site.Scroll down the page and click the "View the Demo" link under the "Inventory and Operations" section.The demo will launch within your web browser. There are 4 tracks in the video. You only need to view Track 1: Introduction and Track 2: Automate the Order-to-Delivery Process.Answer the following questions after viewing the video:
Which departments within the company are integrated within the Order-to-Delivery process ?
Which departments within the company are integrated within the Order-to-Delivery process ?
Ans: The Sales Department and the Warehouse are integrated within the Order-to-Delivery process.
Which steps are included in the Order-to-Delivery process ?
Ans: When the Sales Department received the P.O. from custumers, then they can use the application to check the inventory status though SAP system. After that they will create the Sales Order.
The warehouse manager can receive the details fastly. They can see the customers no. and shipping full address...
Then click to "Pick and packing manger", and and make a pack list for shippment.
Finally, the status will show "closed". And e-mail the confirmation to cutomers.
What factors would you consider when deciding whether ERP is suitable or not for a small business ?
Ans: Service-oriented architecture moves the ERP landscape toward software-based and web services-based business activities. This move increases adaptability, flexibility, openness and efficiency. The move towards E-SOA helps companies reuse software components and not have to rely as much on in-house enterprise resource planning hardware technologies which helps make ERP adoption more attractive for small- or mid-sized companies.
2009年5月21日星期四
Session 1 ~ Assignment one answer
Q: Think of a business or organization that you admire, 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 ?
They provide a moneyback reward cards which there are 4 cards that the family can earn points under one account. Personalized Shopping List with special offers just for you, printed out at the MoneyBack Member Privilege Kiosk every time you shop. There are redeem gift for free or at a special at the Gift Redemption Centre. So that this activity can be attracted more people to shop there.
PARKnSHOP secures online commerce transactions, they employ Internet's Secure Sockets Layer (SSL) technology. It encrypts all of your personal information, including credit card number, name, and address, so that it cannot be read as the information travels over the Internet. To check SSL Certificate information, you can right click the mouse on, choose "Properties" and "Certificates".
Ans: PARKnSHOP is the leading supermarket chain in Hong Kong, with an unrivalled reputation for giving customers outstanding value for money, the highest quality in fresh food, an unmatched range, and world-class service.
PARKnSHOP's retailing foresight and management drive is well recognised through numerous consumer, industry and community awards. We are frequent winners of prestigious service awards and are among the most trusted and respected retail brands in the 
region.
region.They provide a moneyback reward cards which there are 4 cards that the family can earn points under one account. Personalized Shopping List with special offers just for you, printed out at the MoneyBack Member Privilege Kiosk every time you shop. There are redeem gift for free or at a special at the Gift Redemption Centre. So that this activity can be attracted more people to shop there.
PARKnSHOP secures online commerce transactions, they employ Internet's Secure Sockets Layer (SSL) technology. It encrypts all of your personal information, including credit card number, name, and address, so that it cannot be read as the information travels over the Internet. To check SSL Certificate information, you can right click the mouse on, choose "Properties" and "Certificates".
訂閱：
文章 (Atom)