Deschide articolul original într-un tab nou Schimbarea acestei opțiuni se aplică imediat și reîncarcă pagina.
LECTURA
← Înapoi la Urmăritori

Case studies, SQL advice, theory explained on Database Design Book

kb.databasedesignbook.com/index.xml
Vizitează site-ul

Cel mai recent articol

Ultima verificare

Urmăritori 0 urmăritori
Articole: 13

  1. Historized links, pt. 1 (M:N case)

    (Case studies, SQL advice, theory explained on Database Design Book)

    A common problem in business-oriented database design is how to store the history of data as it changes.

  2. Historized links: introduction

    (Case studies, SQL advice, theory explained on Database Design Book)

    A common problem in business-oriented database design is how to store the history of data as it changes.

  3. 5NF and Database Design

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com, (~3900 words) One of the goals of this publication is to deconstruct the traditional ways of teaching basic topics in relational databases.

  4. A modern guide to SQL JOINs

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com, (~8800 words) There are many SQL JOINs guides and tutorials, but this one takes a very different approach.

  5. State park database: a Minimal Modeling approach (pt. III-b)

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com.

  6. ERD diagrams as specification tool (pt. III)

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com.

  7. ERD diagrams, pt. II: physical diagrams

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com.

  8. ERD diagrams, pt. I: many-to-many relationships

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com.

  9. Systematic design of multi-join GROUP BY queries

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com, ~5400 words.

  10. Foreign Keys

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin <squadette@gmail.com> (Word count: 2900).

  11. Historized attributes: systematic table design

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com.

  12. Many yes/no attributes: table design study

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com.

  13. Database Design for Google Calendar: a tutorial

    (Case studies, SQL advice, theory explained on Database Design Book)

    Author: Alexey Makhotkin squadette@gmail.com.