If someone can help me with this I will send over $30 bucks for your time on paypal. I'm stuck bigtime and need some help.

Feel free to reply here, or e-mail me spork1138@gmail.com

Consider the sample data on patients, providers and visits given in the table below:

VisitNo VisitDate PatNo PatAge PatCity PatZip ProvNo ProvSpecialty Diagnosis
V10020 1/13/2000 P1 35 DENVER 80217 D1 INTERNIST EAR INFECTION
V10020 1/13/2000 P1 35 DENVER 80217 D2 NURSE PRACTIONER INFLUENZA
V93030 1/20/2000 P3 17 ENGLEWOOD 80113 D2 OBGYN PREGNANCY
V82110 1/18/2000 P2 60 BOULDER 85932 D3 CARDIOLOGIST MURMUR
V34210 1/18/2000 P4 65 ENGLEWOOD 80113 D3 CARDIOLOGIST IRREGULAR BEAT

Create a set of normalized tables, upto BCNF.

Visit (VisitNo, PatNo*, ProvNo*, VisitDate, Diagnosis)
Pat (PatNo, PatAge, PatCity, PatZip)
Prov (ProvNo, ProvSpecialty)

thats what i have so far

30 bucks, wow, that'll buy me... umm... umm... arrr... umm... 3 golf balls. Sign me up

Oh dear

You'd know if you'd bothered to read through some threads on this forum that the "experts" here generously give their time and expertise for free. Offering money to do your work for you is an insult. Your lack of planning does not constitute someone else's emergency.

I would like to donate this money to charity: Amnesty International and Greenpeace!
First donate, then i'll help you!

You must be really desparate!

30 bucks, wow, that'll buy me... umm... umm... arrr... umm... 3 golf balls. Sign me up

Glad I don't play golf!

As a kid we used to go round the course collecting lost balls and selling them back to the golfers. Might be worth starting that up again...

I would like to donate this money to charity: Amnesty International and Greenpeace!
First donate, then i'll help you!

You must be really desparate!
Smells like student coursework to me. Surely anyone working in the healthcare sector wanting a database would employ/invest in something more substantial. I may be wrong :rolleyes: Actually, thinking about it this is not necessarily the case in the UK. Anything to do with healthcare seems to be done on a shoestring :eek:

just chipping in here -
this is a help forum -(also a slagging off forum as well)
if you want to pay someone to do this relative simple thing then go find a student or go to an evening course and let them use your d/base as a study case ..


Askign guys here to do this on payment raises all sorts of questions - and there has been a bad expereince of people saying they are going to pay and then bailing out..
so i don't think you are going to get much help on this one ..
regards

Oke, well here it is.
Visit (VisitNo, PatNo*, ProvNo*, VisitDate, Diagnosis)
Pat (PatNo, PatAge, PatCity, PatZip)
Prov (ProvNo, ProvSpecialty)

thats what i have so far

Now pay up!

You can buy many a perfectly good book on database design for much less than 30 bux

just chipping in here -
this is a help forum -(also a slagging off forum as well)


SHHHH!!!!!!! you'll ruin our secret

Has spork1138 done a runner ?

Has spork1138 done a runner ?
a runner?? what's that?

a runner?? what's that?

When you escape from jail you are said to be doing a runner. :)

Has spork1138 done a runner ?

Dave I imagine someone on another forum took up his generous offer and is now waiting expectantly for payment.

Whoever he was he's probably buying essays off the internet to further his academic career. If he's British he'll probably leave school and go straight onto state benefit handouts and dream of becoming a "celebrity", why work when some other bugger will support you?:mad:

Yeah, funny how the request was only to normalise tables. Perhaps they will register as a different user to ask the next question on their homework sheet... Create a query? Create a form?

Oh well

Am I the only one, or does anyone else want to snuggle-up to Oldsoftboss's avatar? :)

Am I the only one, or does anyone else want to snuggle-up to Oldsoftboss's avatar? :)

Great to see some-one else with a light hearted sense of humor. I don't know how many PM's I've got requesting / ordering me to remove it as they are afraid "their boss might see it". Some people really need to lighten up. Cheers olorin, glad I brightened up your day.

OSB....never remove your Avatar. Never. :D Makes me smile every time I see you post. :)

I think her boobs need normalising:cool:

VisitNo VisitDate PatNo PatAge PatCity PatZip ProvNo ProvSpecialty Diagnosis
V10020 1/13/2000 P1 35 DENVER 80217 D1 INTERNIST EAR INFECTION
V10020 1/13/2000 P1 35 DENVER 80217 D2 NURSE PRACTIONER INFLUENZA
V93030 1/20/2000 P3 17 ENGLEWOOD 80113 D2 OBGYN PREGNANCY
V82110 1/18/2000 P2 60 BOULDER 85932 D3 CARDIOLOGIST MURMUR
V34210 1/18/2000 P4 65 ENGLEWOOD 80113 D3 CARDIOLOGIST IRREGULAR BEAT

Create a set of normalized tables, upto BCNF.

The diagnosis should be using the International Classification of Diseases (V10) codes as subscribed to by all countries worldwide.
This allows for consistency across the board and the World Health Organisation can see / track worldwide trends and pandemics more easily.

Col

Am I the only one, or does anyone else want to snuggle-up to Oldsoftboss's avatar? :)

You are not the only one - theres a queue...

Great to see some-one else with a light hearted sense of humor. I don't know how many PM's I've got requesting / ordering me to remove it as they are afraid "their boss might see it". Some people really need to lighten up. Cheers olorin, glad I brightened up your day.

They are the nicest pieces of ass i have ever seen:D