Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

The Purpose of This Book

In general terms, there are three phases to the overall database-development process.

1. Logical design: The first phase involves determining and defining tables and their fields, establishing primary and foreign keys, establishing table relationships, and determining and establishing the various levels of data integrity.

2. Physical implementation: The second phase entails creating the tables, establishing key fields and table relationships, and using the proper tools to implement the various levels of data integrity.

3. Application development: The third phase involves creating an application that allows a single user or group of users to interact with the data stored in the database. The application-development phase ...