Lecture 24

For today you should:

1) Read the Wikipedia article on relational databases and then go through this tutorial up to, but not including, the section called "Prepared Statements".

2) Work on that project! (next milestone: draft report April 30)

Today:

1) SQL!

For next time

1) No Tuesday = no quiz!

2) Read about NoSQL

3) Project!

Reminder about professional conduct

1) Several teams did not send reports on schedule AND did not notify us AND did not reply promptly when queried.

2) We understand that not every project proceeds on schedule and we are willing to make accommodations, but you have to communicate with us.

3) If you need help, ask. If you need time, communicate. Radio silence does not make things better!

Don't be a weasel!

SQL

The timing of this lecture is fortuitous, since the recently-announced Turing Award is for work in relational databases.

To get started clone the following repository:

$ git clone https://github.com/paulruvolo/DatabaseTutorials.git

Requirements for Relational Databases: http://en.wikipedia.org/wiki/ACID