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.
