Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database design

Re: Database design

From: Undercover Elephant <9rowzn01i001_at_9rowzn01i001.com>
Date: Mon, 10 Mar 2003 13:59:58 +0000 (UTC)
Message-ID: <b4i5ot$t8r$1@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 - 07:59:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US