Re: Database design
Date: Mon, 10 Mar 2003 13:59:58 +0000 (UTC)
Message-ID: <b4i5ot$t8r$1_at_venus.btinternet.com>
"john" <nospam_at_nospam.com> wrote in message
news:ZN0ba.11746$Vx2.904990_at_wards...
> Hi,
>
> I am creating a database for a web application. The idea for the
application
> is for a company administrator to be able to log into the site and
allocate
> staff to a project which will be a clinical trial at a particular
practice.
> 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:
>
> http://www.mania.plus.com
>
> My problem is each different clinical trail will need to have different
data
> 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:
http://www.databaseanswers.com/data_models/clinical_trials/index.htm
HTH Received on Mon Mar 10 2003 - 14:59:58 CET