Conceptual data modeling and database design : a fully algorithmic approach. Volume 1, The shortest advisable path /

Conceptual data modeling and database design : a fully algorithmic approach. Volume 1, The shortest advisable path /

Saved in:

Bibliographic Details
Author / Creator:	Mancas, Christian, author.
Imprint:	Oakville, ON : Apple Academic Press ; Boca Raton, FL : CRC Press, Taylor and Francis Group, [2015] [Place of publication not identified] : CRC Press LLC, 2015. ©2016
Description:	1 online resource
Language:	English
Subject:	Database design. Computer algorithms. Conceptual structures (Information theory) Algorithms Computer algorithms. Conceptual structures (Information theory) Database design.
Format:	E-Resource Book
URL for this record:	http://pi.lib.uchicago.edu/1001/cat/bib/13539503

Hidden Bibliographic Details
Varying Form of Title:	Shortest advisable path
ISBN:	9781498728447 1498728448 9781771881241
Notes:	Includes bibliographical references. Online resource; title from PDF title page (EBSCO, viewed September 25, 2015).
Summary:	This title provides both beginners and experts with a completely algorithmic approach to data analysis and conceptual modelling, 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. This new book aims to provide 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.
Other form:	Print version: Mancas, Christian. Conceptual data modeling and database design : Volume 1, The shortest advisable path 9781771881241

Table of Contents:

Data, information and knowledge in the computer era
The quest for data adequacy and simplicity: the entity-relationship data model (E-RDM)
The quest for data independence, minimal plausibility, and formalization: the relational data model (RDM)
Relational schemas implementation and reverse engineering
Conclusion.