Re: mysql update/replace syntax

From: CJ Llewellyn (invalid_at_example.con)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 09:28:46 +0100

"Gordon Burditt" <gordonb.pilrf@burditt.org> wrote in message
news:cgub33$6lb@library1.airnews.net...
> >> > You are approching this from the wrong angle. You should be quering
the
> >> > customer sales records and producing summary information from that.
>
> This is a hospital kitchen. Recording Personally Identifiable
> Information about a patient in a database makes that database legally
> unusable for the purpose intended for it (what kind of food they
> should order and how much they should keep on hand), and that's why
> your predecessor is in jail now: violating HIPAA requirements.
-snip-

Nobody has said that this is a hospital kitchen. HIPAA requirements do not
apply outside of the USA. HIPAA only applies to hospital information.
Nothing in the example mandates that personal information is to be kept.

> Keeping this kind of marketing information around can kill your business
> if it gets out that you're keeping it, say, because someone managed
> to steal it.

Every single in the company in the world keeps this type of information.
They have to, otherwise they have great difficulty in managing their
accounts, stock order processes, producing statutory information i.e. tax
returns and providing good customer service.

Relevant Pages

  • Re: Designing a hospital visit database
    ... Thinking about a database is sometimes the trickiest part. ... doctor themselves is good, since a doctor may wish to keep information ... Patient Visit, but would be there to link to if necessary. ... way of filtering various types of information for forms and reports. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Designing a hospital visit database
    ... There are lots of twists and turns to a database of this sort. ... Patient Visit, but would be there to link to if necessary. ... way of filtering various types of information for forms and reports. ... progress note before by creating a single memo field that store daily ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Table problem
    ... isn't the road to normalization and the whole process really has nothing to ... It is how you would proceed with any relational database. ... to a particular patient, for a particular visit, you could make some ... VISITS (VisitID, VistDate, patientID) etc -- all about visit, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Basic Database Design
    ... the Patient appears and I open my Database on the ... Each Insurance Company furnishes all the products, ... note that you can dispense with the CoServID primary key field, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How do I link AND APPEND the linked data
    ... the database would have been to fully replace the hard copy data. ... we still maintain the old-fashioned patient charts and want to use ... field/column in excel. ... your append query. ...
    (microsoft.public.access.externaldata)