Re: Knowledgeable yet simple book for database modelling or database design
- From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
- Date: Thu, 16 Aug 2007 21:53:35 +0100
"vicky" <vikas.patil@xxxxxxxxxxxxx> wrote in message
news:1187277493.878157.213600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
--
.
- References:
- Prev by Date: Re: SELECT a random 10 records from table....easy newbie question
- Next by Date: Re: Knowledgeable yet simple book for database modelling or database design
- Previous by thread: Knowledgeable yet simple book for database modelling or database design
- Next by thread: Re: Knowledgeable yet simple book for database modelling or database design
- Index(es):
Relevant Pages
|
