Database Design – A Practical Focus: Learn to design databases, from the conceptual model to the relational, using this practical guide and its examples. ... design and SQL for beginners and dummies)

by Sergio Garrido Barrientos, Donald Duffy III (Translator)

Database design is a critical and most important topic when it comes to the creation of software applications.Beginning with rules that are clear, well-explained and consistently accompanied by examples, you can learn to design databases in an easy and quick fashion.Learn to move from a simple description, or requirements, onto a conceptual model, alsocalled the entity relationship, and ultimately transform it into a relational model, which wewill utilise for an application.By following the norms offered in this book, you will be able to bring about quality designsfree of errors.The author is a Senior Computer Science Engineer with vast professional experience.Translated from the Spanish by Donald Duffy IIITable of Contents--------------------------------------------What is data modelling?The entity relationship modelEntitiesAttributesRelationshipsTypes of entitiesKey selectionRelationshipsOther relationship typesCardinalitiesRelationships with attributesInheritance relationships (ISA)Other notationsTransforming the Entity-Relationship into the Relational ModelImportant concepts for the Relational ModelTransformation of 1-to-1 relationshipsTransformation of 1-to-N relationshipsTransformation of N-to-M relationshipsTransformation of other types of relationshipsCase studyTo conclude…

40 pages, Kindle Edition

Published June 3, 2016

Reviews

[Bill Pierson · Rating 2 out of 5]

Summary with Typos

At best, this is a review of a few primary topics associated with the development of a relational database. The reader would be better served by looking at a summary table of definitions used in database design.