Re: Database design
Date: Mon, 10 Mar 2003 13:59:58 +0000 (UTC)
"john" <nospam_at_nospam.com> wrote in message
> I am creating a database for a web application. The idea for the
> is for a company administrator to be able to log into the site and
> staff to a project which will be a clinical trial at a particular
> Staff will be able to log in and update the status of the project they are
> working on and clients will be able to log in and book a member of staff.
> Administrators will be able to add / edit / delete - staff / clients /
> clinical trials.
> Here is my database diagram:
> My problem is each different clinical trail will need to have different
> collected for it. How could I handle this in the database model? The
> administrator would like to be able to edit the data collected for each
> trial via the site...
> Any other comments on my database model would be appreciated as this is my
> weakest area of web development by far!
Maybe you might find this model useful to look at as well:
HTH Received on Mon Mar 10 2003 - 14:59:58 CET