Database Planning problem with Hospital Management System

[ehsan85]

Hello,
Recently I got a project named "Hospital Management System" and it should be completed with ASP.net and SQL database. I have no enough knowledge about hospital system, department, lab etc. I don't make it big project, I need small but complete and bug free project that's why I don't include employee payroll system. How can I get entities of a hospital and then I make table and relation in SQL? Please help.

best regards
ehsan

[TysonLPrice]

Sounds like you are trying to code a project before you know what it should do. Is this just something for your own developement, school, or is a hospital actually going to use it? What I'm trying say if this project is for more than "giggles and grins or homework" up front project requirements, specs, deliverables, etc. need considered before designing a database.

[techgnome]

That's what we would call requirements gathering... someone (or several someones) should know what they need/want the system to do... You don't just go out and design a large system like that (or even a small one... although, w/o knowing what it is supposed to do, I can't imagine this being small... but I suppose small is relative) without knowing the requirements.

-tg

[ehsan85]

thank you, but here is no client that's why I can't get help to gathering requirement. I need some necessary steps to go and I do not want to delete-create, delete-create.... the database.

[dee-u]

If you have no client then why do you have a project?

[jggtz]

https://www.google.com/#biw=800&bih=...5&pf=p&pdl=300

[ehsan85]

If you have no client then why do you have a project?

actually, this project is for the final exam not for professional work.

[Nightwalker83]

Is the design here what you are trying to accomplish (See post #6)?