In-class notes for 04/22/2020

CS 284 (MCA), Spring 2020

• Project ideas - results

  • RAB comments - see also video comments, which are more complete

  Next step: vote on your favorite ideas

  • Note: I will update this form with any further or clarified project ideas received by 5pm today
    (updated form will be available by 5:30)

  Results of voting presented on Friday

• Quiz Friday - topics

Quiz 5 topics - SQL

Worksheets and homework included in this quiz:

• Worksheet 15, Worksheet 16, Worksheet 17
  (See also review questions/sample quiz questions in today's Worksheet 18)

• Homework 9 parts B,C (only); Homework 10

Topics

• SQL and databases

  • Notions of relational databases:

    • Database terminology as appearing in homework/worksheets and in class

    • tables, properties of columns

    • data definition (e.g., CREATE TABLE)

    • data manipulation (e.g., INSERT)

    • queries (e.g., SELECT)

  • SQL as appearing in homework/worksheets and in class

  • Formulating queries, including relational joins

• Review problems: Worksheet 18

  • Note: there will be fewer questions than this.

• Note: Time limited quiz (likely shorter than the previous quiz)

< >