Patient Management System

-

 Patient Management System

      We will include the following in this blog...

  1. Introduction to the case study scenario.
  2. Team member with the students numbers. 
  3. Identification of Entities.
  4. Identification of attributes
  5. Identification of  relationships
  6. ER diagram with assumption and explanation.
  7. Identification of actors.
  8. Identification of Business process.
  9. Functional requirements of the system.
  10. Non-Functional requirement of the system.
  11. Normalization of the relation drawn using the ER diagram.
  12. Relational database schema with foreign key references.
  13. SQL statements on table creation and populating them(CREATE and INSERT statements).
  14. Screenshot of MYSQL workbench(SQL commands and the result set). 


Comments

Post a Comment

Popular posts from this blog

Business process in the System

-
Image
  Business Process in Patient Management System Business Process Management System in Hospitals – Initiation Steps The first step of design of the system when implementing business process management in hospitals pertains to recognizing the existing processes, as well as evaluating what processes needs to be integrated. Ideally, areas of concentration include among other things, which depend on the health center:  📌Depiction of the process design  📌 Operators within it; i.e., health professionals  📌Escalations  📌Notifications  📌Alerts among other related things Secondly, the prospective system can be modeled, where it involves the theoretical plan, and incorporates some variables like the costs of implementation, as well as how the system might function under different environment. In this stage the involved party could identify the potential problem, and have a good comprehension of the issues in accordance to the overall organization goals and missio...
Read more