Mastering Database Design

Description

This text provides a practical guide to designing and building a simple database. It provides step-by-step instructions to enable the reader to analyze a current working system and design a relational database to support that system, using techniques such as data flow diagrams, entity relationship diagrams and normalization. In addition, clear instructions show the reader how to use the basic and most useful features of Microsoft Access (the most commonly used system) to complete the new working system.


Contents:

Introduction Why Design Defining the Boundaries of the New System How Information is Passed Around Entity-Relationship Modelling Normalisation New System Requirements Data Dictionary Designing Queries Building Screens and Reports Testing Documentation Setting up the Data Housekeeping