Method signatures

Method signatures define/describe:

  • the name/identifier of the method
  • the parameters of the method (identifier and data type)
  • the return type of the method eg void or int etc

Objectives

Students will be able to:

  • review SQL, including JOINS and WILDCARDS
  • appreciate VIEWS (virtual and materialized (snapshot))

Re-VIEW

Review

How much do you remember about:

  • ERD Diagrams
  • Composite Keys
  • SQL, including JOINS and WILDCARDS

Task

This task will give you a review opportunity to check your recall/understanding of the above concepts.

For HL students it will also include the concept of VIEWS.

Worksheet Task

Complete the worksheet:

Tags

ACIDpessimistic locking atomicity consistency isolation TCL durabilityDDL DMLCREATE ALTERUPDATE INSERT INTOBEGIN TRANSACTION COMMITROLLBACK