Topic: Procedure & Nested Query
Learning Module Objectives:
After completing the activities in this section, you should be able to:
Teach One Assignment
If you are supposed to teach about this section of the course, select one of the assignments, do the assignment and show it to the instructor to make sure you have done it correctly. Prepare your slides, narrate your slides, remove excess words from narrated slides, convert narrated slides to a file format that can be uploaded, upload your file, email everyone in the class the URL of your file. Make sure that all these tasks are done ahead of scheduled class session. Your peers will appreciate receiving your advice on how to solve a class assignment as soon as possible and well before last day prior to class session.
No individual assignment should be completed in teams. Submit your work in Blackboard. Do not discuss the work with other students.
Question Related to Procedures: The patient 457631 has been hospitalized at age 58.08 with the 5 diagnoses IV17.3, I401.9, I278.00, I786.05, I272.4, calculate what is the probability of this patient dying in the next 6 months. To do so, write a procedure code that calculates the likelihood ratios associated with any diagnosis. Repeatedly execute the procedure for the five diagnosis of the patient and estimate the likelihood ratios associated with this patient's death. Predicted the odds of mortality by multiplying the five likelihood ratios. Data►
Question Related to Nested Queries: Write a nested query that first finds the last visit by a patient and then reports their diagnoses during the last visit. Write the same code without using nested query. Report the difference in computational time in seconds Data►
Ongoing Question: This question is an individual project conducted from now till end of class. Each week a portion of the work is done. This week construct a model to predict if the patient has diabetes.
Copyright © Farrokh Alemi, Ph.D. First created on January 9th 2005. Most recent revision 07/12/2018. This page is part of the course on Healthcare Databases.