This is my first E-R diagram for my first Mini Project on Hospital Management System.
how the treatment
and equipment is weak entity???
Both 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.
can i make a E-R diagram for Hospital Management system that has only 3 entity type?
please explain well
Yes, you can.
Go through E-R diagram basics tutorial, you will get good idea about the same.
enter the question for e-r diagram too plzzzzz……….
Just do a Google search.
what does a triangle signify here? “is a” is in triangle
Triangle specifies concept of Generalization (bottom to top) or viceversa. For more details Google for “Is a ralationship in database”.
the triangle is like a connector for example employee is a doctor or nurse they both are employee
It will be right that The Hospital Management systems is very easy to maintain, cost-effective, scalable and get with well known price.
what are these double lines showing towards nurse??
Those double lines show that there is at least on nurse governing each room.
Im stucked with the same Hospital management System digram .. My one is a lil different than urs .. ur diagram helped me alot .thnks dude ..
Sorry double *ellipse
Double 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.
What does double dotted ellipse and single dotted ellipse specify?
Double dotted : Attribute can have multiple values.
Single Dotted : Derived attribute.
are these relationships one to many or many to many how do we know it?
I have not specified whether relationships are one to many or many to one. You can show it with the help of appropriate directions.
Thanks man is is the good job u did ,it help me on board exam ,
Welcome. Keep visiting.
What is the difference between attributes ID and Record No.? Which have same values?
ID 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.
thank u.ur diagram helped me a lot in my minipriject
since this er diagram is sooo tough to make…………..wt can we do…….plsss suggest bro…..
You can use any good (or comfortable) drawing tool. Staruml is good one for offline, if you like online tools try gliffy.com.
Gud job…..you can give somemore explanations……….
Some more explanation in the sense. Diagram itself is explanatory.
what are the segments of the diagram?
Relationships can be displayed as diamonds or can be simply line segments between two entities.
Hey 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 :)
You should study E-R Diagrams and draw them on your own. Contact me for any doubt, i will surely help.
i want d assumptions..plz…cn u help….
Assumptions of what?
what is ISA?
ISA 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.
Keep Visiting. :)
good work…got helpd a lot..:)
Thank you. Keep visiting..!! :)
great job dude….
Thank you. Keep visiting..!!:)
hey can u giv me the relation for the hospital mangement plss if u can
The ER diagram itself is self-explanatory. What else do you need?
wat is the foreign key in the above diagram?
Foreign 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.
& wat will be the bottom up approach for this ER Diagram?
This 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.
what does it mean by ISA there?
ISA is a symbol specifying special category of a general type. eg. person ISA doctor. Hope this clears
Thanks. Keep visiting.!!
Thank U , So helpful Example (Y) !
hey 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…
Sorry for late reply. vt sort of help do u require?
For Crow’s notation, only representation changes nothing else.
ABHIJAY PATNE thanx yaar
ur Diagram along with the Comments _/\_ for you man
it helped Me a lot
please tell which book i refer for DBMS
Go for “Database System Concepts” by Korth
hi 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..
Sorry 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.. :)
what is ISA ??
ISA specifies generalisation and specialization between entities connected.
very good job….
what is meant by ISA?
ISA is a kind of relationship which specifies generalization and specialization between entities.
Id 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
pls give the detailed description for the above diagram/..
Go through basics of ER diagrams, you will understand everything.
Still if you come across anything, feel free to get back, I’ll be happy to help. :)
How to make ERD in case of multiple departments in Hospital?
If 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.
plss helping me out…:(:(
whts the meaning of ias..!!!
ISA is a kind relationship between entities.
I am interested with this,
Please tel me about DBMS book for deep study
Refer Korth book: http://codex.cs.yale.edu/avi/db-book/db6/slide-dir/
can u help me in coding for my final year project?
What is the idea of your project?
Where are you in your project implementation?
If idea interests me, I’ll definitely help you.
I Need an ER Diagram Of Hospital Managemet System and explanation …its not to be lengthy
I want Tree Programming with source code in c .
I 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
Can u tell me all entities and attributes used in this er diagram.
If you read the diagram properly, you’ll be able to understand entities and attributes.
hii u should have mentioned the relationship between the entities
brother, how treatment can come under weak entity, it can also have specific ID,if mentioned.!!
Yeah, I agree.
The E-R diagram itself demonstrates relationship between entities.
for 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?
Yes, both doctor and nurse have the same attributes. There is a table “Employee”, which will have information for doctors and nurses.
hii can u tell me what are constraints(conditions) in it nd how we donote them in diagram
Which constraints are you talking about?
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of new comments via email.
Create a free website or blog at WordPress.com. The Morning After Theme.
Get every new post delivered to your Inbox.