MySQL Routine (Stored Procedure) To Insert a User Into tUser Table

We assume that you have read about personnel sub system in the hospital information system that presented before at http://databasescript.blogspot.com/2012/10/entity-relationship-model-of-hospital.htmlIn this article will take up about inserting a user id, password and other fields that related to tUser table in personnel sub system. This procedure...

Entity Relationship Model of a Hospital-Based Database System

In the ER diagram of a Hospital-Based Database System, we can view the entities are Patient, Doctor, Receptionist, Department, Medicine, Test, etc. Among these entities, relationships exist which connect all the entities in the diagram. For example, Patient, Doctor and Receptionist are connected via the relationship Appointment. In other words, a...