| Date: | Location: | Description: | Reading: | Overheads: |
| 28 January | Lecture in G225 | First Day Details, What is a database? Entity-Relationship (E/R) Diagrams. | Chapter 1, Sections 2.1-2 |
Academic Policy slides1.ps slides1.pdf |
| 30 January | Lecture in G225 | Design Issues: Subclasses, Keys, Weak Entity Sets in E/R Diagrams. | Sections 2.3-2.4 | slides2.ps slides2.pdf |
| 4 February | Lecture in G225 | Relational Model; Subclasses, Multiple Inheritance, Keys; Translating E/R Diagrams to RM; Functional Dependencies. | Sections 3.1-3.4 | slides3.ps slides3.pdf |
| 6 February | Lecture in G225 | Referential Constraints, Rules about Functional Dependencies,
Normal Forms. Quiz 0 due. |
Sections 3.5-3.6 | slides3.ps
slides3.pdf slides4.ps slides4.pdf |
| 11 February | Lecture in G225 | More on Normal Forms, Introduction to SQL. | Sections 3.6, 6.1 | slides4.ps
slides4.pdf slides6.ps slides6.pdf |
| 13 February | Lab in G219 |
Lab 1: Introduction to
Linux and SQL. Quiz 1 due. |
||
| 18 February | Lecture in G225 | Functional Dependencies and Normal Forms, Multivalued Dependencies. | Sections 3.5-3.7 | slides5.ps
slides5.pdf |
| 20 February | Lab in G219 | Lab 2: Using psql. Quiz 2 due. Project: Target Date for Project Design. |
||
| 25 February | Lecture in G225 | More on Dependencies, More on SQL: Subqueries, Aggregations, Duplicates. | Sections 3.7, 6.1-6.3 |
slides5.ps
slides5.pdf slides7.ps slides7.pdf |
| 27 February | Lab in G219 | Lab 3: Java and HTML
on Linux. Quiz 3 due. |
||
| 4 March | Lecture in G225 | More on SQL: Bags vs. Sets, DB Modification. | Sections 6.3-6.6 | slides8.ps slides8.pdf |
| 6 March | Lab in G219 | Lab 4: Duplicates and Aggregates, Query Statements (Command-line). Quiz 4 due. Project: Target Date for Project Schema, Dependencies. |
|
|
| 11 March | Lecture in G225 | Yet more on SQL: Indices, Schema Definitions, Views, NULL's, Outerjoins, Constraints. | Chapters 1-3, 6 | slides8.ps
slides8.pdf slides9.ps slides9.pdf |
| 13 March | Lab in G219 | Lab 5: Database Modification (Command-line) & Perl. Quiz 5 due. Project: Target Date for Initial Webpage. |
||
| 18 March | Lecture in G225 | JDBC: Embedding SQL in Java; Review for Exam 1. | Section 8.5 | slides11.ps slides11.pdf |
| 20 March | Lab in G219 | Lab 6: Data Types in PostgreSQL Quiz 6 due. Project: Target Date for Database Creation. |
||
| 25 March | Exam in G225 |
Midterm Exam 1 |
Chapters 1-3,6 |
|
| 27 March | Lab in G219 | Lab 7: SQL in Java, Using JDBC (JDBC Update statements). | ||
| 1 April | Lecture in G225 | Object Oriented Design: ODL, Translating ODL to RM; Discuss Exam 1. | Sections 4.1-4.4 |
slides15.ps slides15.pdf slides16.ps slides16.pdf
|
| 3 April | Lab in G219 | Lab 8: Filtering and
Formatting Data Quiz 7 due. |
||
| 8 April | Lecture in G225 | More on ODL, Semistructured Data, XML and its Data Model, Relational Algebra. | Sections 4.6-4.7 and 5.1-5.3 Sections 5.4-5.5 |
slides18.ps slides18.pdf slides5.ps
slides5.pdf |
| 10 April | Lab in G219 | Lab 9: Indices and Views. Quiz 8 due. Project: Target Date for Populating the Database. |
||
| 15 April | Classes follow Wednesday schedule |
|||
| 17 April | Spring Break: No classes |
|||
| 22 April | Spring Break: No classes | |||
| 24 April | Spring Break: No classes | |||
| 29 April | Lecture in G225 | More on Relational Algebra and SQL, Constraints and Triggers, System Aspects of SQL, Transactions in Java |
Chapter 5, Sections 7.1-7.4, Chapter 8 |
slides10.ps
slides10.pdf slides13.ps slides13.pdf |
| 1 May | Lab in G219 |
Open Lab Session. Quiz 9 due. Project: Target Date for Simple GUI. |
||
| 6 May | Lecture in G225 | More on Transactions, Datalog, Recursion | Chapters 8,10 | slides14.ps slides14.pdf |
| 8 May | Lab in G219 |
Lab 10: System Aspects of SQL: Privileges Quiz 10 due. Project: Target Date for Queries and Views in GUI. |
||
| 13 May | Lecture in G225 | More on Recursion, Review | Chapters 1-8,10 | slides15.ps slides15.pdf |
| 15 May | Lab in G219 | Project: Final Project due. | ||
| 22 May |
Exam in G225 | Final Exam |