System Analysis and Design Report: SAP Implementation in Toyota

This report provides a comprehensive analysis of the business process changes involved in implementing an SAP-based system within Toyota Cars. It details the transition from existing 'AS IS' processes to the proposed 'TO BE' processes, emphasizing the shift from paper-based operations to automated workflows. The report includes a time management plan, an entity-relationship diagram (ERD), and data normalization to illustrate the database structure. Furthermore, it addresses system testing, user training, and system changeover strategies. The analysis highlights improvements in scalability, adaptability, and data accessibility with the new system, enabling staff to focus on core tasks. The document concludes with a recommendation report to top management, outlining the project's objectives, scope, and focused processes.

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

1SYSTEM ANALYSIS AND DESIGN
Executive Summary
The report reflects the business process change in Toyota Cars. The organization is going to
implement a SAP based system within its environment. The implementation of new system
always demands changes in the exiting business processes. The To-Be process, designed in this
report, demonstrate the changes in the Toyota Car’s environment. The biggest change can be
seen the working method of the staff. The whole paper based works will be replaced with
automated processes. In order to cope with the change, the users of the system will be trained
during the project lifecycle.

2SYSTEM ANALYSIS AND DESIGN
Table of Contents
Introduction: 3
TASK 1: Time Management Plan: 3
TASK 2: “TO BE” Process 7
Task 3: Comparing “AS IS” and “TO BE” Process 7
Task 4: Entity Relationship Diagram 8
Task 5: Data Normalization 8
TASK 6: Testing 16
TASK 7: Training 16
TASK 8: System Changeover 16
TASK 9: Report to Top Management 17
Conclusion: 18
Bibliography: 19

3SYSTEM ANALYSIS AND DESIGN
Introduction:
SAP is the abbreviation of Systems Applications and Products within the domain of Data
Processing. The SAP ISs are consist of various completely integrated software modules. These
software modules are designed for supporting every aspect of business virtually. The ERP is the
ICT product that is implemented in an organization for supporting business process management.
Business process change is done within an organization to implement significant improvement in
productivity.
The report represent the business processes change, change handling process, database of
product sale and invoice generation and project time line based on the case study of Toyota Cars.
The To-Be process signifies which parts of the organization will be improved to support
proposed changes. The ERD shows the insight basic database structure.
TASK 1: Time Management Plan:
Task Name Duratio
n Start Finish Predecessor
s
Resource
Names Cost
SAP Implementation 124 days Thu
5/24/18
Tue
11/13/18 $10,840.00
Planning 19 days Thu
5/24/18
Tue
6/19/18 $1,888.00
Problem Definition 3 days Thu
5/24/18
Mon
5/28/18
Project
Manager $288.00
Project Charter
Development 3 days Tue
5/29/18
Thu
5/31/18 2 Project
Manager $288.00
Project Staff
Employment 4 days Fri 6/1/18 Wed
6/6/18 3 Project
Manager $384.00
Selection of SDLC
Model or Software
Development Life Cycle
1 day Thu
6/7/18
Thu
6/7/18 4
Analyst,
Project
Manager
$160.00
Project Schedule
Development 2 days Fri 6/8/18 Mon
6/11/18 5 Project
Manager $192.00
Project Budgeting 4 days Tue Fri 6 Project $384.00

4SYSTEM ANALYSIS AND DESIGN
6/12/18 6/15/18 Manager
Allocate Resources
Planning 2 days Mon
6/18/18
Tue
6/19/18 7 Project
Manager $192.00
Planning Phase
Complete 0 days Tue
6/19/18
Tue
6/19/18 8 $0.00
System Analysis and
Requirements 22 days Wed
6/20/18
Thu
7/19/18 $1,792.00
Identification of
Business Requirements 4 days Wed
6/20/18
Mon
6/25/18 9 Analyst $256.00
Identification of
System Requirement 3 days Tue
6/26/18
Thu
6/28/18 11 Analyst $192.00
Identification of User
Requirement 2 days Fri
6/29/18
Mon
7/2/18 12 Analyst $128.00
Verify Requirements 4 days Tue
7/3/18 Fri 7/6/18 13
Analyst,
Project
Manager
$640.00
Evaluating
Requirement 4 days Mon
7/9/18
Thu
7/12/18 14 Analyst $256.00
Documentation of
Requirement 5 days Fri
7/13/18
Thu
7/19/18 15 Analyst $320.00
System Analysis
Phase Complete 0 days Thu
7/19/18
Thu
7/19/18 16 $0.00
Entire System Design 41 days Fri
7/20/18
Fri
9/14/18 $3,088.00
Architecture
Designing of UK Library
Online System
4 days Fri
7/20/18
Wed
7/25/18 17 System
Designer $224.00
UML Diagrams
Designing 5 days Thu
7/26/18
Wed
8/1/18 19 System
Designer $280.00
Unit Design 2 days Thu
7/26/18
Fri
7/27/18 19 $0.00
Database Design 13 days Thu
8/2/18
Mon
8/20/18 $1,352.00
Selection of
Attributes and Entities 3 days Thu
8/2/18
Mon
8/6/18 20
SAP
Database
Developer,
System
Designer
$480.00
Schema Diagram
Creation 3 days Tue
8/7/18
Thu
8/9/18 23 System
Designer $168.00
Generate Entity
Relationship Diagram or
ERD
4 days Fri
8/10/18
Wed
8/15/18 24 System
Designer $224.00
Database 3 days Thu Mon 25 SAP $480.00

5SYSTEM ANALYSIS AND DESIGN
Normalization 8/16/18 8/20/18
Database
Developer,
System
Designer
SAP Design 12 days Tue
8/21/18
Wed
9/5/18 $840.00
User Interaction
Designing 4 days Tue
8/21/18
Fri
8/24/18 26 SAP
Designer $256.00
User Interface
Designing 5 days Mon
8/27/18
Fri
8/31/18 28 SAP
Designer $320.00
Functionality
Confirmation 3 days Mon
9/3/18
Wed
9/5/18 29 SAP
Developer $264.00
Network Diagram
Designing 2 days Thu
9/6/18 Fri 9/7/18 30 System
Designer $112.00
Network Design 5 days Mon
9/10/18
Fri
9/14/18 31 System
Designer $280.00
Completion of
Designing Phase 0 days Fri
9/14/18
Fri
9/14/18 32 $0.00
Development 41 days Mon
9/17/18
Mon
11/12/18 $3,912.00
Implement SAP 18 days Mon
9/17/18
Wed
10/10/18 33 SAP
Developer $1,584.00
Implement Unit
Application 12 days Thu
10/11/18
Fri
10/26/18 35 Coder $1,248.00
Implement Database 7 days Mon
10/29/18
Tue
11/6/18 36
SAP
Database
Developer
$728.00
Implement Network 4 days Wed
11/7/18
Mon
11/12/18 37 SAP
Developer $352.00
Complete of
Development 0 days Mon
11/12/18
Mon
11/12/18 38 $0.00
Deployment 1 day Tue
11/13/18
Tue
11/13/18 $160.00
Go Live 1 day Tue
11/13/18
Tue
11/13/18 39
Analyst,
Project
Manager
$160.00
Deployment
Completion 0 days Tue
11/13/18
Tue
11/13/18 41 $0.00

6SYSTEM ANALYSIS AND DESIGN
ID Task
Mode
WBS Task Name Duration Start Finish Predecessors
0 0 SAP Implementation 124 days Thu 5/24/18 Tue 11/13/18
1 1 Planning 19 days Thu 5/24/18 Tue 6/19/18
2 1.1 Problem Definition 3 days Thu 5/24/18 Mon 5/28/18
3 1.2 Project Charter Development 3 days Tue 5/29/18 Thu 5/31/18 2
4 1.3 Project Staff Employment 4 days Fri 6/1/18 Wed 6/6/18 3
5 1.4 Selection of SDLC Model or Software Development Life Cycle1 day Thu 6/7/18 Thu 6/7/18 4
6 1.5 Project Schedule Development 2 days Fri 6/8/18 Mon 6/11/18 5
7 1.6 Project Budgeting 4 days Tue 6/12/18 Fri 6/15/18 6
8 1.7 Allocate Resoruces Planning 2 days Mon 6/18/18 Tue 6/19/18 7
9 1.8 Planning Phase Complete 0 days Tue 6/19/18 Tue 6/19/18 8
10 2 System Analysis and Requirements 22 days Wed 6/20/18 Thu 7/19/18
11 2.1 Identification of Business Requirements 4 days Wed 6/20/18 Mon 6/25/18 9
12 2.2 Identification of System Requirement 3 days Tue 6/26/18 Thu 6/28/18 11
13 2.3 Identification of User Requirement 2 days Fri 6/29/18 Mon 7/2/18 12
14 2.4 Verify Requirements 4 days Tue 7/3/18 Fri 7/6/18 13
15 2.5 Evaluating Requirement 4 days Mon 7/9/18 Thu 7/12/18 14
16 2.6 Documentation of Requirement 5 days Fri 7/13/18 Thu 7/19/18 15
17 2.7 System Analysis Phase Complete 0 days Thu 7/19/18 Thu 7/19/18 16
18 3 Entire System Design 41 days Fri 7/20/18 Fri 9/14/18
19 3.1 Architecture Designing of UK Library Online System 4 days Fri 7/20/18 Wed 7/25/18 17
20 3.2 UML Diagrams Designing 5 days Thu 7/26/18 Wed 8/1/18 19
21 3.3 Unit Design 2 days Thu 7/26/18 Fri 7/27/18 19
22 3.4 Database Design 13 days Thu 8/2/18 Mon 8/20/18
23 3.4.1 Selection of Attributes and Entities 3 days Thu 8/2/18 Mon 8/6/18 20
24 3.4.2 Schema Diagram Creation 3 days Tue 8/7/18 Thu 8/9/18 23
25 3.4.3 Generate Entity Relationship Diagram or ERD 4 days Fri 8/10/18 Wed 8/15/18 24
26 3.4.4 Database Normalizaion 3 days Thu 8/16/18 Mon 8/20/18 25
27 3.5 SAP Design 12 days Tue 8/21/18 Wed 9/5/18
28 3.5.1 User Interaction Designing 4 days Tue 8/21/18 Fri 8/24/18 26
29 3.5.2 User Interface Designing 5 days Mon 8/27/18 Fri 8/31/18 28
30 3.5.3 Functionality Confirmation 3 days Mon 9/3/18 Wed 9/5/18 29
31 3.6 Network Diagram Designing 2 days Thu 9/6/18 Fri 9/7/18 30
32 3.7 Network Design 5 days Mon 9/10/18 Fri 9/14/18 31
33 3.8 Completion of Designing Phase 0 days Fri 9/14/18 Fri 9/14/18 32
34 4 Development 41 days Mon 9/17/18 Mon 11/12/18
35 4.1 Implement SAP 18 days Mon 9/17/18 Wed 10/10/18 33
36 4.2 Implement Unit Application 12 days Thu 10/11/18 Fri 10/26/18 35
37 4.3 Implement Database 7 days Mon 10/29/18 Tue 11/6/18 36
38 4.4 Implement Network 4 days Wed 11/7/18 Mon 11/12/18 37
39 4.5 Complete of Development 0 days Mon 11/12/18 Mon 11/12/18 38
40 5 Deployment 1 day Tue 11/13/18 Tue 11/13/18
41 5.1 Go Live 1 day Tue 11/13/18 Tue 11/13/18 39
42 5.2 Deployment Completion 0 days Tue 11/13/18 Tue 11/13/18 41
Project Manager
Project Manager
Project Manager
Analyst,Project Manager
Project Manager
Project Manager
Project Manager
6/19
Analyst
Analyst
Analyst
Analyst,Project Manager
Analyst
Analyst
7/19
System Designer
System Designer
SAP Database Developer,System Designer
System Designer
System Designer
SAP Database Developer,System Designer
SAP Designer
SAP Designer
SAP Developer
System Designer
System Designer
9/14
SAP Developer
Coder
SAP Database Developer
SAP Developer
11/12
Analyst,Project Manager
11/13
M J J A S O N D
Half 1, 2018 Half 2, 2018
Figure 1: Gantt Chart of SAP Development
(Source: Created by Author)
Figure 2: Work Breakdown Structure of Proposed Project
(Source: Created by Author)

7SYSTEM ANALYSIS AND DESIGN
TASK 2: “TO BE” Process
Task 3: Comparing “AS IS” and “TO BE” Process
The modified business processes will be greatly scalable and adaptive. The proposed
SAP system will carry out most of the back office processes automatically. The business
processes will be depended upon automated systems. The system will gather and retrieve the
required data easily. This will eliminate the hassle of paperwork. Thus, the staff will be able to
concentrate on his works properly.

8SYSTEM ANALYSIS AND DESIGN
Task 4: Entity Relationship Diagram
Figure 4: Entity Relationship Diagram
(Source: Created by Author)
Task 5: Data Normalization
Table: Payment
Attribute Constraint Data Type
Payment_ID Primary Key Varchar (40)
Payment_Date Varchar (40)
Payment_Amount Varchar (40)
Invoice_Date Varchar (40)
Invoice_Amount Varchar (40)
Order_Quantity Varchar (40)

9SYSTEM ANALYSIS AND DESIGN
Order_Date Varchar (40)
Order_Amount Varchar (40)
Model Varchar (40)
Make Varchar (40)
Manufacturer Varchar (40)
Cost Varchar (40)
License_number Varchar (40)
Name Varchar (40)
Address Varchar (40)
Contact Varchar (40)
Card_Holder_Name Varchar (40)
Number Varchar (40)
CVV Varchar (40)
Expiery_Date Varchar (40)
First Normal Form: In order to be in the first normal form, the database tables must not
have any multivalued attribute. The following database table is consisting of single valued
attributes.

10SYSTEM ANALYSIS AND DESIGN
Table: Payment
Attribute Constraint Data Type
Payment_ID Primary Key Varchar (40)
Payment_Date Varchar (40)
Payment_Amount Varchar (40)
Invoice_Date Varchar (40)
Invoice_Amount Varchar (40)
Order_Quantity Varchar (40)
Order_Date Varchar (40)
Order_Amount Varchar (40)
Model Varchar (40)
Make Varchar (40)
Manufacturer Varchar (40)
Cost Varchar (40)
License_number Varchar (40)
Name Varchar (40)
Address Varchar (40)

11SYSTEM ANALYSIS AND DESIGN
Contact Varchar (40)
Card_Holder_Name Varchar (40)
Number Varchar (40)
CVV Varchar (40)
Expiery_Date Varchar (40)
Second Normal Form: The second normal form entails that the non-key attributes must
be depended on the primary key only. Make, Manufacturer, Cost, License_number are depended
on the model of the car. Therefore, the new table of car will be like.
Table: Car
Attribute Constraint Data Type
Car_ID Primary Varchar (40)
Model Varchar (40)
Make Varchar (40)
Manufacturer Varchar (40)
Cost Varchar (40)
License_number Varchar (40)