A Sane Approach to Database Design

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

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.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.

Click button below to register and download Ebook
Privacy Policy | Contact | DMCA