Sandia Medical Devices Real-Time Glucose Monitoring Part 1 2. Glucose levels tha

Question

Sandia Medical Devices Real-Time Glucose Monitoring Part 1 2. Glucose levels that fall outside the specified range for 60 minutes (12 consecutive readings) Review the original system description in Chapter 2 3. An average of glucose levels over an eight-hour the additional project information in Chapters 3 and 4 period that falls outside a specified range and the domain class diagram shown in Figure 9-29 to refamiliarize yourself with the proposed system The specified range for an AlertCondition object Assume that the type attribute of the ondition is the set of values between and including lowerBound class identifies one of three alert types and upperBound. AlertCondition objects also include an effective time period specified by the attributes star- 1. Glucose levels that fall outside the specified tHour and endHour, which enables physicians to set dif range for 15 minutes (three consecutive ferent alert parameters for sleeping and waking hours readings 9-29 FIGURE Updated domain model class diagram for Physician Glucose Observation Sandia RTGM system dateTime 1..1 firstName Patient MonitoringDevice CellPhone 1.1 medicalRecordNumber serialNumber lastName manufacturer phone Number firstName dateOfManufacture operatingsystem dateOfBirth 1..1 1.1 0... osVersion firmware Version gender applicationVersion height 1..1 weight AlertCondition alertConditionID Alert endHour dateTime upperBound value(s lowerBound 1..1 When an alert is triggered, an object of type Alert Part 2 is created and associated with an alertCondition ob Based on what you learned in this chapter about ject. The dateTime attribute records when the Alert databases, controls, and system security, review your object was created and the value(s) attribute records answers to the questions for this case in Chapter 6 the glucose levels (alert types 1 and 2) or average level Assume that the patient's cell phone and the central- (alert type 3) that fell outside the specified range. Each ized servers are different nodes in a replicated data Alert object is indirectly related to a Patient object via base architecture and are regularly synchronized the association between Alert and AlertCondition and What changes, if any, should be made to your answers the association between AlertCondition and Patient now that you have a deeper understanding of data Develop a set of relational database tables based bases, controls, security, and related design issues on the domain class diagram. Identify all primary and foreign keys, and ensure that the tables are in 3NF

Explanation / Answer

Relational Database

Physician(id,lastName,firstName)

Patient(id,medicalRecordNumber,lastName,firstName,dateOfBirth,gender,race,height,weight,physicianId,glucoseObservationDateTime,cellPhoneId,alertConditionId)

MonitoringDevice(serialNumber,manufacturer,dateOfManufacture,firmwareVersion,patientId)

GlucoseObservation(dateTime,Level)

CellPhone(id,phoneNumber,operatingSystem,osVersion,applicationVersion)

AlertCondition(alertConditionID,type,startHour,endHour,upperBound,lowerBound,alertdateTime)

Alert(dateTime,values)

underlined are primary keys and italicised are foreign keys.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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