CSc 4710/6710, Database Systems
Spring 2008

---

• Class Bulletin Board (You need to sign up)
• Course Syllabus
• Laboratory Manual (to accompany Elmasri-Navathe text)
  
  
• EN: Chapters 1 and 2 Transparencies (Intro)
• EN: Chapter 3 Transparencies (ER)
• DBDesigner 4
• Dia (Diagramming Tool)
• EN: Chapter 5,6 Transparencies (Relational Model; Relational Algebra)
• EN: Chapter 4 Transparencies (EER)
• EN: Chapter 7 Transparencies (ER/EER to Relational Mapping)
• EN: Chapter 8 Transparencies (SQL)
• Sunderraman: Chapter 2 Transparencies (SQL)
• EN: Chapter 6 Transparencies (TRC, DRC, Datalog)
• company_create.html, company_insert.html, company_create_insert.html.
• JDBC, JDBC Scrollable ResultSets
  Oracle JDBC Driver
• Java Servlets (Oracle 9i Primer - Chapter 7)
• Servlet and JSP Tutorial
• Faculty Sign Up Web Application using Servlets
  
  
• Practice Exam - Exam 1 from Spring 2003
• Practice Exam - Exam 2
• FD Theory Notes
• Practice Problems - Exam 3
• Exam 3 - Take Home Part
  
  
• Home Work 1 (Due: Monday, 28 January, 2008) Solutions
• Home Work 2 (Due: Monday, 11 February, 2008) company.zip mailorder.zip Solutions
• Home Work 3 (Due: Wednesday, 20 February, 2008) Solutions
  
• Home Work 4 (Due: Monday, 10 March, 2008) Solutions
  Code to create tables and load data. For the homework you have to use create_mail.sql and insert_mail.sql. Please read Chapter 2 of the Oracle 10 Programming textbook for details on using the sqlplus program.
  
• Home Work 5 (Due: Friday, 21 March, 2008) Solutions
• Home Work 6 (Due: Monday, 31 March, 2008)
• Home Work 7 (Due: Monday, 7 March, 2008) Solutions

• Project Description