A new, easy-to-follow course of instruction in relational database design and development. The text guides students through the vitally important steps of conceptual schema design, normalisation and relational schema definition, through to implementation with Microsoft Access. Developed for students in Years 10 to 12, it provides students with detailed database examples, each following the software development cycle, supported by conceptual schema diagrams, dataflow diagrams and Windows screenshots taken from Microsoft Access 2007. The text can be both used as a day-to-day workbook and as a reference manual. Each text is packaged with a CD containing a fully bookmarked PDF of the student textbook, graphics and data for the examples and exercises.

Table of Contents

Section 1 Information systems 1 Data and databases 2 Solving problems 3 Data flow diagrams 4 Conceptual schema basics Section 2 Putting it together 5 Access elements 6 Little black book (Database example 1) 7 Field properties 8 Access queries 9 Claudio's autos (Database example 2) Section 3 Databases with multiple tables 10 More on relational schemas 11 More Access queries 12 Spaced out (Database example 3) 13 Report design 14 May I take your order? (Database example 4) Section 4 Developing applications 15 Macros and events 16 Sal's seaside nursery (Database example 5) 17 EZ-DVD hire (Database example 6)

About the Author

Graeme Summers is a teacher of Information Processing and Technology (IPT) at Coolum State High School, Queensland. He has been honoured with the prestigious QSITE Teacher Award for Leadership in Educational Computing (Queensland Society for Information Technology in Education). Graeme is currently an ACCE Professional Associate (Australian Council for Computers in Education). He has been actively involved in computer education and software development in Australia since 1980.