Reply to Re: Knowledgeable yet simple book for database modelling or database design

Your name:

Reply:


Posted by David Portas on 08/16/07 20:53

"vicky" <vikas.patil@capgemini.com> wrote in message
news:1187277493.878157.213600@j4g2000prf.googlegroups.com...
> Hi All,
> Can u please suggest me some books for relational database design or
> database modelling(Knowledgeable yet simple) i.e. from which we could
> learn database relationships(one to many,many to one
> etc.....),building ER diagrams,proper usage of ER diagrams in our
> database(Primary key foreign key relations),designing small
> modules,relating tables and everything that relates about database
> design....Coz I think database design is the crucial part of database
> and we must know the design part very first before starting up with
> databases.....
>
> Thanks and very grateful to all of you....
>
> Vikas
>

The following is one good book that deals with data modelling specifically
from the ER perspective:
http://www.amazon.com/Modeling-Essentials-Third-Graeme-Simsion/dp/0126445516

However, the ER perspective is not the only way or necessarily the best way
to design a database. See also:
http://www.amazon.com/Information-Modeling-Relational-Databases-Conceptual/dp/1558606726

Another book I highly recommend is the following. It's not a comprehensive
reference or tutorial but it does give excellent analysis and guidance on
some of the key topics.
http://www.amazon.co.uk/Practical-Issues-Database-Management-Fabian/dp/0201485559

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация