70 likes | 77 Views
This conference scheduler system, presented by Summer Bug team, enables clients to easily submit room requests online and receive quick allocation confirmations. Detailed data flow diagram shows streamlined process from client input to room assignment. System provides improved communication and convenience for clients and employees. Lessons learned include database design importance, early start, and clear communication within the team. Future enhancements aim for automatic room allocation, advanced queries, added security, and better customer satisfaction.
E N D
Summer Conference SchedulerPresented bySummer Bug Maiya Delgoda Paula Flagg Yong Lee Louis Lim
Detailed Data Flow Diagram Clients Employees Add Conference Submit request form from website Receive request Allocate rooms Receive email Input client information Print master lists for dorms Print registration forms/receipts Clients check-in Receive receipts
Comparison • Estimated lines of code: 10,000 • Actual lines of code:
Lessons Learned • ASP works great with MS Access. • Make sure database design is sound before you begin coding. • Start early – things often take longer than you expect • Database should not be stored in same folder as web pages • Meet client more often • Not assuming things that are not clear • Team communication is important • Making sure all team members understand the objectives and design to ensure product continuity
Future Enhancements • Automatic room allocation • In version 1.0, the user manually allocates room assignments. In the next version the application could automatically allocate room assignments. • Advanced Queries • Expanding the queries page to include more options for searches. • Added security • Not letting users to access employee side • Stricter input format verification • Credit card transactions made possible
Customer Satisfaction • Initial Customer Request 1. Automatic room allocation 2. Less paper work, phone calls 3. No waiting in line • Project Outcome 1. User friendly web interface 2. A database of building and customer information 3. Reduced paper work, phone calls 4. No waiting in line 5. No automatic room allocation