Computer System Research & Network Design for Springfield Local Library

Computer System Research
Exercise & Network Design
1

Contents
Introduction........................................................................................................... 3
Part A..................................................................................................................... 3
Computer System Research...............................................................................3
Software and Hardware Requirements...............................................................4
Part B..................................................................................................................... 6
Network Design.................................................................................................. 7
Network addressing............................................................................................ 8
Network Planning............................................................................................... 8
Implementation................................................................................................ 10
Impacts on Different Aspects...............................................................................12
Conclusion........................................................................................................... 12
References........................................................................................................... 13
List of Figures
Figure 1: PuTTY Configuration....................................................................................................3
Figure 2: MY SQL Server...............................................................................................................4
Figure 3: Network Design.............................................................................................................7
Figure 4: Frame Relay Configuration.......................................................................................9
Figure 5: Packet Tracer Imple...................................................................................................10
Figure 6: Test 1..............................................................................................................................10
Figure 7: Test 2..............................................................................................................................11
Figure 8: Test 3..............................................................................................................................12
2

Introduction
The Springfield Local Library (SLL) has decided to create a new network
design for its new building. This assignment will help to understand the
new system requirement and networking scheme for its new library. Part
A of this report consists major Hardware and Software requirement by SLL
to meet its requirement as per the case study and Part B will illustrate the
networking design and implementation of the network which SLL required.
Part A: Computer System Research
The Springfield Local Library (SLL) requires a quiet efficient workspace for
its staff and for the public users. A wide variety of system requirement in
terms of hardware and software must be met to fulfil the SLL case study
requirement.
All the system under the employees must have antivirus installed. For
antivirus there are lots of options to choose with like – McAfee antivirus,
Norton antivirus, QuickHeal antivirus etc., selection of antivirus depends
on SLL.
All the systems are running latest Windows Operating System (Windows
10 Enterprise) which provides the best support for Microsoft application
like – Microsoft Outlook, PowerPoint, Word, Excel etc. Also, most of the
antivirus are totally compatible with Windows OS.
For the helpdesk, it is required that it can access any remote system in
the network of SSL. For this Putty, the software can be handy. A putty is a
software that can give access to a remote system over the network. It
provides a tunnel access directly to the Command Line Interface (CLI) of
the destination system. But it is required that the other system must have
SSH (Secure Shell) access configured.
3

Figure 1: PuTTY Configuration
Hostname or IP must be given of the destination endpoint system in putty
software (Figure 1) and then after clicking open system credentials are
entered in the prompt and after that you get access to your end system.
A system is configured using windows server which run SQL server in it.
This system will provide database features and services to its users who
can get access to the database via remote access.
Microsoft SQL Server Management Studio (Figure 2) which is integrated in
windows server can resolve this problem easily. Here all the database
server related work can be performed. SQL server can provide a great
benefit in maintaining the databases like – in stock books or total
customers or staff related databases. Here local SQL servers can be
created (Figure 2) and local users can use this database to make updates
in it.
4