b257f1b98ba35dce0575938d51f699e6.ppt
- Количество слайдов: 68
Visual Fox. Pro 6. 0 Seminar Presented by Jim Booth Email: jbooth@jamesbooth. com In cooperation with Rainer Becker and the German Fox. Pro User’s Group (d. FPUG) Visual Fox. Pro™ Seminar
General Issues Related to Development u u Understanding the costs Lowering the costs Ø The Value of Conventions and Standards Ø The Value of Object Oriented Design Ø The Development Cycle Ø Managing Risks Visual Fox. Pro™ Seminar
Database Design u u Characteristics of a “Relational Database Management System” Normalization of Data Design Visual Fox. Pro™ Seminar
Normalization Visual Fox. Pro™ Seminar
Why bother with Normalization u u Reduce the possibility of data inconsistencies Reduce the space required for storing data Reduce possible update and delete anomalies Increase the stability of the data design Visual Fox. Pro™ Seminar
First Normal Form Reduce entities to first normal form (1 NF) by removing repeating or multi-valued attributes to another, child, entity. Visual Fox. Pro™ Seminar
First Customer Pass Customer # Company Name Address Contact 1 Contact 2 Phone 1 Phone 2 Visual Fox. Pro™ Seminar
Removing the Repeating Groups Contacts Customer # Contact # Customer # Name Address Phone Code Company Name Address Contact 1 Contact 2 Phone 1 Phone 2 Phones Customer # Phone Code Area Code Phone Number Visual Fox. Pro™ Seminar
2 nd Normal Form Reduce 1 NF entities to second normal form (2 NF) by removing attributes that are not dependent on the whole primary key. Visual Fox. Pro™ Seminar
Invoice Line Item File Invoice Number Line Number Customer ID Product ID Visual Fox. Pro™ Seminar
Remove the Non. Dependent Fields Line Item Customer ID Invoice Visual Fox. Pro™ Seminar
3 rd Normal Form Reduce 2 NF entities to third normal form (3 NF) by removing attributes that depend on other, non-key attributes (other than alternate keys). Visual Fox. Pro™ Seminar
Purchase Order Number Vendor ID Vendor City Visual Fox. Pro™ Seminar
Remove Fields Depending on Non-key attributes Purchase Order Vendor City Vendor Visual Fox. Pro™ Seminar
Boyce/Codd Normal Form Reduce 3 NF entities to Boyce/Codd normal form (BCNF) by ensuring that they are in 3 NF for any feasible choice of candidate key as primary key. Visual Fox. Pro™ Seminar
An Employee Table Emp. Id Employee Number Clock Number Visual Fox. Pro™ Seminar
An Employee Table Clock Number Employee Number Emp. Id Visual Fox. Pro™ Seminar
An Employee Table Employee Number Clock Number Emp. Id Visual Fox. Pro™ Seminar
Fourth Normal Form Reduce BCNF entities to Fourth normal form (4 NF) by removing any independently multi-valued components of the primary key to two new parent entities. Visual Fox. Pro™ Seminar
Employee - Skill - Objective Table Name Skill - Name Objective - Text Jones accounting more money prestige Jones public speaking more money Jones public speaking prestige Visual Fox. Pro™ Seminar
Fourth Normal Form Employee - Skill Name Skill - Name Employee - Objective Name Objective - Text Visual Fox. Pro™ Seminar
Fifth Normal Form Reduce 4 NF entities to fifth normal form (5 NF) by removing pair-wise cyclic dependencies (appearing within composite primary keys with three or more component attributes) to three or more new parent entities. Visual Fox. Pro™ Seminar
Retail Store Buyers Buying Buyer Vendor Product Mary Sally Suppose Liz Claiborne adds jeans to their list of products. We need to add two updates to our table because both Mary and Sally buy jeans and buy from Liz Claiborne. Jordache Liz Claiborne Visual Fox. Pro™ Seminar Jeans Sneakers Jeans Blouses
Fifth Normal Form Buy-Vend-Prod Buyer Vendor Product Buyer Product Visual Fox. Pro™ Seminar
Denormalization Normalized Name Address Postal Code Denormalized Name Address City Country Postal Code Visual Fox. Pro™ Seminar Postal Code City Country
Want to read more? Relational Database Selected Writings C. J. Date Addison-Wesley Publishing Company ISBN: 0 -201 -14196 -5 Handbook of Relational Database Design Candace C. Fleming and Barbara von Halle Addison-Wesley Publishing Company ISBN: 0 -201 -11434 -8 Visual Fox. Pro™ Seminar
Visual Fox. Pro Database Container u u u u Data dictionary Relationships Field level domains (Field Rule) Table level domains (Table Rule) Referential Integrity Stored Procedures Db. Get. Prop() and Db. Set. Prop() Visual Fox. Pro™ Seminar
View Designer u Updateable Ø The Update Tab in the view designer u Joins Ø Inner Ø Outer Ø Left, u Right, and Full Top N Visual Fox. Pro™ Seminar
Using SQL in the Visual Fox. Pro Language u u Why use SQL at all? The SQL Commands in Visual Fox. Pro Ø SELECT Ø UPDATE Ø DELETE Ø CREATE Ø INSERT INTO Visual Fox. Pro™ Seminar
Designing User Interfaces Visual Fox. Pro™ Seminar
Principle 1 The User Is In Control Visual Fox. Pro™ Seminar
Principle 2 Follow The Object-Action Paradigm Visual Fox. Pro™ Seminar
Principle 3 Be Consistent Visual Fox. Pro™ Seminar
Principle 4 Make Things Self Evident Visual Fox. Pro™ Seminar
Principle 5 Pay Attention To Aesthetics Visual Fox. Pro™ Seminar
Principle 6 Give The User Feedback Visual Fox. Pro™ Seminar
Principle 7 Be Forgiving Visual Fox. Pro™ Seminar
Object Oriented Development Visual Fox. Pro™ Seminar
OO Terminology u u u u Class Object Abstraction Polymorphism Inheritance Messaging Containership Visual Fox. Pro™ Seminar
Analysis and Design in an OO world u The Iterative Approach Ø Inception Ø Elaboration Ø Construction Ø Analysis, Design, Coding, Testing, Implementation, Training, Maintenance/Evolution Ø Transition Visual Fox. Pro™ Seminar
Analysis and Design in an OO world There is a constant looping back in this OO development cycle. New requirements discovered during coding or implementation feed back into the design phase. New functional requirements discovered alter future iterations Visual Fox. Pro™ Seminar
The Visual Fox. Pro Class Designer u u u Save As Class menu option Adding properties and methods to a class Specifying an Include file for a class Creating subclasses Adding controls to the form designer’s toolbar from your Classes Visual Fox. Pro™ Seminar
The Application Framework u u u What is a framework? The overview of the architecture of the framework Strategies for maximizing maintainability Visual Fox. Pro™ Seminar
The Framework In Detail u u u u The Application Manager The form class The startup program Building an application using the framework The form The Menu Enhancing your framework Visual Fox. Pro™ Seminar
Form and Class Design u u Coding methods in a reusable way Using THISFORM, THIS, and the Parent property Using WITH/ENDWITH Using collections to address the contents of a container Visual Fox. Pro™ Seminar
Simple Base Classes Label, Textbox, Edit. Box, Check. Box, Option Button, Option Group Command Button, Command Group Spinner, Image, Line, Shape, Timer Container, and Separator Visual Fox. Pro™ Seminar
Complex Base Classes Combo. Box, List. Box, and Grids Page. Frames Custom, Container, and Control Form, Formset, and Toolbar Visual Fox. Pro™ Seminar
Using Builders Ø The Visual Foxpro Builders Ø Make it easier to setup the complex controls Ø Building your own builders Ø Builder. dbf and Builder. app Ø ASELOBJ() Ø Using the special Builder property of a class Visual Fox. Pro™ Seminar
OLE Base Classes u OLEBound. Control Ø Bound file u to a General Field in a DBF OLEControl Ø Predefined contents at design time. Visual Fox. Pro™ Seminar
Active. X Automation u u u Structure of Active. X Direct Manipulation of an Active. X server Automation of an Object Inside of an OLEControl Visual Fox. Pro™ Seminar
Multi-user Issues u u What is the multi-user problem? Two strategies (Philosophies) Ø Optimistic Ø It is unlikely that there will be a problem when I try to save. Ø Pessimistic Ø It is very likely there will be a problem when I try to save. Visual Fox. Pro™ Seminar
Data Buffering u u u How did we do this before? What’s new and different now? Row versus Table buffering Pessimistic versus Optimistic buffering Choosing the correct buffering mode Visual Fox. Pro™ Seminar
Setting the Buffering Mode Ø Cursor. Set. Prop() (Cursor. Get. Prop()) Ø Using a Cursor’s Buffer. Mode. Override property Visual Fox. Pro™ Seminar
Saving Buffered Edits u u Table. Update() Table. Revert() Get. Fld. State() Get. Next. Modified() Visual Fox. Pro™ Seminar
Transaction Processing The all or none approach BEGIN TRANSACTION, END TRANSACTION, and ROLLBACK Resolving conflicts using CURVAL() and OLDVAL() Visual Fox. Pro™ Seminar
Client/Server - Is It For You? u When does Client/Server make sense? Ø Security Ø Scalability Ø Central Control of Data Visual Fox. Pro™ Seminar
Remote Data Sources u u Setting up data sources under Windows (95, NT, 98) Connections in Visual Fox. Pro Using Remote Views Using SQL Passthrough functions Visual Fox. Pro™ Seminar
Designing Client/Server Applications u User Interface Design Ø No more BROWSE of the customer table u Awareness that your code does not have absolute control over the data updates. Visual Fox. Pro™ Seminar
Using Visual Fox. Pro to Create an Active. X Server u u OLEPublic classes Designing the Server Visual Fox. Pro™ Seminar
Creating Your Own Active. X Automation Servers u In-Process versus Out of process servers Ø DLL u u u versus EXE Compiling the server Registering the server Using the server Visual Fox. Pro™ Seminar
The Visual Fox. Pro Debugger u u The debugger as a developer’s tool Choosing a Fox. Pro frame or the debugger frame Saving and restoring debugger settings Hot Keys in the debugger Visual Fox. Pro™ Seminar
The Debugger Windows Ø Trace Ø Watch Ø Locals Ø Call Stack Ø Output Ø SET DEBUGOUT TO Ø Event Tracking Ø Setting Breakpoints Visual Fox. Pro™ Seminar
Coverage Analysis/ Application profiling u u u SET COVERAGE TO <File. Name> Turning coverage on and off Using the Coverage Profiler Visual Fox. Pro™ Seminar
Using Assertions u u The ASSERT command SET ASSERTS ON/OFF Visual Fox. Pro™ Seminar
Using The Debug. Out Command u u Does not mess up your application screen Does not introduce extra window focus events to your application Visual Fox. Pro™ Seminar
Visual Fox. Pro and the Internet u u u What is HTML? How does the Internet work? The Internet Search Wizard Accessing the search wizard page The Web Publishing Wizard Visual Fox. Pro™ Seminar
Advanced Class Design Concepts u Inheritance Hierarchy Ø The u Containership Hierarchy Ø The u is-a relationship has-a relationship Design Patterns Visual Fox. Pro™ Seminar
Accessing the Windows API from Visual Fox. Pro u u u What is the API? DECLARE command Calling an API function Visual Fox. Pro™ Seminar
b257f1b98ba35dce0575938d51f699e6.ppt