Instructor: Jing Gong. Class Time: M/W/F 2:00-2:50 pm

Agenda for Week 4 (Week of 9/18)

Dear all,

Below is the agenda for Week 4.

Class Schedule:

  • Monday — We will work on In-Class Activity (ICA) #3 – Converting ERDs to schemas. It is due by Wednesday (9/20).
  • Wednesday — We will start a new module  –  “SQL 1: Getting data out of a database.”
    • Make sure that you have MySQL Workbench installed on your own computer;
    • Also, review the supplementary slides “MySQL and Workbench” on your own, before class.
  • Friday — We will work on ICA #4 (SQL Pen and Paper Query Exercise). It is due by Monday, 9/25.

Deadlines (unless otherwise mentioned, the due time is 11:59 pm):

  • Assignments
    • Assignment #1 – ER Modeling: Monday, 9/18.
    • I will post a bonus assignment on converting ERDs to Schemas, it will be due on Monday 9/25.
  • ICAs:
    • ICA #3 – Converting ERDs to schemas: Wednesday, 9/20.
    • ICA #4 – SQL Pen and Paper Query Exercise: Monday, 9/25.

Best,
Jing

Leave a Reply