Re: Database design

Angus Mann wrote: > Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I > figure the folks here will be well versed in the questions I raise. Please feel free to contact me > off the list if appropriate. > > I need some assistance with database design for a project I'm coding in PHP. I'm > willing to pay for the advice, since I think it will be a bit complex. I plan to use MySQLi > > If anybody feels they can assist, or can point elsewhere please feel free to contact me off > list, or reply to the list if you think appropriate. > Best tip I can give is to model out all your data first (using UML or suchlike) then figure out the tables to hold it from that; your database should not dictate the model of the data; also if you design to a model then your codebase need never change when it becomes time to change to a different RDMBS or even a completely different way of persisting your data :) regards!