Texas Cars LLC

1. Texas Cars LLC Project Sponsor: Bob Smith CEO of Texas Cars LLC Phone: 281 990-9725 Fax: 281 555-5555 Email: bob.smith@texascars.com Presented By ArloCarreon Elvis Candelaria NupurAgarwal SwethaSrinivasan

2. Table of Contents • Business Requirements • Context Diagram • Level 0 DFD • Level 1 DFD • Level 2 DFD

3. Business Requirements • Design/create Database for Texas Cars’ inventory system. • Create a login portal for administrative personnel for each branch. • Create a login portal for potential customers to create wish lists. • Browse through the cars according to specifications such as make, model, color, price, mileage and type.

4. Context Level • Entities Customer Branch Manager • Data flow to and from external entities

5. Context Diagram

6. Level 0 • Entities Customer Branch Manager • Processes Search Car Details Update Customer Information Run Reports Update Car Details • Data Stores Inventory Customers

7. Level 0 DFD

8. Level 1 Process 2 (Customer Information) • Entity Customer • Processes Login Create Profile • Data Store Customers

9. Level 1 Process 2 DFD

10. Level 2 Process 2 (Create Profile) • Entity Customer • Processes Data Validation Email Verification • Data Store Customers

11. Level 2 Process 2 DFD

12. Level 1 Process 3 (Run Reports) • Entity Branch Manager • Processes Select Report Process Inventory Report Customer Report • Data Stores Customers Inventory

13. Level 1 Process 3 DFD (Run Reports)

14. Questions ?