dbTalk Databases Forums  

Knowledgeable yet simple book for database modelling or database design

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Knowledgeable yet simple book for database modelling or database design in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
vicky
 
Posts: n/a

Default Knowledgeable yet simple book for database modelling or database design - 08-16-2007 , 10:18 AM






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


Reply With Quote
  #2  
Old   
David Portas
 
Posts: n/a

Default Re: Knowledgeable yet simple book for database modelling or database design - 08-16-2007 , 03:53 PM






"vicky" <vikas.patil (AT) capgemini (DOT) com> wrote

Quote:
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-Essen.../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-Mo.../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-Is.../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/m...S,SQL.90).aspx
--




Reply With Quote
  #3  
Old   
Alex Kuznetsov
 
Posts: n/a

Default Re: Knowledgeable yet simple book for database modelling or database design - 08-16-2007 , 04:04 PM



On Aug 16, 10:18 am, vicky <vikas.pa... (AT) capgemini (DOT) com> wrote:
Quote:
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
Search for Louis Davidson's books on database design.

Alex Kuznetsov, SQL Server MVP
http://sqlserver-tips.blogspot.com/



Reply With Quote
  #4  
Old   
vicky
 
Posts: n/a

Default Re: Knowledgeable yet simple book for database modelling or database design - 09-07-2007 , 05:55 AM



On Aug 17, 2:04 am, Alex Kuznetsov <AK_TIREDOFS... (AT) hotmail (DOT) COM> wrote:
Quote:
On Aug 16, 10:18 am, vicky <vikas.pa... (AT) capgemini (DOT) com> wrote:

Hi All,
Can u please suggest me some books for relationaldatabasedesignor
databasemodelling(Knowledgeableyetsimple) i.e. from which we could
learndatabaserelationships(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 aboutdatabase
design....Coz I thinkdatabasedesignis the crucial part ofdatabase
and we must know thedesignpart very first before starting up with
databases.....

Thanks and very grateful to all of you....

Vikas

Search for Louis Davidson's books ondatabasedesign.

Alex Kuznetsov, SQL Server MVPhttp://sqlserver-tips.blogspot.com/
David and Alex Thank you very much....



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.