The AutoParts Industry

1
Introduction

• The AutoParts Industry

2
BackGround Information

• How the industry operates
• Organization and Structure
• Technology
• Outsourcing

3
ABC AutoParts

• Regional Auto-Parts Chain
• Core Strength is Customer Service
• Wants to stay competitive
• Wants to increase their customer base

4
ABC AutoParts

• How do they accomplish this goal???
• Build a E-Commerce Web Site
• Expand more nationally
• Go Global
• Better customer service by giving the customers
  want they want when they want it.

5
Current Problems

• Auto parts stores do not carry a wide variety of
  auto parts.
• Auto parts stores and dealers are not
  time-sensitive to customers needs.
• Many auto parts stores use a breath approach (do
  not carry specialized auto parts).

6
E-Commerce Opportunities

• Decrease the supply chain
• Improved EDI
• Utilize a just-in-time system of product
  replenishment.
• Offer greater variety of auto parts to the
  customer

7
Project Scope

• Produce an effective and fully functional
  e-commerce web site
• Easily changeable/adaptable to a client/server
  environment
• Use a distributed/open architecture for design
  and development. (Corba/Com)

8
New System DFD

• Pictorial View of the New System

9
Context Level DFD
TO BILLING (OUT SOURCE)
CUSTOMER INFO PART REQUEST
Galaxy Auto-Parts System
Bibit Payment Service
Customer
REJECTS REQUEST
Shipping Department
TO SHIPPING
PART(S) FOR PICK-UP
DELIVER CUSTOMER PART(S)

10
Level 0 DFD
Online Form (Template)
Part(s) Lookup
1.0
2.0
Customer
Cus. Info part(s) request
Look for part(s)
Process order
Customer information
Information already exist
Finds part(s)
Bibit Payment Service
Customer File
Part(s) Inventory File
Deliver customer part(s)
Process part(s) information
Rejects request
To Billing
3.0
4.0
Verification of Part(s)
Shipping Department
Deliver Part(s)
To Shipping
Part(s) for Pick-up
11
Shipping Process Requirements

• Shipping will be conducted by a third party
  Shipping/Logistics company.
• Shipping is automated using Oracle as DBMS.
• Must conform to ODBC compliant standards.

12
Billing Process Requirements

• Billing will be totally outsourced to an internet
  billing service.
• The service is fully multicurrency and supports a
  large number of international payment methods.
• Uses SSL to ensure secure on-line transactions

13
Tiered Architecture

• Web-Based vs. Client Server

14
Web Version
Internet
DatabaseServer
BusinessRules
ContentServer
15
Client Server Version
DatabaseServer
Server
Client
16
Application Architecture

• Programming Language (C and VB)
• Database Management System (Oracle)
• Middle Ware Solution (Corba)
• Html Editor (Macromedia DreamWeaver 2)
• Scripting Languages (JavaScript, VbScript, Perl)
• Software Deployment Utility (Install Shield)

17
Database Infrastructure

• 3 types of databases
• Customer Database
• Vendor Database
• Inventory Database
• Use Oracle as DBMS

18
Customer Database

• Used to keep a record of customers and their
  transactions.
• Sample Database Schema
• Cus_Num PK
• Cus_Fname
• Cus_Lname
• Cus_Address
• Cus_Email
• Prod_Code FK

19
Inventory Database

• Used to keep a record of all the parts located in
  the warehouse
• Sample Database Schema
• Prod_Code PK
• Prod_Descript
• Prod_Price
• Prod_Type
• Vend_Code FK

20
Vendor Database

• Used to keep a record of all the vendors that the
  autopart chain buys its merchandise from.
• Also is important for proper EDI standards
  between ABC Autoparts and its Vendors.
• Sample Database Schema
• Vend_Code Pk
• Vend_Name
• Vend_Address
• Vend_Zip
• Vend_Phone

21
Use Case Diagrams

• Two Use Case Diagrams
• Existing User Diagram
• New User Diagram

22
New User Diagram
23
Existing User Diagram
24
Galaxy Home on the Web

• Striving for a friendly user interface
• Making it possible to use a smart search
• Keeping track of a customers history for easy
  reference