Data is not information, information is not knowledge, knowledge is not understanding, understanding is not wisdom.
 – Clifford Stoll, derived from Silicon Snake Oil: Second Thoughts on the Information Highway, 1996

  1. Chapter 5 (focus primarily on Sections 5.1–5.2)

    1. Who invented the relational data model? When and where did they do their work?

    2. Explain the following terms:
      1. relation

      2. attribute

      3. domain

      4. n-tuple

      5. NULL value

      6. primary, foreign, candidate and super keys

      7. referenced and referencing records

    3. Are tuples in a relation ordered? How about attribute values in a tuple? Explain why or why not.

    4. Can attributes have multiple values in a single n-tuple? Why or why not?

  2. Chapter 6 (focus primarily on Sections 6.1–6.2 & 6.4) — Make sure that you know how to:
    1. Create tables with specified constraints, including primary/foreign key, not-null, domain and value-check constraints.
    2. Use the DML commands: INSERT, DELETE and UPDATE.
    3. Distinguish the ON DELETE actions: SET NULL; CASCADE.

    Unit 1 assumed that you remember how to write basic queries (from CS 262). If necessary, review the basic queries in Section 6.3. The text covers standard SQL; for Oracle-specific SQL, see the Oracle SQL documentation linked from the policies page.