The Hospital Management Database System caters to the needs of management of hospital where end to end activity right from entering patient records to generating bill takes place. Through the designed Entity relation diagram and SQL queries, Hospital Data has been throughly analysed in order to draw relevant information such as finding department which generates maximum bill, Finding individual patient bill amounts and many other important issues.
- EntityRelationship.jpg : Entity relationship diagram of the database design
- HospitalQueries.sql : SQL File containing queries related to analysis of Hopital Management Data.