Six-Step Relational Database Design(tm): A Non-Theoretical Approach to Relational Database Design and Development

Front Cover
Fidel A Captain, 2012 - Computers - 158 pages

This edition WILL BE DISCONTINUED December 1 2013. There is a Second Edition of this book out that contains a new chapter on implementation.

This book is dedicated to structuring and simplifying the database design process, outlining a simple but reliable six-step process for accurately modelling user data, leading to a sturdy and reliable relational database.

It starts with a statement of the problem by the client and goes through the six steps necessary to create a reliable and accurate data model of the client's business requirements.

Three case studies are used throughout the book to guide the user through the six steps, illustrating the six-step relational database design technique. At each stage the technique is explained, in detail, using the case studies as examples of how to implement the process for that stage of the technique.

This book should be used as a handbook for students and professionals in the software-development field. Students can use it as a technique for quickly developing relational databases for their applications, and professionals can use it as a technique for developing sturdy, reliable, and accurate relational database models for their software applications.

 

Contents

Relational Databases and Relational Database Design
1
The Six Steps Step 1
13
The Six Steps Step 2
31
The Six Steps Step 3
41
The Six Steps Step 4
53
The Six Steps Step 5
63
The Six Steps Step 6
77
Case Studies
119
References
135
Index
137
Copyright

Other editions - View all

Common terms and phrases

About the author (2012)

Fidel A. Captain has over 15 years experience designing, implementing, and maintaining databases, and over 10 years' experience as a lecturer. He has worked as a systems analyst/engineer with the Ministry of Finance in Guyana, as a computer studies lecturer at the H. Lavity Stoutt Community College in the British Virgin Islands, and as a free-lance consultant. Captain has developed several database-based applications that include an online bill payment system, a logistics and cargo tracking system, a student tracking and evaluation system, and a freight and duty calculation system. Captain is a Queen's College Guyana Scholar, who received his Bachelors of Engineering Degree from UMIST in Computer Systems Engineering, and a Master's in Information Technology from Capella University. He is also a certified MySQL developer and administrator.

Bibliographic information