Please create a list of attributes and Primary Keys for this Scenario The Smiths

Question

Please create a list of attributes and Primary Keys for this Scenario

The Smithson Community Hospital (SCH) has purchased radio frequency identification (RFID) technology for use in tracking patients, staff, and equipment throughout the hospital. The technology consists of two complimentary components. The first is very small passive RFID chips embedded in tags on equipment, patient wrist bands, and staff name tags. The second are active scanners located in hallway doorways and individual rooms throughout the hospital. The scanners constantly transmit short range radio signals whose strengths, and therefore ranges, can be adjusted to limit their coverage area to as little as a few feet (for doorway scanners), to the area of differently sized rooms (patient room, recovery room, surgical suite, etc.). When a chip passes within range of a scanner the scanner signal reads the chip's ID. The scanners can then record the presence of the chip along with the date and time and the scanner location. SCH needs to use this technology for a wide range of purposes including tracking the current locations of patients, staff, and equipment as well as analyzing the historical movement of these things. By pairing up the characteristics of scanner locations with date and time stamps SCH can analyze service metrics. By pairing up locations of staff by type over time SCH can analyze work flow and efficiency (and detect troublesome patterns of staff behavior). Similar analysis can be performed on equipment usage. SCH needs to be able to identify and classify each scanner location as well as each item tagged with a chip. Locations have a hierarchical level of identification consisting of floor, wing, ward, and room including special locations such as elevator lobbies on each floor, hospital entrances, and ward entrances. Staff are classified by job type as well as whether they are employees or physicians with hospital privileges. Equipment is categorized by type, model, and serial number.

Explanation / Answer

RFID, Radio Frequency Identification is a technology, which includes wireless data capture and transaction processing. Proximity (short range) and Vicinity (long range) are two major application areas where RFID technology is used. Track and trace applications are long range or vicinity applications. This technology provides additional functionality and benefits for product authentication. Access control applications are Short range or proximity type of applications. AgileSense Technologies is focused on delivering innovative, high value RFID solutions assisting companys track assets, people and documents. AgileSense provides robust and complete RFID solutions built on top of its extensible middleware/framework for Government, Healthcare, Manufacturing and Aerospace industries.

Asset Tracking:

Static or in-motion assets tracking or locating, like a healthcare facility, wheelchairs or IV pumps in, laptops in a corporation and servers in a data center, was not so easy task.

User can instantly determine the general location of tagged assets anywhere within the facility with the help of active RFID technology. Control point detection zones at strategic locations throughout the facility allow the user to define logical zones and monitor high traffic areas. Tagged assets moving through these control points provide instant location data.

Asset tracking applications will see an almost vertical growth curve in the coming years and the growth rate in this area will be much higher than the growth rate of general RFID market.

People Tracking:

People tracking system are used just as asset tracking system. Hospitals and jails are most general tracking required places.

Hospital uses RFID tags for tracking their special patients. In emergency patient and other essential equipment can easily track. It will be mainly very useful in mental care hospitals where doctors can track each and every activity of the patient. Hospitals also use these RFID tags for locating and tracking all the activities of the newly born babies.

The best use of the people tracking system will be in jails. It becomes an easy tracking system to track their inmates. Many jails of different US states like Michigan, California, and Arizona are already using RFID-tracking systems to keep a close eye on jail inmates.

Document tracking:

This is most common problem. Availability of large amount of data and documents brings lots of problem in document management system. An RFID document-tracking system saves time and money by substantially reducing:

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.