Personnel Tracker

Medical personnel tracker that records the locations of employees and displays data to the other personnel and patients

Comment

Inspiration

We were inspired to do this project due to personal experiences. Many times it is hard for a patient to keep track of which Medical Personnel had entered their room. Instead, the patients should be able to track where their doctors are located.

What it does

The design will keep track of Medical personnel as they enter and leave the room. It will also keep track of patients and provide updates to family members as the patients are taken care of.

How we built it

We built a database on MySQL to store the data of all chip readers, medical personnel, patients, and operation rooms. The backend is built on the framework of Express.js, using Javascript. The front end is a combination of HTML/CSS.

Challenges we ran into

Some challenges we ran into is the access of information between tables using public and foreign keys. GUI and front-end development are none of our specialties which proved difficult to set up basic web pages.

Accomplishments that we're proud of

  1. Getting an NFC card to interact with our backend.
  2. MySQL databases are connected to the backend.
  3. Team members are exposed to full-stack development.

What we learned

We learned that databases can get very complex if each table needs to refer to foreign and public keys. AWS is a wonderful system for backend setup.

What's next for Personnel Tracker

Better UX/UI, increased features, increased Data Sample, and more working components.

Share this project:

Updates