CS 623
Database management systems
Quick
Links
| Lectures | Sections in book | ||
|---|---|---|---|
| Num/Name | PPT | Readings | |
| Presentation of the course | |||
| 1 - Introduction | PPT | Chapter 1 | |
| 2 - A closer look | PPT | Chapter 2 | |
| 3 - Foundations (sets, relations...) | 4PDF | Chapter 2 | |
| 4 - Entity relationship model | PPT | 4PDF | Chapter 5 |
| 5 - Relational data model | PPT | 4PDF | Chapter 4 |
| 6 - Relational algebra and SQL | PPT | 4PDF | Chapter 6 |
| 7 - Relational normalization theory | PPT | 4PDF | Chapter 8 |
- Chapter 1 - Exercises 1.1, 1.4, 1.10 and 1.11
- Chapter 2
- Chapter 5 - Given ERD design exercises and exercises 5.1, 5.2 and 5.8
- Chapter 4 - Definitions 4.3, 4.4 and exercises 4.7
- Chapter 6 - Exercises 6.8, 6.9, 6.12, 6.15 and 6.17
- Chapter 8 - Exercises 8.4, 8.7 and 8.16
- Database and Transaction Processing: An Application-Oriented Approach - Philip M. Lewis, Arthur Bernstein, Michael Kifer (Addison-Wesley)
- Database Management Systems - Ramakrishnan (McGraw-Hill) Fundamentals of Database Management Systems - Elmasri and Navathe (Addison Wesley)
- UNIX
- JDBC
- JDBC on matrix - JDBCVersion.java (test the version of your JDBC driver) and JdbcCheckup.java (test your connection to the database management system and create a table) - You have to update the files with the right name for the database, your sqlplus login and your sqlplus password.
- Sunsoft JDBC Homepage
- JDBC Enhancements
- The JDBC Specification
- JavaSoft's JDBC API specification
- Servlets
- Servlets on matrix - Creation.java (Servlet to create a table) -
Insertion.java (Servlet to insert an element in a table) -
Selection.java (Servlet to do a select on a table) - You have to update the files with the right name for the database, your sqlplus login and your sqlplus password.
- Servlets on matrix - Creation.java (Servlet to create a table) -
Insertion.java (Servlet to insert an element in a table) -
Selection.java (Servlet to do a select on a table) - You have to update the files with the right name for the database, your sqlplus login and your sqlplus password.