Page 1 of 1

Database design

Posted: Fri Jul 15, 2011 5:28 am
by sanderson1529
Hi

I am struggling to understand the best way to design a database, It will need multiple users and each user will have a food & fitness diary updated everyday. whats the most sensible way to approach this?

Cheers

Re: Database design

Posted: Fri Jul 15, 2011 11:44 am
by califdon
There is a standard approach to designing a relational database. It is a formal technique and should be followed for anything beyond the simplest of databases, or risk not being able to create a usable database. This standard approach is well documented. Here is an admittedly rather lengthy explanation written by one of the top database authors, Paul Litwin: http://www.deeptraining.com/litwin/dbde ... esign.aspx. Here's another good one: http://www.edm2.com/0612/msql7.html. Another one for concepts: http://en.wikibooks.org/wiki/Relational ... c_Concepts. You can look up others by searching for database design.

Re: Database design

Posted: Mon Jul 18, 2011 4:51 pm
by McInfo
markfinn wrote:Database design is a database of detailed data model in the process. [...] Entirely attributable to the data model contains detailed attributes for each entity.
:dubious: