A Sane Approach to Database Design

4.11 - 1251 ratings - Source

Learn how to create an accurate, efficient, maintainable database that can be implemented on any modern platform. There's more to building databases than just knowing SQL. Database design is the art of transforming real-world requirements into an information model that can be implemented with a relational database. Which particular database product you use is not important. The concepts are the same. This book presents a step-by-step guide to building a database. Topics include: Requirements gathering * Introduction to SQL * The model sequence * Entities, relationships, and attributes * Keys and indexes * Entity-Relationship Diagrams * Naming * Normalization * Implementation * Breaking the rulesLeta#39;s concede one point to the inventors of the VIN: There is a valid reason to
embed a manufacturer id in a sequence ... The goal is to have a unique identifier
for every vehicle made anywhere in the world. ... That way each company has its
own set or pool of numbers to allocate. ... Youa#39;re free to insist that it is by a
technical definition, but it is so useful that ita#39;s forgivable. ... The old system I
inherited had an attribute they called aquot;symbol codeaquot;, which was a one-character
attribute thatanbsp;...

Title

:

A Sane Approach to Database Design

Author

:

Mark Johansen

Publisher

:

Lulu.com - 2008

ISBN-13

:

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.