Six-Step Relational Database DesignTM bridges the gaps between database theory, database modeling, and database implementation by outlining a simple but reliable six-step process for accurately modeling user data on a Crow's Foot Relational Model Diagram, and then demonstrating how to implement this model on any relational database management system.
The second edition contains a new chapter on implementation that goes through the steps necessary to implement each of the case studies on a relational database management system, clearly relating the design to implementation and database theory. In addition, questions are also included at the end of each of the six steps and one of the previous case studies has been replaced, making the case study selection more diverse.
Six-Step Relational Database DesignTM uses three case studies and starts with a statement of the problem by the client and then goes through the six steps necessary to create a reliable and accurate data model of the client's business requirements. This model can then be used to implement the database on any relational database management system.
Six-Step Relational Database DesignTM should be used as a handbook for students and professionals in the software-development field. The technique described in this book can be used by students for quickly developing relational databases for their applications, and by professionals for developing sturdy, reliable, and accurate relational database models for their software applications.
About the Author: Fidel A. Captain has over 15 years of experience designing, implementing, and maintaining databases, and over 10 years of experience as a lecturer.
He has worked as a systems analyst and systems 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 freelance 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 the University of Manchester Institute of Science and Technology in Computer Systems Engineering, and a Master's in Information Technology from Capella University. He is also a certified MySQL developer and administrator.
