System Analysis and Design for Sunshine Motors Information System

Running head: SYSTEM ANALYSIS AND DESIGN
System Analysis and Design
Name of the Student:
Name of the University:
Author Note

1
SYSTEM ANALYSIS AND DESIGN
Table of Contents
Introduction......................................................................................................................................2
Recommended System Acquisition Strategy...................................................................................2
System Acquisition Weighted Alternative Matrix......................................................................3
Architectural Design........................................................................................................................4
Hardware and Software Specification.............................................................................................5
Interface Design...............................................................................................................................7
Interface Structure Diagram........................................................................................................7
User Interface Flow.....................................................................................................................8
Wireframe diagrams....................................................................................................................9
Program Design.............................................................................................................................13
Structure Chart...............................................................................................................................16
Program Specifications..................................................................................................................17
Conclusion.....................................................................................................................................21
Bibliography..................................................................................................................................23

2
SYSTEM ANALYSIS AND DESIGN
Introduction
The report deals with the case study of the Sunshine Motors and the current predicament
for the company is that they are making use of some old procedures that is hindering the growth
of the company. In addition to this, the company makes use of the manual systems that is
resisting the company from any type of growth. Hence, there is a need of reformation of the
systems and the process that are being followed by the company.
The report provides the analysis of the systems that are currently present in the company
and provides further information about the proposal for the design of the system for the Car
Dealership Service Department.
The reports provides the System acquisition technique, the architectural design, Interface
Design, Structure Chart, Hardware and Software design, Program Design and Program
Specification.
Recommended System Acquisition Strategy
The system acquisition techniques are very important for any type of organization for the
implementation of a new system. A successful acquisition strategy development depends on the
understanding of the external and the internal factors of the organization that drives the
organization for the acquisition of the system. For the system development there can be two
methods. Firstly, the company can opt for the custom development or secondly, they can opt for
package software to be installed in the system of the company. The custom development of the
software has been identified as the suitable technique in this situation.

3
SYSTEM ANALYSIS AND DESIGN
System Acquisition Weighted Alternative Matrix
The system Acquisition weighted alternative matrix has been used here for the
justification of the choice of the system acquisition technique that has been selected here.
Evaluation
Criteria
Relative
Importanc
e (Weight)
Alternative 1:
Custom
Development
Scor
e
(1-5)
Weighte
d Score
Alternative 2:
Packaged
Installation
Scor
e
(1-5)
Weighte
d Score
Technical Issues
Develops
desirable in-
house skills
15
The system
would be
developed in
C#.
4 60
The system
already
developed in
ASP.net
incorporating
the features of
C# in it.
3 45
Integration
with the
existing
systems
15
The
transactions
can be easily
linked with the
system
4 60
The
transactions
can be easily
linked with the
system
5 75
Experience
with the
product
10
The users
would have
experience of
the older
process.
5 50
No experience
1 10
Economic Issues

4
SYSTEM ANALYSIS AND DESIGN
Cost 25 The cost of
implementatio
n would be
very minimal
5 125 The cost of
implementatio
n would be
much higher
4 100
Organizational Issues
Demonstrate
d Product in
the market
15
No
1 15
Yes
4 60
Customizable
interface
20 Yes 5 100 No 1 20
TOTAL 100 410 310
Table 1: System Acquisition Weighted Alternative Matrix
Source: (created by Author)
Hence, it can be easily seen that the customized development would be much more
efficient for the organization than the packaged installation.
Architectural Design
The system that is to be implemented makes use of a 2-tier architectural design.

5
SYSTEM ANALYSIS AND DESIGN
Figure 1: Architectural Design
Source: (created by Author)
Hardware and Software Specification
After the acquisition plan for the company has been developed the hardware and the
software specification of the system is also to be defined. This is basically a document that
describes the hardware and the software required for the implementation of the software for the
organization. The hardware and the Software requirement for the development of the system has
been provided below.
Standard Client Standard Application
Server
Standard Database
Server
Operating System Windows 10 Windows server 2012 Microsoft SQL Server