Texas Bicycle Sports

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

11. Reporting

12. Thank You • Any Questions or Comments?