vf真题9（VF 9）.docVIP

vf真题9（VF 9） First, the basic operation items (4 items, first and 2 is 7, third and 4 is 8 points) Complete the following operations in the candidate folder: 1. create a database called order management and add the existing three tables of employee, orders, and customer to this database. 2. set up a common index for the orders table. The index name is NF and the index expression is year (date of signing). 3. establish the primary index for the employee table, and establish a common index for orders. The index name and index expression are all staff numbers. Create a one to many permanent relationship between the employee table and the orders table through the employee number. 4. set up referential integrity constraints for the above established links: update the rule to limit, delete the rule as cascade, and insert the rule as limit. The main points of examination: The establishment of a database, the addition of tables to a database, the establishment of primary and common indexes, and the establishment of an indexed table. Problem-solving thinking: 1., there are three commonly used methods for building databases: Building a database in the project manager; Create a database through the new build dialog box; Using command interaction to build the database, the command is: CREATE, DATABASE, [DatabaseName|? 2. add a free table to your database and can be completed in either the project manager or the database designer. Open the database designer in the database menu in the database designer or right click on the pop-up menu, select add, and then choose to add to the current database table free in the open dialog box. You can also add a free table to the current database with the ADD TABLE command. 3., in the index tab of the orders table designer, establish an index named NF, the index expression is year (signing date) general index, and the index name and index expression are the common indexes of the staff number. Index names and index expressions for employee are t