July 2, 2012 at 1:18 am
Hi,
I want to create a database for hospital management system.
but i dont have much idea to design db. Can anyone help creating db for hospital management.
It will be a great help.
Reply With Quote
Regards,
Jigneshal
" Stretch Your Limit Little Beyond Your Limit....! "
😎
July 2, 2012 at 1:28 am
I suggest hiring a consultant.
Or at least following some courses about database design and read some books about the subject.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 2, 2012 at 1:32 am
Jigneshal (7/2/2012)
Hi,I want to create a database for hospital management system.
but i dont have much idea to design db. Can anyone help creating db for hospital management.
It will be a great help.
Reply With Quote
Is this a personal project or professional? ie for college/uni
What will you be managing?
Depending on the scale it could mean a consultant.
July 2, 2012 at 2:16 am
Its an Uni project..
Regards,
Jigneshal
" Stretch Your Limit Little Beyond Your Limit....! "
😎
July 2, 2012 at 2:18 am
Jigneshal (7/2/2012)
Its an Uni project..
In that case I would recommand to learn more about ER (Entity Relationship) modelling and about normalizing databases.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 2, 2012 at 2:20 am
MysteryJimbo (7/2/2012)
Jigneshal (7/2/2012)
Hi,I want to create a database for hospital management system.
but i dont have much idea to design db. Can anyone help creating db for hospital management.
It will be a great help.
Reply With Quote
Is this a personal project or professional? ie for college/uni
What will you be managing?
Depending on the scale it could mean a consultant.
the project is meant to manage patients, staff, doctors, ward rooms, embulance, testing laboratories etc...
it contains patients history , decease history, prescriptions by docs,.. etc
Regards,
Jigneshal
" Stretch Your Limit Little Beyond Your Limit....! "
😎
July 2, 2012 at 2:31 am
Jigneshal (7/2/2012)
Its an Uni project..
Good guess on my part since its extremely unlikely that it'd be a professional question like that.
Assuming you already know the basics of database design from you uni course, I'd start with looking at the people entities (patients, doctors, nurses etc) and their records then build from there. As you will already know, an employee can become a patient so I would suggest a single table (or group of tables) for people/persons and go from there. At least thats how I would do it.
As it is a uni task I'd suggest other comments simply point you in the right direction rather than giving you a direct answer since you will learn more and everybody will have slightly different approaches. You will gain more by doing it yourself and your teacher will learn more from your approach
July 2, 2012 at 2:32 am
Jigneshal (7/2/2012)
MysteryJimbo (7/2/2012)
Jigneshal (7/2/2012)
Hi,I want to create a database for hospital management system.
but i dont have much idea to design db. Can anyone help creating db for hospital management.
It will be a great help.
Reply With Quote
Is this a personal project or professional? ie for college/uni
What will you be managing?
Depending on the scale it could mean a consultant.
the project is meant to manage patients, staff, doctors, ward rooms, embulance, testing laboratories etc...
it contains patients history , decease history, prescriptions by docs,.. etc
Aren't you meant to be doing this?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
July 2, 2012 at 2:38 am
MysteryJimbo (7/2/2012)
Jigneshal (7/2/2012)
Its an Uni project..Good guess on my part since its extremely unlikely that it'd be a professional question like that.
Assuming you already know the basics of database design from you uni course, I'd start with looking at the people entities (patients, doctors, nurses etc) and their records then build from there. As you will already know, an employee can become a patient so I would suggest a single table (or group of tables) for people/persons and go from there. At least thats how I would do it.
As it is a uni task I'd suggest other comments simply point you in the right direction rather than giving you a direct answer since you will learn more and everybody will have slightly different approaches. You will gain more by doing it yourself and your teacher will learn more from your approach
Thanks MysteryJimbo
Regards,
Jigneshal
" Stretch Your Limit Little Beyond Your Limit....! "
😎
July 3, 2012 at 8:38 am
There are multi-billion-dollar companies (Cerner, for example) whose sole purpose is to create hospital management systems that cost hundreds of thousands to millions of dollars. It sounds like you're biting off a big chunk to start your database design experience. I'd recommend that you scale back a bit (or a lot!) to learn the concepts and then work from there. Otherwise you're starting on a multi-year task with plenty of opportunities to get lost in all the details. If this truly is a university project that was assigned to you, I have to wonder what it is they're trying to teach you, especially someone who (evidently) hasn't been exposed to database design theory.
September 8, 2012 at 12:41 am
A database system was designed based on a case study of Hospital via Entity Relationship Diagram
Relational Model , Normalization of tables and Implementation in SQL server.
Hospital Management System
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply