This is my first E-R diagram for my first Mini Project on Hospital Management System.
Abhijay Patne
Me and my small reservoir of knowledge, experiences.
E-R Diagram for Hospital Management System
This is my first E-R diagram for my first Mini Project on Hospital Management System.
how the treatment
and equipment is weak entity???
Posted by sopan | 30/01/2012, 08:02Both are weak entities as they don’t have primary key. We can convert treatment to strong entity by creating treatment ID as its primary key.
Posted by Abhijay Patne | 04/04/2012, 04:13enter the question for e-r diagram too plzzzzz……….
Posted by rahul kathuria | 08/02/2012, 18:52Just do a Google search.
Posted by Abhijay Patne | 04/05/2012, 17:58what does a triangle signify here? “is a” is in triangle
Posted by jahanvi | 23/02/2012, 03:48Triangle specifies concept of Generalization (bottom to top) or viceversa. For more details Google for “Is a ralationship in database”.
Posted by Abhijay Patne | 01/03/2012, 13:30the triangle is like a connector for example employee is a doctor or nurse they both are employee
Posted by srinithi | 25/01/2013, 10:26It will be right that The Hospital Management systems is very easy to maintain, cost-effective, scalable and get with well known price.
Posted by temmyliear | 01/03/2012, 05:28Yes.
Posted by Abhijay Patne | 01/03/2012, 13:28what are these double lines showing towards nurse??
Posted by shaize | 26/03/2012, 09:10Those double lines show that there is at least on nurse governing each room.
Posted by Abhijay Patne | 04/04/2012, 04:04total participation
Posted by hamza iqbal | 26/04/2012, 00:10Right.
Posted by Abhijay Patne | 02/05/2012, 15:18Im stucked with the same Hospital management System digram .. My one is a lil different than urs .. ur diagram helped me alot .thnks dude ..
Posted by Vaishnavy | 31/03/2012, 03:58Welcome !
Posted by Abhijay Patne | 04/04/2012, 04:01Sorry double *ellipse
Posted by Naveen | 08/04/2012, 10:53Double ellipse in an E-R diagram represents multivalued attributes. As attributes info and contact no can have multiple values for a single entity, so is the ellipse. Hope this helped.
Posted by Abhijay Patne | 08/04/2012, 11:44good
Posted by desrftgyj | 16/04/2012, 03:27Thank you.
Posted by Abhijay Patne | 02/05/2012, 15:19What does double dotted ellipse and single dotted ellipse specify?
Posted by Rajan | 18/04/2012, 09:21Double dotted : Attribute can have multiple values.
Single Dotted : Derived attribute.
Posted by Abhijay Patne | 02/05/2012, 15:20are these relationships one to many or many to many how do we know it?
Posted by kuppxx | 01/05/2012, 10:59I have not specified whether relationships are one to many or many to one. You can show it with the help of appropriate directions.
Posted by Abhijay Patne | 02/05/2012, 15:23Thanks man is is the good job u did ,it help me on board exam ,
Posted by Suniel khatiwada,kathmandu,nepal | 02/05/2012, 23:57Welcome. Keep visiting.
Posted by Abhijay Patne | 04/05/2012, 17:52What is the difference between attributes ID and Record No.? Which have same values?
Posted by shobha | 03/05/2012, 08:29ID is an identification number generated for a particular patient whereas record no keeps track of records. Both are primary keys of Patient and record respectively.
Posted by Abhijay Patne | 04/05/2012, 17:56since this er diagram is sooo tough to make…………..wt can we do…….plsss suggest bro…..
Posted by abirami | 14/07/2012, 08:01You can use any good (or comfortable) drawing tool. Staruml is good one for offline, if you like online tools try gliffy.com.
Posted by Abhijay Patne | 14/07/2012, 17:41Xcellent job…………
Posted by kowshika | 22/07/2012, 08:37Thanks.
Posted by Abhijay Patne | 03/08/2012, 13:31Gud job…..you can give somemore explanations……….
Posted by shalini | 22/07/2012, 08:40Some more explanation in the sense. Diagram itself is explanatory.
Posted by Abhijay Patne | 03/08/2012, 13:30what are the segments of the diagram?
Posted by dooom | 22/07/2012, 21:44Relationships can be displayed as diamonds or can be simply line segments between two entities.
Posted by Abhijay Patne | 03/08/2012, 13:29Hey abhijay! Thanx a lot for posting…dis ws very helpful buddy..plz could you help for more diagrams like on library system,payroll system of PU,Hotel management?? rply soon..thanx
Posted by apurva | 03/08/2012, 12:10You should study E-R Diagrams and draw them on your own. Contact me for any doubt, i will surely help.
Posted by Abhijay Patne | 03/08/2012, 13:26i want d assumptions..plz…cn u help….
Posted by harshitha | 27/08/2012, 04:12Assumptions of what?
Posted by Abhijay Patne | 01/09/2012, 14:36what is ISA?
Posted by shalini singh | 07/09/2012, 14:12ISA is a keyword used to specify connection between Generalized Entities and Specialized Entities. In this case Employee is a generalized object whereas doctor is specialized entity hence doctor ISA employee.
Hope this helps.
Posted by Abhijay Patne | 08/09/2012, 02:51thanx abhi
Posted by seema chaudhary | 09/09/2012, 21:24Welcome!!
Keep Visiting.
Posted by Abhijay Patne | 11/09/2012, 08:49good work…got helpd a lot..:)
Posted by Dimple Garg | 15/09/2012, 08:14Thank you. Keep visiting..!!
Posted by Abhijay Patne | 24/09/2012, 09:17great job dude….
Posted by pallavi | 24/09/2012, 07:37Thank you. Keep visiting..!!:)
Posted by Abhijay Patne | 24/09/2012, 09:16hey can u giv me the relation for the hospital mangement plss if u can
Posted by RUKHSHAR MANSURI | 07/10/2012, 00:27The ER diagram itself is self-explanatory. What else do you need?
Posted by Abhijay Patne | 19/10/2012, 11:34wat is the foreign key in the above diagram?
Posted by fasi | 13/10/2012, 16:15Foreign key is the attribute used in one entity, which is the primary key of other entity. In my case, I haven’t shown any foreign key.
Posted by Abhijay Patne | 19/10/2012, 11:33& wat will be the bottom up approach for this ER Diagram?
Posted by fasi | 13/10/2012, 16:41This ER diagram has been designed with bottom up approach. In Bottom up approach, you first design whole database schema, define hierarchy and relations between entities and when everything is finalized, you draw the diagram.
Posted by Abhijay Patne | 19/10/2012, 11:28thnx dude
Posted by fasi | 21/10/2012, 20:45what does it mean by ISA there?
Posted by nadia | 27/10/2012, 17:23ISA is a symbol specifying special category of a general type. eg. person ISA doctor. Hope this clears
.
Posted by Abhijay Patne | 01/11/2012, 11:24good
Posted by osho | 31/10/2012, 03:18Thanks. Keep visiting.!!
Posted by Abhijay Patne | 01/11/2012, 11:21Thank U , So helpful Example (Y) !
Posted by Riham | 18/11/2012, 14:04Welcome..
Posted by Abhijay Patne | 23/11/2012, 07:41NICE WORK
Posted by AWAN | 23/11/2012, 06:34Thank you.
Posted by Abhijay Patne | 23/11/2012, 07:39Thanks.
Posted by Abhijay Patne | 13/12/2012, 13:09hey can u help me out with my erd…?? it is the same topic… but with different entities.. and we have to make it in a Crow’s foot notation…
Posted by meow18meow | 04/12/2012, 08:52Sorry for late reply. vt sort of help do u require?
For Crow’s notation, only representation changes nothing else.
Posted by Abhijay Patne | 13/12/2012, 13:09ABHIJAY PATNE thanx yaar
ur Diagram along with the Comments _/\_ for you man
it helped Me a lot
Posted by Pranil Dukare | 03/02/2013, 19:58Welcome.
Posted by Abhijay Patne | 04/02/2013, 15:48please tell which book i refer for DBMS
Posted by vanashri nigade | 16/02/2013, 06:50Go for “Database System Concepts” by Korth
Posted by Abhijay Patne | 18/02/2013, 21:20thank you.
Posted by vanashri nigade | 24/02/2013, 00:11hi brother ..iam working on the hospital management mini project.. i need to display all the fields by getting the id as a input that is supposed to be the primary key of my table..i have chosen vb.net for this.. let me know the required code to retrieve the info from database and display in the front end ..pls do help..
Posted by bhuvijourns | 12/04/2013, 08:52Sorry bro, i hv used java for ma project nd hv absolutely no idea abt vb.net.
Jst google for it, ull get lots of examples..
Posted by Abhijay Patne | 15/04/2013, 15:18what is ISA ??
Posted by hamza smadi | 13/04/2013, 10:12ISA specifies generalisation and specialization between entities connected.
Posted by Abhijay Patne | 15/04/2013, 15:21