Database fundamentals

Overview

In this textbook I cover topics relating to general database design and implementation with examples of typical solutions using Microsoft Access database. Briefly the contents are as follows.
I introduce database systems and describe functions that are typically supported by database management systems. A brief discussion of database types and design issues such as data dependence, redundancy and anomalies is also provided. For modelling I use Entity Relationship Diagrams (ERD) which suits relational databases. I use Microsoft Access database and provide enough information to enable the reader to begin using the database. Database design includes database normalisation and also the methods used in defining tables, attributes and relationships in database design.
I also provide a brief overview of project management to include general aspects of planning and organising database projects. Here requirements specification is described in a general sense.

Read More