Final Project Report for Professional Consulting In Information System(IS)

Assisted living automation calls for efficient software solutions. The software being adopted needs to consider the security, wellbeing, satisfaction. and proper management of residents. Fundamentally, assisted living software are designated to enhance communication amid residents and their families. They also aim at improving the quality of the existing services. The software also lets the personnel schedule, optimize, and have a proper control of the activities which they take part in.

For a product to be included in Assisted Living category, it has to meet the following conditions (Shah & Patel, 2018): (1)must be in a position of assessing the needs of the residents in terms of gender, age, health and other important aspects; (2) must be in a position of developing standards of service delivery and comply with any agreement which might need (Thanh & Au, 2017); (3) should be in a position of being customized so as to meet the user needs; and (4)must be in a position of tracking the schedules meeting the needs of the patients.

Medical Development Corp is a family owned development and management company specializing in senior housing and hospitality. They do not have a single system for employees to access and share information about the different facilities, their medical conditions along with compliance, policy and procedure. Employees need to contact different departments or coworkers for getting such information. This becomes an issue as it takes away from employee productivity. Poor technology integration into the healthcare sector has resulted to several issues including but not limited to provision of poor-quality services to patients. Another challenge that is facing the healthcare sector with the automation solution is long waiting times to receive treatment services. This has posed a greater threat to the wellbeing of the patients, specifically when they are in a critical condition. The above conditions will eventually result in the offering of poor services. This project aims at coming up with solutions which will help address these issues.

There exist several solutions that are in place currently to address prolonged delays in hospitals prior to receiving treatment. One is the decentralization of the hospital administration, with the goal of ensuring that different patients are being addressed from diverse locations, to reduce congestion. Although the technique has helped in reducing the delays, there is still needed to have more efficient ways that can make this challenge null. Another way the challenge is being addressed currently is by having online reservation of nurses and doctors prior to arriving for medical conditions. According to Akshay et al. (2019), this also was helpful in a way but was not efficient.

The technology currently in use in the company is plain html/java scripts which are purely script based. The websites allow the organization to display some of its information, but only after being through several parties. The technology is also reliant on Microsoft Excel formatting along with physical papers in trying to maintain its data. This is dangerous as some of the information can easily be lost or misplaced.

In the future, there is need to develop an interactive website to:

1. Accept input from different channels including email, phone (text message or voice mail), website, Excel and external vendors to accept data and update it on the website in near real time,

2. Send alerts and immediate response for critical situations.

3. Capable of linking the facility website within a manner that information moves directly to the website free of any potential stopovers. With such technology, any activity taking place within the organization will be available on the website and any reference will be made easily, and the company should also consider generating an Entity Relationship Diagram (ERD) to ensure that any information stored is safe.

Establishment of an interactive website and information system will enhance the communication between different entities within the organization. It will also ensure easier and better service provision especially because it will be able to send alerts about any critical situations and provide immediate response. This will benefit the organization significantly in that the communication would be directly transmitted to the website and the entire information system without necessarily having to pass through different stages. In this manner, installation of the new system will be vital towards improving the strategic plan of the organization and enhancing its long-term plan. The project objective is to reduce the healthcare service delays through enhancing automation by creating a channel whereby, the facility management and other stakeholders within a region can pass information easily and automatically through an application. The desired outcome of the project is to have an automated healthcare facility in which patients will always be receiving efficient services.

The project scope is limited to the design a solution for interactive website for a company. The implementation will be done in different phase and its and it is not part of this project.

This interactive website plays a key role in minimizing the time spent to carry out different operations within the system. Most importantly, the members of staff within the facility and other stakeholders will be able to easily and efficiently share and receive important communication among them. Faster communication would also ensure faster implementation of operations within the facility.

There are specific activities that the project aims at carrying out as far as achieving the objective is concerned. The automated system will facilitate linking the project facility system to its website in such a way that data is directly transmitted through the website. For instance, if the facility management wishes to communicate some changes to the organizational staff members, they would update the online noticeboard via the facility website and the system will be automatically informed. Also, any community projects would be posted on the website and this information would be passed to other entities within the facility. The website will also work in an interactive manner, in such a way that community members can communicate to the facility about any healthcare issues and the organization will respond to the enquiries in good time. Through this automated system, the healthcare services delays will be reduced significantly for the betterment of the facility and the patients as well.

Upon successful completion of the project, the assisted living facility will switch from manual communication system to the automated system. This would significantly improve the quality of healthcare services, which had been undermined by the issue of delays. This way, the project will have reduced cases of deaths and even project failures that are caused by delayed services.

An entity-relationship diagram shows the relationships of sets of entities stored in a database.

The medical purchases table is as follows.

The Patient table is as follows

The Facility table is as follows

The Medical orders table is as follows

The Medical suppliers' table is as follows

The emergency call table is as follows.

The Wellness examination table is as follows.

The Pharmacy table is as follows

Each table has a key or unique identifier marked with * which becomes the foreign key in another table.

The relationship at the Patient table is many to one. The Facility table relationship is one to one. The medical supplier table relationship is one to many. The pharmacy relationship is one to many. The Caregiver table relationship is one to many (Liu et al., 2018). The Medical Orders table relationship is many to one. The Medical Purchases table relationship is many to one (Shin et al., 2017). The Wellness table relationship is one to many. The constraints for this entity relationship diagram include a lack of locational inter-relationships between the numerous branches of the care institution. This means that there is no way to tell if specialized care is available in another location or whether it has been given there.

Akshay, V., Kumar, A., Alagappan, R. M., & Gnanavel, S. (2019, March). BOOKAZOR-an Online Appointment Booking System. In 2019 International Conference on Vision Towards Emerging Trends in Communication and Networking (ViTECoN) (pp. 1-6). IEEE.