Re: Database design.

[Drsolly <drsollyp () drsolly com>]

On Mon, 5 Jun 2006, Blue Boar wrote:

> Drsolly wrote:
> > Suppose you were asked to design a database to store the medical records 
> > of everyone in the UK (about 60 million people), with adequate security, 
> > and giving access to those medical staff who need access to those records.
> >
> > As a first stab, what would you guess would be the cost of such a thing, 
> > and what (roughly, in one paragraph) would be your design?
>
> Is that how you bid your projects? :)

No, but it's how I decide how much effort I should put into bidding for a 
contract.
 
> > I ask, because a project like this is underway in the UK, expected to cost
> > some $40 billion, and I've just written to my MP suggesting that a
> > *massively* lower figure would be more appropriate (including my
> > one-paragraph design), and asking her to raise this as a Parliamentary
> > Question.
>
> I'll do it for a billion.  But that doesn't include importing/converting 
> existing records

A few simple perl scripts.

> , training people,

Not needed if you design it right

> providing network links, 

I'd use the internet. So, links already in place.

> replacing 
> all the equipment at the hospital ends,

They use PCs already, no need to change.

> liability insurance, or

You would already have that.
 
> operating and maintaining it.
 
Clent does all that.

_______________________________________________
Fun and Misc security discussion for OT posts.
https://linuxbox.org/cgi-bin/mailman/listinfo/funsec
Note: funsec is a public and open mailing list.