CS1106: Lecture Session
Lecture 3.1: Relation Schema in SQL
Wednesday 5 October 2011
The learning objectives of this lecture are: to ensure that students can define, modify or remove a
relation scheme in SQL using the CREATE TABLE statement; to ensure that students can define the key of a relation in SQL; to ensure that students can add tuples of data to a relation using the INSERT INTO statement.
Slides: Available here in PDF format.
Please ask questions in class. If there is anything you don’t understand, ask. Make sure that you study the material from each lecture before attending the next.
If you feel you’re falling behind please be sure to meet with Prof. O’Sullivan as soon as possible.
