Database Design for Hospital Management

  • 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....! "
    😎

  • 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

  • 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.

  • Its an Uni project..

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

  • 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

  • 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....! "
    😎

  • 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

  • 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?

    β€œWrite the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    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

  • 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....! "
    😎

  • 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.

  • 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