Re: Database design

From: Undercover Elephant <>
Date: Mon, 10 Mar 2003 13:59:58 +0000 (UTC)
Message-ID: <b4i5ot$t8r$>

"john" <> wrote in message news:ZN0ba.11746$Vx2.904990_at_wards...
> Hi,
> 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

Original text of this message