CRC Press Conceptual Data Modeling and Database Design: A Fully Algorithmic Approach, Volume 1: The Shortest Advisable Path

This new book aims to provide to both beginners and experts with a completely algorithmic approach to data analysis and conceptual modeling, database design, implementation, and tuning, starting from vague and incomplete customer requests and ending with IBM DB/2, Oracle, MySQL, MS SQL Server, or Access based software applications. A rich panoply of solutions to actual useful data sub-universes (e.g. business, university, public and home library, geography, history, etc.) is provided, constituting a powerful library of examples. Four data models are presented and used: the graphical Entity-Relationship, the mathematical EMDM, the physical Relational, and the logical deterministic deductive Datalogones. For each one of them, best practice rules, algorithms, and the theory beneath are clearly separated. Four case studies, from a simple public library example, to a complex geographical study are fully presented, on all needed levels. Several dozens of real life exercises are proposed, out of which at least one per chapter is completely solved. Both major historical and up-to-date references are provided for each of the four data models considered. The book provides a library of useful solutions to real-life problems and provides valuable knowledge on data analysis and modeling, database design, implementation, and fine tuning. Review "What Christian Mancas wanted to do is to write the best possible book on real, pragmatic database design available, bar none. He suceeded. . . This book will find its way into the literature on database design and development. It has a good number of ideas that must be considered in any design task. It uses a sample-based approach and is thus easy to understand. It supports digestion due to nice exercises. And, finally it discusses in details also the result of a design in different DBMS languages. So, a reader can be sure that the book guides to the right track." ―Bernhard Thalheim, Department of Computer Science, Christian-Albrechts-University Kiel, Germany (from the Foreword) "Covers the classical data management topics that any computer professional should master. . . . This volume is a gentle yet rigorous and extensive introduction to the main topics in data management, with concrete examples on several popular database systems. There are lots of detailed examples, and each concept is covered in detail, and from several perspectives, using alternative definitions or notations where needed. The book ensures that no reader is left behind, and all potential questions are answered. . . . Best suited for the practitioner who wants to achieve a thorough understanding of the fundamental concepts in data management. . . . This volume is an important first step in understanding the complexities of data today." ―Dan Suciu, Professor, University of Washington, Seattle, USA (from the Foreword) "One of the biggest problems in nowadays applications is the management of data. Analyzing and structuring large amounts of data relies on understanding and being able to describe its properties and constraints. Professor Christian Mancas's exceptionally well-documented work, A Conceptual Data Modeling and Database Design, gives the basic insights of the database models and their importance as a foundation for the complex applications. This book guides the reader throughout real-life scenarios, providing essential software engineering advice. Indeed, by addressing some of the problems people usually encounter when designing a database, Professor Mancas pedagogically connects the end user's requirements to the notions of entities and relations between them. Meanwhile, the mathematical analysis and proofs sustain the theoretical background of the statements and provide a complete view of the possible algorithmic optimizations. The first volume, A Fully Algorithmic Approach: The Shortest Advisable Path, represents an important contribution in the learning process as it