IOE 373 Lecture Notes - Lecture 94: Dexter Morgan, Addison Montgomery, Oncology
Document Summary
Ioe 373 fall 2015 lab 4 (solutions) Insert: the hospital is now offering a brain surgery that costs ,500 and takes 80 minutes to complete. Add the new surgery to the proceduretypes table. Insert into proceduretypes ( procedureid, procedurename, estimatedtime, cost, Values(6, "brainsurgery", 80, 1500, "moderate"): we have just employed dr. addison montgomery. She is the hospital"s new oncologist, her specialty is cancertreatment. Add her to both employees table and doctors table (you will need two separate insert queries) Insert into employees ( id, firstname, lastname, yearsofexperience, Select 13 as expr1, "addison" as expr2, "montgomery" as expr3, 5 as expr4, "yes" as. Insert into doctors ( doctorid, firstname, lastname, yearsexperience, specialty ) Select 13 as expr1, "addison" as expr2, "montgomery" as expr3, 5 as expr4, Delete: dr. dexter morgan has been charged with first-degree murder. Delete him from our doctors table and update his employment status to no .