1 / 17

Texas Textiles Inc.,

Texas Textiles Inc.,. Group Members Krishna C Kandala Guruprasad Ramachandra Shweta Satish. System Request. Project Sponsor : Mr. Michael Stone CEO of Texas Textiles Inc., Phone : 281-217-5520 Fax: 832-475-2580 Email : michael.stone@tti.us.com. Business Background.

roman
Download Presentation

Texas Textiles Inc.,

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Texas Textiles Inc., Group Members Krishna C Kandala Guruprasad Ramachandra Shweta Satish

  2. System Request • Project Sponsor : Mr. Michael Stone • CEO of Texas Textiles Inc., • Phone : 281-217-5520 • Fax: 832-475-2580 • Email : michael.stone@tti.us.com

  3. Business Background • Texas Textiles Inc., is a textile dyeing company in the State of Texas. • Engages in the dyeing and sale of dyed fabrics • It operates a network of 6 franchise retail outlets in the state. • Administrative Office and Dyeing Facility : La Porte, Houston, TX

  4. Overview of Business Requirements • The new system should be capable of generating the work orders based on the information provided by the administrative office (order information is manually entered into the system). • The work orders are accessible to the dyeing facility based on which the orders are processed. • The system should have a reporting capability by which the inventory levels and the orders processed can be checked both by administrative office and by the dyeing facility. This information is needed to place an order for the raw materials as and when required. • The new system should be capable of generating invoice for the orders processed. • In addition to the above mentioned features the system should also have a capability of generating • Franchise Analysis Report and • Sales Analysis Report for the purpose of business analysis and future expansions.

  5. Context Diagram

  6. Level 0 Diagram

  7. Level 1 DFD for Order Processing contd.,

  8. Level 2 DFD for Approve Order contd.,

  9. Level 2 DFD for Generate Reports contd.,

  10. System Components

  11. Structure Chart

  12. Physical Design (Database) Franchise (Fran_id, Fran_name, Street, City, State, Country, Zipcode, Phone, Email) Orders (Order_num, Fran_id, Ship_addr, Order_date, Cloth_type, cloth_shade) Gray cloth (Cloth_code, Cloth_type, Cloth_level) Cloth_order (Order_num, Cloth_code, Cloth_used, Cloth_price, Cloth_subtotal) Dyes (Color_code, Color_shade, Dyes_level) Dye_orders (Order_num, Color_code, Dye_used, Dyes_price, Dyes_subtotal) Invoice (Invoice_num, Order_num, Inv_date, Inv_addr, Inv_phone, Labor_cost, Subtotal, Tax, Total) Inventory Invoice (II_num, Company_id, II_date, II_addr, II_phone, IIcloth_quantity, IIcloth_cost, IIdyes_quantity, IIdyes_cost, II_subtotal, II_tax, II_total)

  13. Chen Notation InventoryInvoice

  14. E-R Diagram

  15. Franchise Analysis Report

  16. Sales Analysis Report

  17. Thank you !!!

More Related