140 likes | 273 Vues
This document outlines the business requirements and system design for Texas Cars LLC's inventory management system. The goal is to develop a database that supports multiple functionalities, including a login portal for administrative personnel at each branch and an interactive login portal for customers to create wish lists. Users can browse cars by various specifications, such as make, model, color, and price. The system will include context diagrams, data flow diagrams, and detailed design requirements to ensure a streamlined experience for both customers and branch managers.
E N D
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
Table of Contents • Business Requirements • Context Diagram • Level 0 DFD • Level 1 DFD • Level 2 DFD
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.
Context Level • Entities Customer Branch Manager • Data flow to and from external entities
Level 0 • Entities Customer Branch Manager • Processes Search Car Details Update Customer Information Run Reports Update Car Details • Data Stores Inventory Customers
Level 1 Process 2 (Customer Information) • Entity Customer • Processes Login Create Profile • Data Store Customers
Level 2 Process 2 (Create Profile) • Entity Customer • Processes Data Validation Email Verification • Data Store Customers
Level 1 Process 3 (Run Reports) • Entity Branch Manager • Processes Select Report Process Inventory Report Customer Report • Data Stores Customers Inventory