CUSTOM CLOTHING (PowerPoint) by jennyyingdi

VIEWS: 16 PAGES: 12

									CUSTOM CLOTHING
“YOU DON’T HAVE TO COME TO US, WE’LL COME TO YOU”


PRESENTATION 3: Data Modeling & Program Design
                                                      Project Sponsors:

                                                              Ambarish Regmi
                                                                      Han Le
                                                               Miriam Barrera

                                 ISAM 4635
                          Systems Analysis & Design
BUSINESS NEEDS

 Replace the current system with
  computerized system.
 Shift efforts to improve customer
  services.
 Meet the business growing demand.
 Increase sales.
BUSINESS REQUIREMENTS

  Store customer, order, inventory, clothing
   line, and employee information.
  Have a user friendly interface.
  Provide an easy way to update existing
   information and add new information.
  Aid in managing inventory.
  Aid in internal order tracking.
CONTEXT DIAGRAM
   (Revised)
                                                    VENDOR




                                                    Inventory
                                                    Information
                                         Raw
                                         Material
                                                             Vendor
                                         Orders
                                                             Information



                                                         0                    Order Report

                  Customer Information                                      Inventory Report
                                                                            Customer Report
                     Order Info
      CUSTOMER                                                              Employee Report       MANAGEMENT
                                                    SYSTEM
                       Invoices
                                                                           Employee Information
                      Payment                                                Order Approval




                                          Order               Order
                                          Status              Assignment




                                              FACTORY
                                              (STAFF/TAILOR)
 LEVEL 0 DIAGRAM                                   (Revised)
                                              1                                     Update Order Info                         2

                                                                               Order Info                                                    Updated
                                           Pla ce       Store                                                              Pro cess          Inventory       D4          Inv ento ry
                      Order Info           Orders                                                                                                                        Info rmatio n
                                                        Order                                                              Orders             Available
    Custo mer
                                                                                                                                              Inventory
                                                                                                 Available                                                               Inventroy
                                                                                                 Tailor                                                                  Info
                         D5        Custo mer
                                   Info rmatio n         D1     Order
                                                                Info rmatio n           D2      Emplo y ee                        Order                                   6
                                     New                                                        Info rmatio n                     Approval
                                     Update
          Customer                                                Order
                                     Customer Info                                                                                                                  Ma na g e
          Info                                                    Info
                                                                                              Employee                                                              Inv ento ry
                              5                                                               Info                                                                  Info
                                                                           Update
                                                                           Order Info
                        Ma na g e
                        Custo mer                                                               7
                        Info rmatio n                                                                        Employee                                                 Vendor
                                                                       4                                     Information                                              Information
                                                                                            Ma na g e                         Ma na g ement
                                                                                            Emplo y ee                                                       Raw Material
                                                                  Ma na g e                 Info                                                             Orders             Inventory
                         3                                        Orders                                                                                                        Information

                                                                                                                                      Inventory
                                             Finished
     Invoices                                                                                                                         Report
                     Bill                    Order
Payment              Custo mers              Info           Order                                                    Employee
                                                                       Order
                                                            Assignment                                               Report
                                                                       Status                                                                Customer            Vendo rs/Suppliers
                                                                                                                                             Report
                           Update
                           Order                                                                                            Order Report
                           Billing
                           Info
                                                                   Fa cto ry
                D3      Billing                                                                                                                      Inventory      D4        Inv ento ry
                                                                                                                                       8             Info                     Info rmatio n
                        Sto ra g e

                                                                   D1       Order                                                 Pro cess
                                                                                                     Order Info                                                                Emplo y ee
                                                                            Info rmatio n                                         Reports                Employee    D2
                                                                                                                                                         Info                  Info rmatio n
                                                                  D5        Custo mer               Customer Info
                                                                            Info rmatio n
LEVEL 1 DIAGRAM - PLACE ORDERS
 (Revised)




                                      1.1
                                                      Customer
                                   Identify           Information     D5       Custo mer
        Custo mers   Order Info
                                   Custo mers                                  Info rma tio n
                                                  CstomerOrderInfo




                                    Place Order




                                      1.2

                                                    Store Order      D1
                                                                           Order Info rma tio n
                                  Sto re Orders
                   LEVEL 1 DIAGRAM - PROCESS ORDER
                                           (Revised)


                          Order Approval
Ma na g ement


                                              2.1
                                                                                       D4          Inv ento ry
                                            Check           Updated Inventory                      Info rma tio n
                            Order Info      Ma teria l
                                                                             Available Inventory


                                             Inventory
                                             Order


                                               2.2

   D1                                                    Available Tailors      D2           Emplo y ee
           Order Info rma tio n             Assig n                                          Info rma tio n
                                            Ta ilo rs



                                           Tailor-
                                           Inventory
                                           Order


                                               2.3

                   Update Order Info
                                             Upda te
                                             Orders
                                                                          Physical DFD
         3                                                                                                                                                                           7
                                                                                                                                                        Add
                                                                                                                                                      Employee                  Manage
                                     Finished Order Record                                                                                             Record
      Bill                                                                     D1           Order Table                                                                        Employee
   Customers                                                                                                                                                                  Information
                                                                                                                            D2 Employee Table

                     Update
                     Order                D3          Billing Table
Payment                                                                                                 Update                 Assign                                               Employee
         Order       Billing
 Input                                                                                                  Order                 Available                                            Input Form
        Invoice      Record
 Form                                                                                                   Record                 Tailor



                                                                                                                                  2
                                               1                                 Assigned Update                                                       Order
                       Order Input                                                Order   Order                              Process                  Approval                Management
    Customer             Form              Place                  Add
                                                                                  Record Record                                                        Form
                                                                 Order                                 Order                 Orders
                                           Orders                Record                                Record

                                                                                                                                                              Inventory
                                                                                                                        Assign         Update                   Report    Order
                                                                                                                      Available       Inventory                           Report
                                                                                                                                                                                      Employee
                                                                                                                      Inventory        Records
                                                                                                                                                                                       Report
                                                                                                                                                                          8
          Customer                                    D5      Customer Table                                                                      Inventory
            Input
                                                                                                                 D4    Inventory Table             Records          Process
            Form
                          5                          Add                                                                                                            Reports                 Customer
                                                    Update                              4                                                                                                    Report
                     Manage                        Customer
                     Customer                       Record                          Manage                                        6
                       Info                                                         Orders                                                                                 Order
                                                                                                                                                                          Records
                                                                                                                              Manage                           Customer
                                                                                                                             Inventory                         Records

                                                                                           Order                                                      Employee                D1         Order Table
                                                                               Assigned                                                                Records
                                                                                        Status Input
                                                                                Orders
                                                                                           Form
                                                                                                                                        Vendor
                                                                                                                Inventory     Inventory Input
                                                                                                                 Orders      Input Form Form
                                                                                                                                                                  D5 Customer Table


                                                                                                                                                              D2 Employee Table
                                                                                    Factory
                                                                                                                              Vendors
          System Components Diagram
                                             1
                                                                                      2
          Order Info                                                                                   Updated Order Info
                                       Place Orders
                                                                                  Process               Updated Inventory
                                                                                  Orders
                                                         Approved Order
                                            Store Order                                    Available Inventory
                                                                            Order Info
                                                                                   Available Tailor
                                                                                                                            3
                                                        Invoices
  Customer                                           Payments                                                                                                Factory
                       Customer Info                                                                               Bill Customers
                                                                                                                                    Update Billing Info
                                       5                                                          4
                                                                    7
                                                                                                                                 Order status
                                  Manage                                                     Manage
                                 Customer                    Manage                          Orders                                 Order Assignment
                                Information                Employee Info
External Entity                                                                                         Update Order Info                                 External Entity
                   New Update Customer Info                                           Order Assignment
                                                           Employee Info
                                                 6                                                                      8                 Order Report
                  Inventory Info
                                            Manage                                     Order Info
                                                                                                                  Process       Employee Report
   Vendors         Vendor Info             Inventory
                                                           Inventory Info
                                                                                     Employee Info                Reports
                                              Info                                                                              Inventory Report          Management
                                                                                          Inventory Info
                   Raw Material Orders                  Employee Information                 Customer Info                  Customer Report




                                                      D1           Orders                    D2       Employees




                                                 D3      Billing
                                                                                                  D4        Inventory

                                                                        D5       Customers
Entity Relationship Diagram (ERD)
      Inventory                   InventoryOrder

PK    Inv_ID             PK,FK2       Ord_ID
                         PK,FK1       Inv_ID
      Inv_name
      Inv_description                 Cust_ID
      Inv_vendor                      InvOrd_quantity
      Inv_quantity
      Inv_price



                                                             Customer
                                                        PK   Cust_ID
                                    Order
        Billing                                              Cust_fname
                        PK    Ord_ID                         Cust_lname
PK     Bill_ID                                               Cust_address
                        FK1   Cust_ID                        Cust_city
FK1    Ord_ID                                                Cust_state
                        FK2   Emp_ID
       Bill_date                                             Cust_zip
                              Ord_style
       Bill_unitAmt                                          Cust_phone
                              Ord_quantity
       Bill_total                                            Cust_email
                              Ord_date
                              Ord_completeDate               Cust_neck
                                                             Cust_shoulder
                                                             Cust_chest
                                                             Cust_waist
                                                             Cust_slength
                                                             Cust_wrist


                                  Employee

                             PK    Emp_ID

                                   Emp_fname
                                   Emp_lname
                                   Emp_address
                                   Emp_city
                                   Emp_state
                                   Emp_zip
                                   Emp_phone
                                   Emp_email
                                   Emp_payrate
                                                       Customer




                                               1.1
                                                       Order Info




                                    Identify
                                   Customers
                                                                                                     Order Info




                                                                                            1
                                                                                  Place
                                                                                  Orders
                                                     Place Orders




                                               1.2
                                   Store
                                   Orders
                      Available
                      Inventory




           2.1
                                                            Order Approval




Check
Material
                 Order Info




                                                2


                                   Orders
                                   Process
                                                                                                 Payments
                                                                                                 Received
                                                                                  3

                                                                        Bill




                                                                                                  Invoices
                                                                     Customers
                                                                                                                                        0




                 Inventory
                   Order                                                                               Order




           2.2
                                                                                                                         System
                                                                                                                         Custom
                                                                                                                         Clothing




                                                                                                     Assignment




Tailors
Assign
                    Tailor
                  Inventory
                                                                                  4




                    Order                                                                  Order Status
                                                                     Orders
                                                                     Manage




                    Update Order




           2.3
                         Order




Orders
Update
                       Approved/
                        Denied
                                                                                           Customer Info
                                                                                  5



                                                                      Info




                                                                                               Updated
                                                                    Manage
                                                                    Customer




                                                                                             Customer Info




                                                                                              Vendor Info

                                                                                             Inventory Info
                                                                                  6




                                                                                                 Purchase
                                                                      Manage




                                                                                                  Orders
                                                                     Inventory
                                                                                                                     Report
                                                                                                                   Inventory
                                                                                                                                            Program Design (Structure Chart)

                                                                                                                  Order Report




                                                                                             Employee Info
                                                                                  7
                                                                      Manage
                                                                     Employee
                                                                    Information
                                                                                                                   Report
                                                                                                                              Report
                                                                                                                  Customer
                                                                                                                             Employee




                                                                                              Vendor Info

                                                                                                Order Info
                                                                                  8




                                                                                             Employee Info
                                                                     Reports
                                                                     Process




                                                                                             Customer Info
Questions?

Thank you for your time.

								
To top