Week 5 - I/O, data management & More

Learning objectives

• Data management SQL statement

Lecture notes:

Monday

• lecture-notes-05-mon.txt

• class-script-05-mon-1.txt

• slides triggers

• class-script-05-mon-2.txt

Wednesday

• Advanced topics:
  • Slides
• Bash programming:
  • Bash essentials

Data:

• Class data GitHub repository, week 3 – for Monday

Resources

1. Jeffrey D. Ullman and Jennifer Widom (2008). A First Course in Database Systems. 3rd ed. Upper Saddle River, NJ: Pearson/Prentice Hall.
   Access via Library Catalog

   • Complete but theoretical introduction to relational databases, data modeling, and relational algebra.

Homework

Protect yourself

Create a trigger

Bash essentials

Create a test harness