Information System Design.
Designer : Zhang Zhiqinin
Number : S0028724
Executive Summary 1
Situation Analysis 2
Background 2
The Need 2
Solution Profile and Implementation Strategy 2
Three possible designs and Discussion 3
The recommended solution 14
Planning Budget 17
References 18
Appendices: Cost Comparison
Bundaberg Joy Flights embarks on an ambitious strategy designs to increase size from three offices to four offices, as well as replace the outdate information system and interrelated equipments. This solution report suggests an infrastructure to support the secure internal telecommunication, prompt search management, electronic financial transaction process and reliable data storage capability.
Introduction:
> E-Business State: internal and external Integration
> Core Functionality: An internal connection establishes through virtual private network (VPN) to support internal telecommunication and management. Customer and agent are allowed to access and check the authorized information through internet.
> Expected benefits: The dramatic improvements in search management, customer inquiry and payment process.
Background:
> Bundaberg Joy Flights offers flights to shuttle between five airports. The company now owns three existing offices in Bundaberg, Hervey Bay and Morroochydore airports. The company has outgrown its current premises at the Bundaberg airport and will be relocating its administrative staff go larger office in the Bundaberg Central Business District (CBD) (external to the airport).The existing office at the Bundaberg airport will become a branch of the company; the Bundaberg CBD office will now be the main office.
The needs:
> A Data Resource management and storage device to retain and management data.(5)
> Virtual Private Network.(6)
> Workflow system to control the booking and confirming process. (8)CyberCASH payment system
> Decision Support System. (9)
Three Possible Designs and Discussion
Exhibit:0.1 Distribution of Clients - General use for all three designs
As shown as we can see every member (except for Cabin Crew) will receive a Client. The client could be fat or thin depend on different needs of processing capability. The detail will be given in discussion section.
...
This is a preview of the whole essay
The needs:
> A Data Resource management and storage device to retain and management data.(5)
> Virtual Private Network.(6)
> Workflow system to control the booking and confirming process. (8)CyberCASH payment system
> Decision Support System. (9)
Three Possible Designs and Discussion
Exhibit:0.1 Distribution of Clients - General use for all three designs
As shown as we can see every member (except for Cabin Crew) will receive a Client. The client could be fat or thin depend on different needs of processing capability. The detail will be given in discussion section.
Exhibit 0.2 Topology -General blueprint for all three designs
This graph outlines the
Design 1 ( planning budget adopt Quote 1)
Exhibit: 1.1 Ring network in main office
Design 1
Exhibit 1.2 Ring network in branch offices (Bundaberg airport office; Hervey Bay and Maroochydore airport)
This solution implements the intranet in each office as ring topology. The offices intranets are connected through virtual private network to form whole enterprise. Intranet, which allows staffing any office can securely access needed resources in main office.
In each branch office, There is a local server which handles operations locally and storage data temporally which will be sent to main office. This makes the data more reliable and also makes booking and accounting system more stable and reliable, safe from system failure and network failure.
Workstation can perform more complicated processing task, which will give more space to extend the operation in the future.
The ring topology makes the whole network more reliable and the cost is lower compared with star topology and bus topology.
Design 2 (planning budget adopt Quote 2)
Exhibit 2.1 Bus network in main office
Design 2
Exhibit2.2 Bus network in branch offices (Bundaberg airport office; Hervey Bay and Maroochydore airport)
In this solution, the local area network in each office is bus topology architecture. Each office local area network has a firewall and a router. The connections between branch office and main office are virtual private network connections, which will protect telecommunication between offices.
In main office, there are file server, database server and application server. The branch office will store data in these servers or retrieve information from these servers. In each office, there are shared printer and shared scanner. In main office, the director has a powerful workstation for his work, and the others use general workstations which will be helpful for the business extension in the future. In each branch office, there is a LAN server which acts as a local security manager and data buffer. Also every staff has a general workstation.
The disadvantage of this sort of network is the low transaction speed. Plus the low cost equipment this topology may perform a lowest capability.
Design 3 (planning budget adopt Quote 2)
Exhibit 2.1 Bus Exhibit 3.1 Bus network in main office
Design 3
Exhibit 3.2 Ring network in branch offices (Bundaberg airport office; Hervey Bay and Maroochydore airport)
In this solution, the local area network in each office is ring/bus topology architecture. Each office local area network has a firewall and a router. The connections between branch office and main office are virtual private network connections, which will protect telecommunication between offices.
In each office, there are shared printer and shared scanner. In main office, there are file server, database server and application server. The director has a powerful workstation for his work, and the others use net PC or thin client which just provides limited computing capability. The branch office will store data in these servers or retrieve information from these servers. In each branch office, there is a LAN server which acts as a local security manager and data buffer. In addition, every staff in branch offices uses net PC.
This is the lowest cost design of three because of use of inexpensive device such as net PC, thin client and inkjet printer. As a result, the performance of this topology will be much poorer than first design in terms of transaction speed and data processing capability.
The most effective difference between the first design and the others is the intranet topology in each office. The topology of ring network (design 1) provides a more reliable internal environment. If one computer in the ring goes down, the other computers can continue to process their on work as well as to communicate with each other. Another point is that ring network gives every client a prompt access to connect either each other or server. However, the other designs content of bus network will decrease the processing speed; therefore the service quality will be affected as well.
It should be admitted the planning budget in first solution is the highest one, but it will bring a high quality performance witch can increase the service profit. However, the other two economic solutions can not handle the complicated situation.
Data management and storage
In first solution, There are a Database sever and a file server to be the data manager.
ServeRAID-4Lx Ultra160 SCSI Controller, the DAID witch is updated to 66MHz PCI bus performance, control for mid- and entry-range storage environments. Supports Ultra160 SCSI technology - 160 MB/s data transfers.
Virtual Private Network
A virtual private network can provide fast customer service between offices. Distance customer service officer can answer customer's inquiry immediately by the searching flight schedule from main office through VPN.
The virtual private network uses the Internet as its main backbone network. It is relies on the fire walls and other security software. A Firewall device for VPN is listed in Quote1 witch is Firewall VPN 100 (Symantec). It will be install in each office to build a Virtual private network.
Workflow system
This system completed by the Microsoft(r) Office XP Developer. It will electronically collaborate to accomplish structured work tasks within ticket booking and confirming processes witch is required by company.
Decision Support System
Decision support system software will be introduced in this stage: Decision Explorer (Banxia software). It is full-feature cognitive mapping tool - with many analysis capabilities. It will be an assistant to analysis, specialize the data for manager and every staff who have a decision support requirement.
Accounting system
MYOB- A Business, payroll and time management software. It can fulfill the most financial processing requirement such as pay roll management, accounts payable, accounts receivable and inventory management.
The total cost of the recommended solution is considered AUS$365,441.77 (include GST). It also include training cost, Web hosting cost and maintenance cost.
Training cost: Some staff can be trained together as a group - Pilots, Co-Pilots and Check-in staff.
Web hosting service cost: The e-commerce web site will be submitted to a Web service company. The company should be allowed to get the daily Flight schedule information.
Maintenance cost: It includes the hypothetic hardware wearing cost and maintainant cost.
. James A. (2001) Introduction to Information Systems
New York: McGraw-Hill/ Irwin P.209-239
2. IBM (2003)
St. George Bank: A CRM Solution Built on Bankwide Legacy Integration
http://www-8.ibm.com/e-business/sg/solutionseries/casestudies/crm/st_george.pdf
[Accessed28,April 2003]
3. Cisco solution (2002)
The Strategic and Financial Justification for IP Communications
http://www.cisco.com/warp/public/cc/so/neso/vvda/iptl/cnvrg_wp.pdf
[Accessed 28, April 2003]
4. Cisco solution (2002)
Network blueprint: Customer Care http://www.cisco.com/warp/public/779/smbiz/iroadmap/us/en/customercare/customercare_diagram.html?NO_NAV
[Accessed 28, April 2003]