 | Kroenke D.M. Database processing: fundamentals, design, and implementation / D.V.Kroenke, D.J.Auer. - 12th ed. - Boston et al.: Pearson, 2012. - xxvii, 612 p.: ill. - Ind.: p.604-612. - ISBN-10 0-13-214537-5; ISBN-13 978-0-13-214537-4
|
Preface ........................................................ xv
PART I GETTING STARTED .......................................... 1
Chapter 1 Introduction ......................................... 2
Chapter 2 Introduction to Structured Query Language ........... 31
PART 2 DATABASE DESIGN ........................................ 99
Chapter 3 The Relational Model and Normalization ............. 100
Chapter 4 Database Design Using Normalization ................ 137
Chapter 5 Data Modeling with the Entity-Relationship Model ... 155
Chapter 6 Transforming Data Models into Database Designs ..... 203
PART 3 DATABASE IMPLEMENTATION ............................... 245
Chapter 7 SQL for Database Construction and Application
Processing ......................................... 246
Chapter 8 Database Redesign .................................. 313
PART 4 MULTIUSER DATABASE PROCESSING ......................... 337
Chapter 9 Managing Multiuser Databases ....................... 338
Chapter 10 Managing Databases with SQL Server 2008 R2 ......... 373
ONLINE CHAPTER: SEE PAGE 447 FOR INSTRUCTIONS
Chapter 10A Managing Databases with Oracle Database 11g ..... 10A-1
ONLINE CHAPTER: SEE PAGE 448 FOR INSTRUCTIONS
Chapter 10B Managing Databases with MySQL 5.1 ............... 10B-1
PART 5 DATABASE ACCESS STANDARDS ............................. 449
Chapter 11 The Web Server Environment ......................... 449
Chapter 12 Database Processing with XML ....................... 509
Chapter 13 Database Processing for Business Intelligence
Systems ............................................ 549
ONLINE APPENDICES: SEE PAGE 590 FOR INSTRUCTIONS
Appendix A Getting Started with Microsoft Access 2010 ......... A-l
Appendix В Getting Started with Systems Analysis and Design ... B-l
Appendix С E-R Diagrams and the IDEF1X Standard ............... C-l
Appendix D E-R Diagrams and the UML Standard .................. D-l
Appendix E Getting Started with the MySQL Workbench Database
Design Tools ....................................... E-l
Appendix F Getting Started with the Microsoft Visio 2010 ...... F-l
Appendix G The Semantic Object Model .......................... G-l
Appendix H Data Structures for Database Processing ............ H-l
Appendix I Getting Started with Web Servers, PHP and the
Eclipse PDT ........................................ I-1
|
|
