vfp资料（VFP data）.docVIP

vfp资料（VFP data） The first chapter: 1. data management through the following stages: manual management, file system, database system, distributed database system, object oriented database system, the data began to separate from the program is: database system, database system is the advanced stage of object-oriented database systems. 2. database is a collection of related data, and table management is the contact between the tables, a detailed database is a practical model. 3. entities: the objective existence and differences between things, can be specific things, can also be a abstract concept. For example: students, students Entity type: abstract entity appearance, is a set of properties, is a kind of entity type, equivalent to the structure of the table. The entity set a set of similar entities, all the records of the equivalent of a table. 4. types of entities or the relationships between tables can be divided into three kinds: one to one, one to many, many to many. To establish a relationship between two tables for more, only need to build third table - link table, to achieve the two one to many relationship. 5. terms: A.: two-dimensional table in VFP. As an extension table file named.Dbf. B. mode: the structure corresponding to the relationship between the equivalent structure of the table. C. tuple: horizontal two-dimensional table, in VFP, also called the record. The D. attribute table: vertical columns, and call records. E.: the range of domain attributes. Such as logic field domain: logic or logic really false. Key words: F. can only attribute mark a tuple or the combination of attributes (fields or fields combined), divided into two types: the main keyword and candidate key. Key features not only can reflect the main keywords, but also for other tables and contact. Key words: this table is not outside the g. keyword, is another form of keywords (a primary key or a candidate key, this field) is the external keyword, generally with the external key to ensur