Database theory. application and development(Chinese Edition)

Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Publisher: Publishing House of Electronics Industry Katherine Hung database theory. application and development of the departure from the practical and advanced. comprehensive introduction to the basic theory of computer networks and network application skills. The book has seven chapters. the main contents include: Database overview. data model. relational database theory. the basis of the database design. sql server graphics operation and sql language. visual basic database programming. address book management system design and implementation. The book provides supporting electronic courseware. Database theory. application and development of colleges and universities as database applications related course materials. and related engineering and technical personnel to learn reference. Contents: Chapter 1 Overview of a Database 1.1 Database Overview 1.2 1.2.3 1.2.1 1.2.2 file system of labor management phase stage database system database development history stage 1.3 database system 1.4 three mode structure of the database system extended reading exercises Chapter data model 2.1 2.2 logical model of the conceptual model 2.2.1 hierarchical data model 2.2.2 mesh data model 2.2.3 Relational Data Model 2.2.4 2.3 internal model of object-oriented data model hierarchical data model 2.3.1 2.3.2 mesh collection and operations of the data model 2.3.3 relational data model 2.4 external model extended reading exercises Chapter 3 3.1 relational schema of relational database theory Definition 3.2 the relationship set operations 3.2.1 3.2.2 set difference operation 3.2.3 set intersection operation 3.2. integrity 3.4.1 Data collection division operations 3.2.5 Cartesian product operation 3.3 the relationship between basic operations 3.3.1 Select an operator 3.3.2 projection operation 3.3.3 concatenation operator 3.4 relationship depends 3.4.2 relational schema paradigm Exercises Chapter 4 Database design basics 4.1 structural design concept 4.1.1 design each partial er Figure 4.1.2 merge sub-er drawing design globally preliminary ER Figure 4.1.3 eliminate unnecessary redundancy. basic design er Figure 4.2 The logical structure design 4.2. 1 er model into a relational model 4.2.2 data model optimization 4.2.3 Out-of-design mode 4.3 physical structure design 4.3.1 4.3.2 evaluation of the physical structure to determine the physical structure of the database in 4.4 database 4.5 pd database design 4.5. 4.5.2 Reverse Engineering Forward Engineering 4.6 the Visio database design 4.6.1 4.6.2 create a physical model to create a logical model 4.6.3 Design 4.7.1 positive import data into sql server database using Rational Rose visio4.7 Engineering 4.7.2 reverse engineer exercises Chapter 5 sql server graphics operations and the SQL language 5.1 sql server's graphical interface 5.1.1 connection sql server5.1.2 database to create and delete tables 5.1.3 to create. modify. and delete 5.1. establish relationships between tables 5.1.5 to add data and query 5.1.6 check constraints 5.1.7 The use of stored procedures 5.1.8 view 5.1.9 triggers 5.1.10 5.1.11 separation of the account and permissions management and Additional database 5.1.12 database backup and restore 5.1.13 DTS Import and Export Wizard 5.2 sql language 5.2.1 DDL database management 5.2.2 ddl table management 5.2.3 DML Data Management 5.2.4 the DQL data query 5.2.5 DCL Data Control 5.3 t-sql programming 5.3.1 t-sql Notes 5.3.2 Expression 5.3.3 batch case expression of statements 5.3.5 5.3.6 with script 5.3.4 Process control to create a user-defined function cursor 5.3.7 5.3.8 Affairs 5.3.9 5.3.10 create view Exercises Chapter 6 visual basic database programming 6.1 Visual Basic Programming Fundamentals 6.1.1 Integrated Development Environment 6.1.2 6.1.3 Forms object-oriented object programming ideas 6.1.4 data type to create a stored procedure 6.4.4 Data and the basic syntax of D.…