二级vf2（Level two vF2）.doc

二级vf2（Level two vF2） Chapter 1 VF database base 1.1 basic knowledge of database (1) the database has gone through: artificial management, file systems, database systems, distributed database systems, object-oriented database systems. (2) the main purpose of database technology: A, to improve data sharing, B, to reduce data redundancy, C, to provide data and application independence. (3) database DB, database management system DBMS, database application system DBAS, database administrator DBA, database system DBS - DBS, including DBMS and DB, DBMS is the core (4) the relation between two entities is mainly attributed to three types: One to one contact, one knot, many links, many to many links (5) the database model is divided into three types: hierarchical model (tree structure), representing an entity and connection, network model, network structure, representation, relation model (a two-dimensional table is a relationship, every relationship is a two-dimensional table, table relationship = = contact) 1.2 relational database (1) a, relation = table B, entity = tuple = record = line C, attribute = field = column D, keyword = index (2) traditional set operations: (or) open, upward, poor, Make (and) openings downward Specialized relational operations: Choice - the choice of line, where appears to be the choice Projection - the operation of columns, mainly select Connections - connections are lateral combinations of relationships Natural connection - removes the equivalent connection of repeated attributes, and joins them as equal connections by field values corresponding to equal values (3) VF is a 32 bit database development system (DBMS) for Microsoft Corporation, which can run on Windows XP and Windows NT platform (4) various file tabs: A, data tab - database, free table, query, view B, document tab - forms, reports, labels C, code tab - program D, other tabs - text files, menu files (5) main file extension Project: pjx database: DBC data table: DBF query: QPR view,