The Director wants to take advantage of the Internet to change the way the company operates. The new branch will allow prospective clients to browse the website and make an initial registration. Interview and the checking of documents can then be arranged on-line. Once a client has been registered any payments due can also be made on-line via any of the various credit and debit cards. Flexibility in the provision of services to clients also requires that once registered, a client can take a driving lesson at any of the centers. Hence an integrated and up-to- ate database system is to be implemented.
The Director of the organization feels that too many mistakes are being made with the current system and that the success of the organization will be short-lived if he does not do something to overcome the situation. He knows that a good IT strategy and network design could help in part to solve the problem and has approached our team to help create a new branch and implement an efficient and reliable information system to support the running of the organization as a whole. 1. 3 DESCRIPTION OF SGF OPERATIONS. Each office has a manager (who tends to be a senior instructor), Several senior instructors, instructors and administrate staffs.
The staff hierarchy is as follows: – Manager – Senior instructors – Instructors – Office personnel. The manager is responsible for the day-to-day running of the office. Clients must first register on-line or at an office and this requires that they complete Before the first lesson, a client is requested to attend an interview with an instructor to assess the needs of the client and to ensure that the client holds a valid provisional driving license. A client is free to ask for a particular instructor or to request that an instructor be hanged at any stage throughout the process of learning to drive.
After a successful interview, the first lesson is booked. A client may request individual lessons or book a block of lessons for reduced fee. An individual lesson is for one or two hours which begins and ends either at the client’s home or at the office. A lesson is with a particular instructor in a particular car at a given time. Lessons can start as early as AAA. M. And as late as up. M. After each lesson, the instructor records the progress made by the client and notes the mileage used during the lesson. The Organization has a pool of cars, which are adopted for the purpose of teaching.
Each instructor is allocated too particular car. As well as teaching, the instructors are free to use the cars for personal use. The cars are inspected at regular intervals for faults. Once ready, a client will be given a test date by the instructor. It is the responsibility of the instructor to ensure that the client is best prepared for all parts of the test. The instructor is not the responsible for testing the client and is not in the car during the test but should be available to drop off and pick up the client before and after he test at the testing centre.
If a client fails to pass, the instructor must record the reasons for the failure. 1. 4. AIMS OF THE PROJECT. 1. To design and implement a network solution for the new Barking branch . 3. To connect SGF to the Internet and provide full internet service. 4. To design a desktop and its delivery to all Gaff’s client computers. 5. To address security and back-up issues. 6. To design a network monitoring policy to maintain and/or improve performance in the future. This particular aspect of the group work is investigated in detail by Student number: 0212251 in Part B. . BUSINESS REQUIREMENTS FOR THE PROPOSED NETWORK SYSTEM. The design of the Local Area Network for the new branch and its communication with the rest of the SGF network will be approached in view of satisfying two fundamental business functions: – Information sharing: refers to having users access the same data files, exchange information via email, or use the internet. – Resource sharing: refers to one computer sharing a hardware device (e. G. , printer) or software package with other computers on the network to save costs.
The main benefit of information sharing is improved decision making, which is one of he goals of the SGF School of Motoring. Any application, e. G. A web browser, on the SGF LANA will have the following functions: 1 . Data storage 2. Data access logic 3. Application or business logic 4. Presentation logic Based on these functions we will be implementing client/server network architecture at the new branch. We will be using 3-tier client/server architecture to spread the load between the clients (microcomputers) and the servers (more powerful microcomputers).
This is illustrated in the diagram below: In this case, the software on the client computer is responsible for presentation logic, n application server is responsible for the application logic and a separate database server is responsible for the data access logic and data storage [1 , page 45]. Since the main advantage of a client/server architecture is also its weak point I. E. Enabling software and hardware from different vendors to be used together, we will recommend a middleware software such as CORBA (Common Object Request Broker Architecture).
It will perform two vital functions: 1 . It enables a standard way of communication by translating between software from different vendors 2. It manages the message transfer from clients to servers (and vice versa) so that clients need not know the specific server that contains the application’s data. The application software on the client sends all messages to the middleware, which forwards them to the correct server. The application software on the client is therefore protected from any changes in the physical network. If the network layout changes (e. G. A new server is added), only the middleware must be updated [1, page 44]. By choosing this architecture for the new branch, we have achieved two things: 1 . Better load balancing between the servers on the network . Scalability. In the future, if due to business demands the system needs to be extended, this can be easily done by adding one or more servers. 1. 6 REQUIREMENTS ACQUISITION. In order to obtain valuable information about the SGF School of Motoring, the group decided to send out questionnaires to members of the organization who uses the old system regularly and have a good knowledge of it.
We decided on questionnaires because we believe that the users, being under no pressure as they answer questions about the existing system, will provide a reliable feedback. 1. 6. 1 QUESTIONNAIRE 1. User: Mr. A. Patella. Position: Instructor. Time at Company: 3 years. 1 . Question: How often do you use the system? Answer: Daily. As many as 20 times a day, when at work. 2. Question: Are you comfortable using the company network? Answer: Sort of. 3. Question: What do you normally use the system for? Answer: Browsing the internet, enquiring about client information, entering client details, sending and receiving emails etc. . Question: Which of these tasks do you found most daunting and why? Answer: No doubt, it is obtaining information about clients. The process is very slow and frustrating especially during peak hours. For some reasons the system is sluggish and it slows down the business. 5. Question: From question 4, do you sometimes have to abort the task? Answer: No, because a client details got to be entered. It’s frustrating, but you wait until it’s done before moving on. As a result we tend to record client details at the whenever the system tend to be responsive. This might be a couple of days later. 6.
Question: Which of these tasks do you find easiest to do and why? Answer: No doubt, surfing the internet, sending emails, registering clients on-line. 7. Question: Have you had experiences of viruses causing disruption on the system ND how? Answer: Certainly on many occasions. I can remember on one occasion a few of my clients and me couldn’t use our computers because it was totally corrupted and my section had to be closed down while the techie people sorted it out. We lost most of the files on our computers. 8. Question: From question 7, on how many occasions did this happen? Answer: I’ve experienced it about 6 or 7 times. . Question: What advice were you given about using the systems in terms of avoiding virus infection? Before you close for the day, etc. But despite taking these measures, we still have the problem. 10. Question: Do you normally back-up your files yourself and how often? Answer: Yeah, files are supposed to be backed up on CD-rooms at the end of every working day but not everybody does it. 1 1 . Question: Do you case of lost customer files and how often? Answer: Yeah, we do. I know a few of my mate who do. We Just try to re-acquire it from the customer without the knowledge of management.
Someone has been reprimanded for it in the past. Sometimes, it’s the fault of the system. As I said earlier, it can be frustratingly slow. 12. Question: If you can change the system, what will you change and why? Answer: Definitely, it will be the enquiry procedure. Anything that makes the process faster will do. 13. Question: On a scale of 1 to 10, how will you rate the current system in terms of usability and efficiency, business wise? Answer: 5. Average no more. 1. 6. 2 QUESTIONNAIRE 2. User: Mr.. Smith. Time at Company: 2. 5 years. Branch: Lifted Branch. Answer: Daily. About 15 times a day.
Answer: Yes and No. Answer: Registering a client, conducting interviews, enquiring about client information, entering client details, sending and receiving emails etc. Answer: Conducting enquiries about clients. System not very responsive. Answer: Some instructors do. I Just postpone it for later. Answer: Apart from searching, other activities are easy to do. Answer: We all do, I suppose. I can remember on one occasion a few of my clients and me couldn’t use our computers because it was totally corrupted and my section had to be closed down while the techie people sorted it out.
SGF has two (2) branches at present (Lifted and Stratford). This project specifies a LANA for a third branch at Datagram. All the existing branches are based on Ethernet Lana but with old and inefficient implementations. We will examine the two existing Lana as a way of comparing the proposed system. 1 . The Stratford branch is the oldest. It has fifteen (15) microcomputers (clients) organized into a client-based LANA architecture. The application software on the client computers is responsible for the presentation logic, the application logic and the data access logic.
There is a file server used to store business information such as client details. Access Method: CAMAS/CD Addressing: Each client on the Ethernet network has its own network interface card, NICE. The NICE is fitted inside the microcomputer and provides the client with a six- byte physical address [2, page 374]. Implementation: bases thin Ethernet or thinner. In this LANA, the data rate is Mbps, Baseball Manchester encoding and a cable length of 185 meters. The connectors and cable utilized are: Nice, thin coaxial cable and BANC-T connectors [2, page 378].
NICE: Provides the client with an address and also check for voltages on the link to implement the CAMAS/CD access method. Thin Coaxial Cable: The cable used to implement the bases standard is ERG-58. These cables are relatively easy to install and move around. BANC-T: This connector is a T-shaped device with three ports: one for the NICE and one ACH for the input and output end of the cable [2, page 379]. The topology of the Stratford branch is shown below. (17) microcomputers (clients) organized into a client-based LANA architecture.
The presentation logic, application logic and the data access logic are all based on the client microcomputers while the server simply stores the data. The fundamental problem with this setup is that all data on the server must travel to the client for processing. For example, if the manager wants a list of all clients that took a driving test more than once, all the data in the database must travel from the server where he database is stored over the network circuit to the client, where the data is then analyses to obtain the required information.
This can overload the network circuits because far more data than necessary is transmitted from the server to the client [1 , page 43]. Byte physical (MAC) address [2, page 374]. Implementation: bases-T, Twisted-pair Ethernet. This is a recent standard defined in the IEEE 802. 3 series. It is logically a bus and physically a star topology LANA that uses unshielded twisted pair (HTTP) cable instead of coaxial cable. It supports a data rate of Mbps and has a maximum length (hub to linen) of 100 meters [2, page 379]. All the networking operations are placed in an intelligent hub with a port for each client.