Click on the Class News Link below for updates: assignments, answers to email questions, etc.
Emailed questions and their answers will be posted here. If you send an email question, the answer will be (1) sent to you and (2) posted. If you ask a question which has already been posted, you will be sent email telling you to consult the webpage Class News Link.
In the first part we look at relational algebra and the standard query language SQL. We will run some SQL queries on sqlplus on Oracle. The first and second programming assignment use Oracle for SQL. SQL is the same in any relational DBMS. There is an ANSI standard for SQL. We will discuss security in database systems and do triggers, User-Defined Functions (UDFs), views, and stored procedures.
In the second part we will look at Entity-Relationship diagrams and their corresponding relational tables and foreign keys. These topics are important for the logical design of an enterprise database.
In the third part, we will investigate using embedded SQL (SQLJ) and web programming for databases. Most application programs do this.
| May 4 | Chapters 1-2 | Introduction and Database Notations |
| May 5, 6, 10, 11 | Chapter 4.2 | Relational Algebra |
| May 12, 13 | Chapter 5 | Simple SQL |
| May 17 (Monday) | 1st quiz | Quiz on Relational Algebra |
| May 18, 19, 20 | Chapter 5, Chapter 3.6, Chapter 21.3 | SQL and views, grant 1st assignment on SQL |
| May 24, 25, 26, June 1 | Chapter 5.8, Chapt 6.5 | stored procedures, triggers and UDFs 2nd assignment on Triggers, stored procedures and UDFs |
| May 25 (Tuesday) | 1st assignment due | 1st |
| May 27 (thursday) | Midterm | Midterm on Relational Algebra and SQL |
| May 31 | Memorial Day | NU closed |
| June 2 | Embedded SQL | Embedded SQL: SQLJ 4th assignment on SQLJ |
| June 7 (Monday) | 2nd assignment due | 2nd |
| June 3, 7, 8 | Chapter 2, 3.5 | Entity-Relationship |
| June 14 (Monday) | 3rd assignment due | 3rd |
| June 9, 10, 14 | Web database, JSP | 4th assignment on Web database |
| June 15 (Tuesday) | 2nd quiz | Quiz on ER |
| June 16 | web assignment discussion | Using JSP |
| June 17 | Review, catch-up | Review for exam |
| June 21 | Final Exam | Exam on stored proceduere, triggers, SQLJ, and ER |
| June 22 (Tuesday) | 4th assignment due | 4th |
You must obtain at least a C average on the exams and quizzes (weighted as in the final grade) to obtain a C or above in the course. Also, failing grades on the in-class exams will mean a failing grade in the course, regardless of the programming homework.