To keep and record bill details, a bill book can be maintained with handwritten bills with the fields bill number, patient id, patient type, doctor charge, medicine charges, room charges, operation charges, number of days, nursing charges, advance, health card, lab charges and bill amount. To maintain the room related records a separate register can be maintained which contains information regarding room number, room type and status. The patient out records can be maintined by another register and contains recorded with patient id, date and lab number. The register to maintain patient in records contains the patient id, room number, date of admit, date of discharge, advance and labno. The lab register contains the record for lab information which stores the fields like labid, patient id, weight, doctor id, date, category, patient type and amount. A patient id is generated by a specific set of rules (Constraints) and pateint information such as name, age, height, weight, gender, address, phoneno, disease and doctorid. Whenever a doctor join or resigns from the hospital, his/her information will be added, updated or removed from the register. The doctor informaton is recorded into the register of doctors. The following steps are considered as an entry for the hospital management system: Each and every record is entered by a person at the reception. #Notes on database management system pdf manual
In the manual record-keeping system the entries are done in the registers physically. Organizations can maintain and keep the track record of transactions in 2 ways: Keeping and maintaining records is one of the important tasks for the organization for future transactions and growing the business or services.
Displaying records that matches with exact valuesĮvery organization is handling data.Create Table Command – Unit 3 Database Management Computer Science Class 12.Starting MySQL and working with database.File system to Database Management System.Database Management System – Unit 3 Database Management Computer Science Class 12.File System – Unit 3 Database Management Computer Science Class 12.
0 kommentar(er)
