Jim Booth
  Jim is a software designer and programmer specializing in relational database systems both on the desktop and internet. He has been at this pursuit since the late 1970's when a megabyte of data was considered big. Jim has been the proud recipient of the Microsoft Most Valuable Professional award every year since the award was established in 1993. He has achieved the status of Microsoft Certified Professional in both Visual FoxPro Desktop Applications and Visual FoxPro Distributed Applications. Jim can be reached at www.jamesbooth.com  and jbooth@jemsbooth.com
  Working Wonders With Data Design
Ever need to add or remove fields from a table in a functioning database? Ever need to change a bunch of code because the data structures changed due to a new business requirement? Good database design can reduce these occurrences to almost zero. Knowing the design patterns for database problems can really speed up your data design work. Having a full set of "tricks of the trade" at hand can simplify your design work and stabilize your data designs.

This session will describe the various "types" of data we encounter and discuss some field proven approaches to designing databases that are powerful, flexible, and resilient.

Attendees will learn how to:
1. Separate the types of data into their respective sets
2. Design tables and databases that can handle business need changes over time
3. Reduce the potential for data anomalies
4. Maximize the flexibility of the database in serving the needs of the application
5. Recognize and apply the database design patterns

Skill level: Intermediate to Advanced
Suggested prerequisites: Exposure to database design and application development
  XML/XSLT, The MS XML DOM, and VFP to build web pages
So you have data that needs to get to the Web. You want to keep the data structured so it is easily maintained but you want the web pages to look inviting and readable to non-programmers. You want to keep the web site fresh and interesting over time by easily updating the look of the site without making changes to the data or the way it is transmitted to the web site.

Well all of these issues are the exact set of needs that can be addressed by using XML/XSLT transformations to build the web pages. Using the Microsoft XML DOM you can automate the production of the pages in VFP. You can even merge non-content data into the pages prior to generating the output from XML through XSLT.

Attendees will learn how to:
1. How XML can be used to move data around within a system
2. What role XSLT has in the management of data presentation
3. How to use VFP to manage the process of publishing data on the web
4. How to use the Microsoft XML DOM as a processor for XML/XSLT transformations

Skill level: Intermediate to Advanced
Suggested prerequisites:
1. Be familiar with HTML and XML.
2. Be fluent in VFP.
3. Understand OOP basics.