Building Electronic Commerce with Web Database Constructions
Stephanie A. Nelson, W. Todd Nelson · Medical Entomology and Zoology · 2001
1. Introduction to Electronic Commerce. Introduction to basic EC terms. Comparison of EC to EDI. Comparison of traditional commerce to EC. Exploration of EC strategies and techniques used by businesses to reach corporate mission and increase profit. Elements of the Web. Client/server architecture (N-tier) review. Transition to prototyping EC solution: Web Database Construction. 2. Introduction to Web Database Construction. Introduction to basic Web processing terms. Review of different Web/database processing architectures. Client-side: browser extension, compiled browser programs. Server-side: scripting languages, compiled server programs. Web assessment techniques and exercises. 3. Getting Started: Web Server Installation and Administration. Web server software components. Installation of Personal Web Server. Installation of Web applications provided on the CD accompanying the book. Web server software configuration and maintenance. Web server security. 4. Prototyping Concepts. Guest book introduction. Online questionnaire introduction. Job Listing System introduction. Online Bookstore introduction. 5. Relational Database Concepts. Relational database terms and structure. Building Microsoft Access Queries. Designing Advanced Queries and analyzing data through the use of total queries and nested queries. Creating parameter-based queries. 6. HTML and HTML Forms. Creating a simple HTML form. Examining the tags. Creating controls, check boxes, multiple submit buttons, and selection tags. Using hidden fields. 7. Windows Common Gateway Interface. Background of WCGI. Overview of compiled server programming and connectivity approaches. Listing the CGI variables. Interpreting the path information. Passing user data and decoded data. Understanding CGI output. Creating a CGI application. 8. Connectivity: Utilizing. Creating a database file. Adding a table record through VB. Trapping database-related errors. Listing existing records. Finding records meeting a specific criteria. Analyzing and filtering records. Filtering records through a parameter query. 9. Browser Extensions. Creating template files with a CGI application. 10. Browser Programs. Overview of JavaScript and ActiveX. Hands-on tutorials for creating compiled browser programs using ActiveX. 11. Processing Template Files with a CGI Application. Sending output using a template file. Designing and testing a template file. Listing program variables in a template file. Evaluating expressions in a template file. Assigning variables in a template file. Specifying conditions in a template file. Creating loops in a template file. Including the contents of another file in a template file. 12. Displaying Database Records through Template Files. Displaying a database record from a template file. Navigating through records from a template file. Listing keyword search results through a template files. Using multiple template files to perform the drill-down search. 13. Enhancing the Electronic Commerce Application. Factors that affect how Web Database applications are designed. Speed. Layout. Change. Search-ability. Database structure. VB Project design. Appendices. A. Case Studies. B. Organization of Files on the CD. C. Source Code of the .bas library.