Professional Web Applications Themes

Need a Book about Database Design - Microsoft SQL / MS SQL Server

Hi SQL Gurus, I need a Book about how to design a good database. I never have any course on Database before. Now I realize just using My intuitive feeling and read the BOL to design a database is not enough. What kind of Book should I read ? Is that a 'neutral' Book on database Concept (Not Dedecated to specific RDBMS ) OR Is there any Book on SQL Server about Database Design ? Thanks a lot, Krist *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default Need a Book about Database Design

    Hi SQL Gurus,

    I need a Book about how to design a good database.
    I never have any course on Database before. Now I realize just using My
    intuitive feeling and read the BOL to design a database is not enough.

    What kind of Book should I read ?

    Is that a 'neutral' Book on database Concept (Not Dedecated to specific
    RDBMS )
    OR
    Is there any Book on SQL Server about Database Design ?

    Thanks a lot,
    Krist



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Krist Guest

  2. #2

    Default Re: Need a Book about Database Design

    Hello !

    http://www.amazon.de/exec/obidos/ASIN/0735619603/sqlserver-21

    Or

    http://www.amazon.de/exec/obidos/ASIN/1861004761/sqlserver-21

    (Wrox press books are very good)

    These are sql server specific books, but also capable for other RDBMS (eg.
    Oracle)

    Jens S▄▀meyer.


    Jens Guest

  3. #3

    Default Re: Need a Book about Database Design

    Krist,
     


    These are good introductory books:

    Database Design for Mere Mortals
    Michael J. Hernandez
    Addison Wesley, 1997
    ISBN 0-201-69471-9

    Mastering Data Modeling
    John Carlis and Joseph Maguire
    Addison-Wesley, 2001
    ISBN 0-201-7045-X

    These two are good followup reading:

    Data Modeling Essentials, 2nd Edition
    Graeme C. Simsion
    The Coriolis Group, 2001
    ISBN 1-57610-872-4

    Informational Modeling and Relational Databases
    Terry Halpin
    Morgan Kaufmann, 2001
    ISBN 1-55860-672-6

    Linda

    lindawie Guest

  4. #4

    Default Re: Need a Book about Database Design

    Pick up Terry Halpin's ORM book. The method is supported by tools
    (Visio) and has a lot of advantages over ER and UML modeling.

    --CELKO--
    ===========================
    Please post DDL, so that people do not have to guess what the keys,
    constraints, Declarative Referential Integrity, datatypes, etc. in your
    schema are.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Joe Guest

  5. #5

    Default Re: Need a Book about Database Design

    Hi Joe,

    Where can I find information about advantages of ORM compared to ER &
    UML ?

    Thanks,
    Krist



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Krist Guest

  6. #6

    Default Re: Need a Book about Database Design

    Try the "Journal of Conceptual Modeling" website where Terry Halpin did
    a series of articles.

    --CELKO--
    ===========================
    Please post DDL, so that people do not have to guess what the keys,
    constraints, Declarative Referential Integrity, datatypes, etc. in your
    schema are.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Joe Guest

Similar Threads

  1. In Design book won't export bleeds to pdf
    By Dave_Pegg@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 13
    Last Post: September 19th, 06:58 PM
  2. OT - Book on Newspaper or Magazine Design
    By Arnold_German@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 4
    Last Post: July 19th, 12:01 AM
  3. Flash Web Design Book
    By kashou88 webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 2
    Last Post: January 10th, 09:05 AM
  4. coffee table book - interior design ?
    By dillontdaniel webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 1
    Last Post: September 22nd, 12:42 PM
  5. best book on design patterns?
    By lawrence in forum PHP Development
    Replies: 1
    Last Post: July 4th, 11:49 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139