BCO2041 System Analysis and Design: Sunshine Motors System Spec

This report presents a system specification for Sunshine Motors' Car Dealership Service Department, addressing the need to replace outdated manual systems. It details the recommended system acquisition strategy, using a weighted alternative matrix to justify the choice of custom development over packaged software. The report covers architectural design based on a 2-tier model, hardware and software specifications, interface design with structure diagrams, user interface flow, and wireframe diagrams. Furthermore, it includes program design considerations, a structure chart illustrating system functionalities in a top-down approach, and program specifications outlining module purposes and input/output details. The conclusion emphasizes the necessity of the new information system for improved efficiency and growth, providing a comprehensive overview of its development and implementation.

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

6
SYSTEM ANALYSIS AND DESIGN
R2
Special Software Microsoft Excel Visual Studio Visual Studio
Hardware  250-GB disk
drive
 Intel Core i3
dual core
processor
 500 GB hard
drive
 Xeon Quad
core
Processor
 1 TB hard
drive
 Xeon Quad
core
Processor
Network Local LAN connection 100 MBps Ethernet 100 MBps Ethernet
Table 2: Hardware and Software Specification
Source: (created by Author)

7
SYSTEM ANALYSIS AND DESIGN
Interface Design
Interface Structure Diagram
Figure 2: Interface Structure Diagram
Source: (created by Author)

8
SYSTEM ANALYSIS AND DESIGN
User Interface Flow

9
SYSTEM ANALYSIS AND DESIGN
Figure 3: User Interface Flow
Source: (created by Author)
Wireframe diagrams
Main menu
Client Registration

10
SYSTEM ANALYSIS AND DESIGN
Login Page

11
SYSTEM ANALYSIS AND DESIGN
Request Service