1 / 12

Texas Bicycle Sports

Texas Bicycle Sports. Presented by : Muhammad Rizvi Terry Lee Madhuri Yelamanchili. Background. Texas Bicycle Sports is a single location, family owned business with 6 employees. Specializes in the sales and service of high-end bicycles and bicycle parts.

owen
Download Presentation

Texas Bicycle Sports

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 Bicycle Sports Presented by : Muhammad Rizvi Terry Lee MadhuriYelamanchili

  2. Background • Texas Bicycle Sports is a single location, family owned business with 6 employees. • Specializes in the sales and service of high-end bicycles and bicycle parts. • Has been in business since 1972. • Has strong loyal customer base. • Currently operating on a manual paper based system.

  3. Requirements • User Friendly • Track Sales by employee, product, category, day, week, and month • Retain Customer History • Inventory Management (Real time updates in store as well as online) • Accessible from Internet for Online Sales (In order to increase sales from the internet, system must be able to process customer orders from company website) • Generate reports (Inventory, Sales, Customer, Employee, etc…)

  4. Inputs • Customer Information (Name, Phone Number, Address, E-mail, etc…) • Employee Information (Name, Phone Number, Address, E-mail, Hire Date, Salary, etc…) • Product Information (Selling Price, Initial Cost, Quantity on Hand) • Sales Information (Product/Products Customer is requesting to purchase) • Payment Information (Cash, Check, Credit Card)

  5. Outputs • Customer History Reports • Sales Reports (Employee, Product, Daily, Weekly, Monthly) • Inventory Reports (Product, Category, Hot Sellers) • Customer Receipts • Shipping Information for Internet Sales

  6. System Components

  7. Structured Chart

  8. Entity-Relationship Diagram

  9. Physical Design • Customer • Customer_ID, First_ Name, Last _Name, Street_Number, Street_Name, City, State, Zip_Code, Phone_Number, Email  • Inventory • Product_ID, Description, Quantity_on_Hand, Date_Received, Cost, Selling_Price, Vendor_ID • Vendor_Product • Vendor_ID, Product_ID • Vendor • Vendor_ID, Vendor_Name, Street_Number, City, State, Zip_Code, Phone_Number, Email  • Invoice • Invoice_ID, Product_ID, Customer_ID, Employee_ID, Quantity, Price, Total, Date_Sold • Employee • Employee_ID, First_Name, Last_Name, Street_Number, Street_Name, City, State, Zip_Code, Phone_Number, Email, Hire_Date, Salary, Commission_Rate

  10. Reporting

  11. Thank You • Any Questions or Comments?

More Related