I have attempted to be comprehensive in the following, but important items may have been omitted by mistake. If you see such an omission, please let me know, but you are responsible for all of the lecture material to date. Be able to take a form and do a bottom-up design based on it. In particular, be able to describe what a cursor is and how it may be used.
Forms Be able to describe the steps involved in creating a master-detail form in Oracle.
Be able to describe what is necessary to create a master-detail form. Theory Be able to describe why a relational database is called relational. Be able in SQL expressions to identify conditions which would translate to join operations or to selection statements. You may be asked to do another forall or minus query in SQL by way of comparison. Queries will be either with respect to the SPJ database, or to the Hoh River College database.