| This project is about the Tea Sales Management Information System (TSMIS), especially its design and implementation. TSMIS is an automated information system that allows the business owner to efficiently manage orders and tea sales information. It also allows customers to make online orders. The system is designed and implemented using multi-tier architecture. To find out some information needs, a case study of a typical tea seller company named Tea Trade Company (TTC) was consideredThe multi-tier architecture separates application functionality into independent layers or tiers. That is, multi-tier model adds logical layer(s) in the middle-tier of the traditional two-tier architecture. This overcomes the multiple limitations of the two-tier model. A typical multi-tier application consists of three elements namely the presentation-tier, middle-tier (application logic), and the data-tier. The multi-tier architecture provides some advantages. They include the reusability, easier modification of layers, multi-language support, centralized components, more efficient data access, and maintainability.In this project, the TSMIS is comprised of the data-tier, middle-tier, and presentation-tier. The data-tier deals with the database and other components such as stored procedures. SQL Server 2000 was used as a back-end database server. The middle-tier, in turn, deals with the COM component, which implement the different business rules. As for the presentation-tier, it concerns the user interface. User interface is made up of the front desk and the Web-based applications, which access the COM component Visual Basic was selected to implement the COM component and the front desk application; while ASP, HTML, Java Script, and VBScript were used to develop the Web-based application. The latter is mainly used by online or potential online customers. By simulating potential users, TSMIS application was tested and the test was successful.
|
PDF Full Text Request