The Virtual MDB Lab

Objectives

• Learn database analysis and design using the TSER method and the CASE tool IBMS.
• Gain some hands-on database processing experience with Oracle and PostgreSQL.
• Create a basic e-commerce platform using public domain or common software, such as PHP, Apache, XML, JAVA, Access, and MySQL.
• Build the knowledge of e-commerce application development with a Web database.
• Conduct systems analysis using the CASE tool IBMS.
• Understand the relationship between process models such as Data Flow Diagrams and database design through TSER.
• Acquire ways to create Metadadabase as an enterprise integration tool.

Table of Contents

Studio I: Database Design (Author: Somendra Pant and David Levermore)

• Studio I.0 - Homepages
• Studio I.1 - Installing and Using PostgreSQL
• Studio I.2 - CASE Tool
• Studio I.3 - TSER data modeling
• Studio I.4 - Oracle Database
• Studio I.5 - MetaDatabase

Studio II: E-Commerce (Author: David Levermore)

• Studio II.1 - Creating Dynamic Web Pages
• Studio II.2 - Connecting MS Access to the Web
• Studio II.3 - Introduction to XML
• Studio II.4 - MusicWeb: A Customer Ordering System
• Studio II.5 - JAVA
• Studio II.6 - Internet Commerce Security
• Studio II.7 - Web To Database Connectivity

Studio III: Systems Analysis (Author: Veera Boonjing)

• Studio III.1 - Introduction to IBMS/DFD tool
• Studio III.2 - Information systems modeling using IBMS tools
• Studio III.3 - Process modeling for an e-business example
• Studio III.4 - Database design using IBMS tools
• Studio III.5 - Introduction to IBMS/IDEF tool