Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Posts
    9

    Relational Database Design Patterns

    Hi,
    Does anyone know of any work or research that have been carried out in documenting design patterns for ER designs?

    Thanks

  2. #2
    Join Date
    Apr 2004
    Location
    Toronto, Canada
    Posts
    249
    There are two books that come to mind.

    One is by David Hay (or is it Hays?) and the other is by Len Silverstone.

    Look them up in Amazon.com

  3. #3
    Join Date
    May 2004
    Posts
    9
    Thanks.
    I found the first book but not the second. Any idea of what the title is?

  4. #4
    Join Date
    Apr 2004
    Location
    Toronto, Canada
    Posts
    249
    Here are the links to the books:

    1. David Hay: http://www.amazon.com/exec/obidos/tg...glance&s=books

    2. Len Silverston Vol 1: http://www.amazon.com/exec/obidos/tg...glance&s=books

    3. Len Silverston, vol 2: http://www.amazon.com/exec/obidos/tg...e&s=books&st=*

    I personally have David Hay's book. It is very good. It does not teach much to an experienced data modeller, but is a good reference book.

    I have heard about the other book, but have not seen them.

    Hope that helps.

  5. #5
    Join Date
    Apr 2003
    Location
    London, England
    Posts
    42
    I have the two books by Hay and Silverston and they cover somewhat similar ground in a similar manner. which Silverston describes as '...universal data models for common organizational functions' For example, they both have chapters devoted to Accounting.
    This is a bottom-up approach so I have adopted a top-down approach by aiming to create a Generic Data Model for the Real World and the applying it to a series of specific areas, such as Entertainment and Insurance.

    You might find it interesting to have a look at my Models :-
    http://www.databaseanswers.com/data_...rld_series.htm

    Is there a specific application area that you are involved in ?

    Barry Williams
    Principal Consultant
    Database Answers

  6. #6
    Join Date
    May 2004
    Posts
    9

    Patterns for questionnaires

    Hi,
    I went through the data models that are available in your site. quite interesting.
    Do you know of a model that would allow different type of questions e.g. MCQ, open entries - string or number, ranking type of questions (e.g. select the first three choices)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •