| Introduction |
Database Design and Programming, second edition, expands upon John Carter's excellent first edition. Suitable for mainstream computer science students as well as those coming from other disciplines, this is a comprehensive and accessible introductory text covering the development of database applications. Each chapter contains many useful examples and exercises. The second edition contains three new chapters covering the issue of getting your database onto the Internet. The book has its own website, where readers can discuss database design and programming issues. |
| About the book |
The book explains all stages of database development, starting with a comprehensive database application systems development life cycle model, which clearly defines the areas of focus required for any new database developer. Database design using entity modelling and normalization are described in a clear and comprehensible manner. Covering inplementation in Access, SQL, Access forms, macros, modules and report writer, the text also addresses Visual Basic database programming using Data Control, DAO, ADO and Access modules. The second edition contains a new set of chapters on Active Server Pages with HTML and VBScript. The new material explains how to get your database onto the Internet and the benefits offered by web-based database applications. ASP is put into context with a discussion of web terminology and client and server side scripting in VBScript. Client-side scripting examples in Javascript are also included. HTML and ASP are given separate chapters, with an array of examples, screen shots and detailed code descriptions. |
| Key features |
| Table of contents |
1. How to develop a database application 2. Entity modelling and normalization 3. Access database design 4. Access query design using Query Design view 5. Access query design using SQL ' DDL and DML statements 6.Access query design using SQL ' the SELECT statement ' single tables and joins 7. Access query design using SQL ' the SELECT statement ' further features 8. Access Forms, Macros and Reports 9. Visual Basic database programming using the Data Control 10. Visual Basic database programming using Data Access Objects (DAO) 11. Visual Basic database programming using ActiveX Data Objects (ADO) 12. Visual Basic database programming using Access Modules 13. Introduction to ASP 14. HTML 15. ASP Appendix 1 Example databases Appendix 2 Differences in database programming commands in VB versions Appendix 3 HTML summary Glossary References Books Websites News Groups Help files Index |


