This is my first E-R diagram for my first Mini Project on Hospital Management System.
- Comment
- Reblog
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
This is my first E-R diagram for my first Mini Project on Hospital Management System.
Abhijay Patne 
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:13can i make a E-R diagram for Hospital Management system that has only 3 entity type?
please explain well
Thanks:)
Posted by lene lagmay | 09/02/2014, 16:51Yes, you can.
Go through E-R diagram basics tutorial, you will get good idea about the same.
Posted by Abhijay Patne | 17/02/2014, 01:14enter 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:56thank u.ur diagram helped me a lot in my minipriject
Posted by surabhi | 06/07/2012, 23:52since 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:21Can I remove ISA? N keep the rest?
Posted by meghana | 11/03/2016, 07:55No, it removes the specialization achieved by ISA relation.
You can refer: http://www.tutorialspoint.com/dbms/dbms_generalization_aggregation.htm
Hope this helps.
Posted by Abhijay Patne | 12/03/2016, 01:08good one….
Posted by Sagar Tikore | 15/06/2013, 11:39nic
Posted by Just_P | 24/07/2013, 07:14very good job….
Posted by Pallavi Deokar | 04/08/2013, 23:38what is meant by ISA?
Posted by sidra | 03/12/2013, 08:18ISA is a kind of relationship which specifies generalization and specialization between entities.
Posted by Abhijay Patne | 05/12/2013, 00:36Id just like to say this diagram and the below comments helped me out a ton. Thanks for taking the time out to individually answer EVERYONE who posted. Keep up the great work
Posted by XODOHTRONU | 04/12/2013, 21:01Welcome. 🙂
Posted by Abhijay Patne | 05/12/2013, 00:35pls give the detailed description for the above diagram/..
Posted by Priscilla B | 03/02/2014, 02:25Go through basics of ER diagrams, you will understand everything.
Posted by Abhijay Patne | 17/02/2014, 03:51Still if you come across anything, feel free to get back, I’ll be happy to help. 🙂
Posted by Abhijay Patne | 17/02/2014, 03:52How to make ERD in case of multiple departments in Hospital?
Posted by ahmed | 14/11/2015, 05:21If they have common features, single ERD will work for all the departments. If not, you can use the concept of generalisation and aggregation while drawing ERD.
You can refer: http://www.tutorialspoint.com/dbms/dbms_generalization_aggregation.htm
Hope this helps.
Posted by Abhijay Patne | 15/11/2015, 02:40plss helping me out…:(:(
whts the meaning of ias..!!!
Posted by gupta.payal16@yahoo.com | 19/04/2014, 08:44ISA is a kind relationship between entities.
Refer: http://en.wikipedia.org/wiki/Is-a
Posted by Abhijay Patne | 24/04/2014, 06:57I am interested with this,
Posted by archan kumar | 26/09/2014, 12:38Please tel me about DBMS book for deep study
Posted by archan kumar | 26/09/2014, 13:01Refer Korth book: http://codex.cs.yale.edu/avi/db-book/db6/slide-dir/
Posted by Abhijay Patne | 26/09/2014, 13:37can u help me in coding for my final year project?
Posted by kanwal | 09/01/2015, 02:14What is the idea of your project?
Where are you in your project implementation?
If idea interests me, I’ll definitely help you.
Posted by Abhijay Patne | 14/01/2015, 15:28I Need an ER Diagram Of Hospital Managemet System and explanation …its not to be lengthy
Posted by Vikram Kumar | 14/08/2015, 08:32As in?
Posted by Abhijay Patne | 26/08/2015, 03:27I want Tree Programming with source code in c .
Posted by Vikram Kumar | 28/08/2015, 13:29I Need a simple Tree not in Binary condition and the tree in which nodes are having varying more than 2 child. like a tree contain one node 3 child and another 5 child
…..ITS URGENT
Posted by Vikram Kumar | 28/08/2015, 13:32Can u tell me all entities and attributes used in this er diagram.
Posted by Parv | 14/04/2015, 12:11If you read the diagram properly, you’ll be able to understand entities and attributes.
Thank you.
Posted by Abhijay Patne | 23/10/2015, 18:11hii u should have mentioned the relationship between the entities
Posted by kaustubhDeval | 23/07/2015, 03:42brother, how treatment can come under weak entity, it can also have specific ID,if mentioned.!!
Posted by kaustubhDeval | 24/07/2015, 01:38Yeah, I agree.
Posted by Abhijay Patne | 23/10/2015, 18:14The E-R diagram itself demonstrates relationship between entities.
Posted by Abhijay Patne | 23/10/2015, 18:12for the ‘is a’ concept here, each of the nurse, doctor hav the saem attributes as an emplyee right? how should the schema be specified for entities like doctor, nurse?
each of doctor nurse are a table in the DB?? wat will be its atributes?
Posted by Aakarsh | 28/08/2015, 07:35Yes, both doctor and nurse have the same attributes. There is a table “Employee”, which will have information for doctors and nurses.
Posted by Abhijay Patne | 04/09/2015, 17:59hii can u tell me what are constraints(conditions) in it nd how we donote them in diagram
Posted by rajesh | 27/09/2015, 05:26Which constraints are you talking about?
Posted by Abhijay Patne | 23/10/2015, 18:53dude, I think this a better er diagram compared to mine……………….thanks alot
Posted by Kenneth RAnyyeta | 14/04/2016, 10:23Glad it helped.
Posted by Abhijay Patne | 18/04/2016, 13:35good topic in help in my studty
have upload more then topic in database management system
Posted by CHHABI LAL GARHEWAL | 23/08/2016, 08:40Glad that it helped.
Posted by Abhijay Patne | 09/04/2017, 04:28What does ISA means
Posted by rasheed | 06/11/2016, 06:36https://en.wikipedia.org/wiki/Is-a
Posted by Abhijay Patne | 09/04/2017, 04:27What does isa means in trangle?
Posted by Fazlekhan | 02/01/2017, 09:14https://en.wikipedia.org/wiki/Is-a
Posted by Abhijay Patne | 09/04/2017, 04:27ISA stands for what…?
Posted by Hassan Khan Jani | 25/01/2017, 04:46https://en.wikipedia.org/wiki/Is-a
Posted by Abhijay Patne | 09/04/2017, 04:26what is ISA in diagram
Posted by Aftab Ahmad | 05/04/2017, 12:16https://en.wikipedia.org/wiki/Is-a
Posted by Abhijay Patne | 09/04/2017, 04:25What will be the corresponding DFD of this ER diagram??
Posted by Mainul | 08/08/2021, 23:58I don’t have DFD. It can vary based on the application design.
Posted by Abhijay Patne | 10/08/2021, 22:22