Higher Vocational Computer project task-driven mode of teaching materials: database technology and applications(Chinese Edition)

Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date :2012-08-01 Pages: 281 Publisher: basic information about the title of the Publishing House of Electronics Industry: Higher Vocational Computer project tasks drive mode textbook: database technology and application of original price: 33.00 yuan Author: Publisher: Electronics Industry Publishing Date: August 1. 2012 ISBN: 9787121180385 words: Pages: 281 Edition: 1st Edition Binding: Paperback: Weight: 458 g Editor's Choice Higher Vocational Computer project tasks drive mode textbook: Database Technology and Application as the Higher Vocational Computer professional database foundation textbooks. curriculum materials as applied undergraduate non-computer professional database. also available in computer information processing technology learning reference. The executive summary Higher Vocational Computer project task-driven mode of teaching materials: database technology and applications in accordance with the idea of ??learning by doing. arranged for two lines of classroom teaching projects + homework project. well-designed 26 task teaching implementation. Higher vocational computer project task-driven mode textbooks: database technology and applications are divided into three (Startup. operation papers and design papers). nine projects. Beginners combined Access2010DBMS and the student enrollment database instance. introduces the basic knowledge and basic database application technology. OPERATION to combine SQLServer2008DBMS and library database instance. introduction of database management and advanced applications. The design articles combined student public service platform database design examples. basic knowledge of database design and basic methods. Higher vocational computer project task-driven mode textbooks: database technology and application of National Excellent Courses Database Technology and Applications (Stephen Wong. Ben) supporting materials. Zhejiang Province is also key construction materials. Directory entry papers project to establish the student elective Database Task 1.1 Establish student elective database tasks described in task preparation tasks implementation 1.Access2010DBMS start New student enrollment database New Student Information table structure 4. Enter. edit student information sheet data. problem analysis the technical basis 1.Access2010 database 2.Access field type. establish Access database 4. modify the Access table structure theory foundation: basic concepts of database data management concept data management in three stages. database management system Task 1.2 student enrollment database tasks described in task preparation tasks set implementation of a set data table primary key set of data tables index set field validation rules set field inspection input function. analysis technical basis. settings the primary key index. theoretical foundation set field properties: the relational model. relationship defined relational model Task 1.3 Establishment of student data table associated tasks described in the mission preparation task implementation to establish an association between the tables. association between the editing table 3 set referential integrity 4. the problem analysis technology foundation. associated role. association between tables 3. association between editing table. enforce referential integrity theoretical basis: a relational database relational database. database protection training 1 student information database project summary thinking exercises 1 Item 2 queries student enrollment database tasks 2.1 Wizard check student elective database tasks described in task preparation tasks simple query. crosstab query. 4. lookup not Find Duplicates Query match query 5. problem analysis technology foundation. crosstab query. Duplicates Query to Find Unmatched Query theoretical foundation: set operation 1. intersection. difference operation 2 Cartesian produ.…