Health Data Clinic - Book 5: Model to Tables: Relational Mapping

The diagram is finished. Now it has to become tables. This book teaches the relational model first, so you know what you are mapping onto: rows and columns holding atomic values, primary keys, foreign keys and the referential integrity they enforce, and domains that set what a column is allowed to contain. Then it works through the mapping rules one at a time, in order. Strong entities become tables, with a clear treatment of composite and surrogate keys. Weak entities take part of their identity from a parent. The three relationship shapes each get their own chapter, 1:1, 1:M and M:N, so you know exactly where a foreign key goes and when a separate table is required. Integrity is then shown in action, refusing a bad row as it is inserted rather than being described in theory. EER hierarchies get their own mapping chapter, and the book ends with a validation pass over the finished schema.

Twenty-five A4 pages, in full color. Written in short sentences and plain English, for readers whose first language is not English and clearer for everyone else because of it.

Every query in this book was run against a live database before the page was printed, so the result you read is the result you get. Instant PDF download. By M.R. Sterling.