How many tables will I create and what information should the table(s) contain

Question

1.00/5 (2 votes)

See more:

A patient comes into a medical laboratory, the patient is either referred by Doctor, or from HMO or he/she just walk in(self). Both Doctor and HMO has information specific to them like doctor may have(doctor name, hospital, phone no etc), hmo may have (hmo name, hmo address etc). so the user will select from dropdown for (Doctor, HMO, Self). Two things needed,
1. how many table(s) will i create and
2. their relationshiop

What I have tried:

I created referraltype table(refid, ref name, status)
i also create Doctor table(Doctor ID, Doctor name, Doctor Phoneno, Hospital), HMO table (HMO name, HMO address, patient HMO ID, patient unit etc)

Posted 16-Dec-17 4:03am

Solomon James

Updated 16-Dec-17 7:14am

Add a Solution

Comments

________________ 17-Dec-17 1:40am

Try to think about common things:
Not HMO and Doctor tables, but PatientReferer - because it has same fields - Name etc.

________________ 17-Dec-17 1:59am

Types of data also should not be freeze in static construction -
So you need to have table "PatientRefererTypes" - and than you can have rows in this table: "Doctor", "Self", "HMO", "Ambulance"....

________________ 17-Dec-17 2:03am

Than you should undestand tha Registration DB has two big categories of data - "Master" data, and Documents.
Master data - it is PatientRefererTypes table (have limited amount of rows, define non-concrete thing) and so on, Documents - it is "Patients" table - many concrete patients every day.

________________ 17-Dec-17 2:07am

Master data - Table of "PatientSex". :-)
Male,Female, other...
It is interesting! If not for you - you have selected wrong profession.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pete O'Hanlon · Answer 1 · 2017-12-16T07:13:00

Solution 2

You will create many tables. Some will have a 1 to 1 relationship. Some will have 1 to many. Beyond that, we can't get more specific because you are going to be the one responsible for gathering the requirements.

Posted 16-Dec-17 7:13am

Pete O'Hanlon

Dave Kreskowiak · Answer 2 · 2017-12-16T04:40:00

Solution 1

We're not here to do your home work for you. This is up to you to determine and I doubt this is everything that needs to be in the database.

If this isn't homework and is an actual application for production, you don't have the skill set to write it yet if you're asking these very basic questions.

Posted 16-Dec-17 4:40am

Dave Kreskowiak

Comments

________________ 17-Dec-17 1:37am

Hi! When you say "We" - what do you mean? How many are you?
This is second time when I meet on this site such opinion...
Am I miss a role - "Doing homework is forbidden!" ? Where?
:-\

Dave Kreskowiak 17-Dec-17 8:36am

We: All of the "regular" volunteer contributors who answer questions around here.

Is doing homework forbidden? No. Doing it FOR YOU is. You won't really learn the decision making process to get to any answer. You're either going to find an answer that works for your requirements or you're not. In either case, you're going to learn something, but you're going to have to make mistakes in order to move forward, to learn why a particular path didn't work. You're not going to get that information when someone does you're work for you or only takes you down the correct path.

________________ 18-Dec-17 2:42am

Regular volunteer or mentor-professor?
I came to this forum to answer to questions I can answer and get the rating.
It is kind of online game for me. Why not?
Source of question - this is not my problem. But I feel disappointed when my correct code was deleted, because it is probably homework for lazy student.
Well, if you so social oriented, and want to learn the others how to live, be smart enough to do it gently. I even do not speak about loosing new users. What they will do, when instead of answer to "stupid" question on this "smart" (or snob?) forum they will read "Solution 1 - Go away lazy student! We see that you!"?

Dave Kreskowiak 18-Dec-17 8:14am

Doing their homework for them doesn't teach them the most important piece: how to fail successfully. How to learn from their mistakes. They have to learn how to identify the path their on being the wrong one and identify other paths.

Your answers being deleted, aren't being deleted. They're being voted down because they're wrong or inappropriate, like doing someones homework for them. It takes multiple people to flag your answer as bad for it to disappear, and not just one or two votes.

If you're doing this just to get the meaningless rating, you're doing this for the wrong reasons.

________________ 19-Dec-17 2:44am

So you judge somebody only by you opinion about what is right and what is wrong?
How do you know, who is student? According text of message? Who gave you right to be The Great Censor?
Pay attention - I even do not suggest you to delete your off-topic "Solution1", it is not my problem also, but I do suggest - next time write "I am not here" instead of "We're not here".

Dave Kreskowiak 19-Dec-17 9:09am

How do I know who's a student asking about their homework? Easy. The structure and wording of what's in the OPs question.

Nobody made me the Great Censor. I'm just part of a large group that's been in the industry for a long time and sees the influx of plenty of people who couldn't think their way out of a cardboard box, let alone write code beyond "Hello World!"

The good schools are there to either teach you the concepts you're going to need out in the real world or filter you out of the industry. The bad schools are just there to take your money and don't care if you know what you're supposed to know to do this job.

In either case, these concepts don't "stick" if they are not practiced by the student. Giving someone the answers to their homework questions does NOT help them in the slightest. Sure, the answer may be correct, but the thought process to get to the answers has been bypassed and that's the most important part of the assignment. The point of the classes is HOW TO THINK, not what to think.

I haven't judged you at all. Others may because you're putting on quite the show in this thread, and over what? Your feelings? Rep points? I do this because I'm sick of seeing so many people who have no business being in the industry, who have no idea how to teach themselves concepts and techniques they haven't been exposed to before. THAT, right there, is the core of being a good developer and there is no way around it.

________________ 19-Dec-17 2:47am

-- you're doing this for the wrong reasons.
Will you pay me for answers?

:-))))))))))))