===== CS 325 - Week 13 Labs - 2021-11-19 ===== ===== TODAY WE WILL ===== * Announcements/prep for next class * prep for lab exercise * Week 13 Lab Exercise * Project Design Draft milestone is due by 11:59 pm TONIGHT, November 19th * The Project POPULATION milestone (now actually creating and adding some example/initial population to your project tables) is due by 11:59 pm Sunday, December 5th * watch for class emails as parts of Homework 10 become available (due 11:59 p, on Friday, December 3rd) * if you have not registered yet for Spring 2022 -- please do so as soon as possible! * Reading for after break: * DB Reading packet 10 - Transaction management, part 2 * SQL Reading Packet 8 - Simple reports, part 1 and 2 ===== FUN THING! ===== * One of the 9am lab teams, Sarah Jimenez, Kay Vargas, Gina Iskander, and Yomy Chavez, actually looked up the Oracle Documentation (hooray!) and found out how to change the label for the operation when using the SQL*Plus compute command: after the operation, put keyword label followed by the desired label (in quotes if its contains spaces or punctuation) -- for example: compute avg label 'Dept Avg' of salary on dept_num Reference: https://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve014.htm#SQPUG035