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
Database design
Moderator: General Moderators
Re: Database design
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
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.