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

Equipment Attributes: tags,type,model,serial number,name
Staff Attributes: name_tag,job_type,job_role,name
Patients Attributes: wristband,name,disease_diagnosis

Location Attributes: floor,wing,ward,room

Scanner Attributes: range,strength

Primary Keys: tags,wristband,name_tag

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

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