Search This Blog

Database Systems PPT SLIDES

Database Systems

INSTRUCTOR:

Arthur M. Keller

TEXTBOOK:

Required: Database Systems: The Complete Book, by Garcia-Molina, Ullman, and Widom (first edition), Prentice Hall, 0-13-031995-3, 2002. You may download the first two chapters if you are uncertain about taking the course. You may download Chapter 1 in Postscript or PDF and Chapter 2 in Postscript or PDF. Unless otherwise specified, all reading assignments will be from this textbook

Download lectures :

  1. Jan. 3 (TH) Intro, Entity-Relationship Model.
    Read Chapter 1 and Sections 2.1-2.2. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  2. Jan. 8 (T) Weak Entity Sets, Entity-Relationship Design.
    Read Sections 2.3-2.4. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  3. Jan. 10 (TH) Relational Model, Functional Dependencies.
    Read Sections 3.1-3.5. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  4. Jan. 15 (T) Normal Forms, Multivalued Dependencies.
    Read Sections 3.6-3.7. Assignment 1 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  5. Jan. 17 (TH) Relational Algebra.
    Read Chapter 5. Project Part 1 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  6. Jan. 22 (T) SQL Queries.
    Read Sections 6.1-6.2. Assignment 2 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  7. Jan. 24 (TH) Subqueries, Grouping and Aggregation.
    Read Sections 6.3-6.4. Project Part 2 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  8. Jan. 29 (T) Modifications, Schemas, Views.
    Read Sections 6.5-6.7. Assignment 3 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  9. Jan. 31 (TH) Constraints.
    Read Sections 7.1-7.3, 7.4.1. Project Part 3 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  10. Feb. 5 (T) Triggers, PL/SQL.
    Read Sections 7.4, 8.2. Assignment 4 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  11. Feb. 7 (TH) PL/SQL, Embedded SQL, CLI, JDBC.
    Read Sections 8.1, 8.3-8.5. Project Part 4 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  12. Feb. 12 (T) Advising Day. No class.
  13. Feb. 14 (TH) Midterm. (14% of course grade)
    Covers material through Feb. 7 (TH) lecture and readings (Chapters 1-3, 5-7, 8.1-8.5).
  14. Feb. 19 (T) Object-Relational Systems.
    Read Sections 4.5, 9.4-9.5. Assignment 5 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  15. Feb. 21 (TH) Transactions, Authorization.
    Read Sections 8.6-8.7. Project Part 5 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  16. Feb. 26 (T) Datalog.
    Read Sections 10.1-10.2. Assignment 6 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  17. Feb. 28 (TH) Datalog and SQL Recursion, ODL.
    Read Sections 10.3-10.4, 4.1-4.4. Project Part 6 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  18. Mar. 5 (T) More ODL, OQL.
    Read Sections 9.1. Assignment 7 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  19. Mar. 7 (TH)More OQL.
    Read Sections 9.2-9.3. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  20. Mar. 12 (T) Semistructured Data, XML, XQuery.
    Read Sections 4.6-4.7, Notes. Assignment 8 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.
  21. Mar. 14 (TH) Data Warehouses, Data Mining.
    Read Notes. Project Part 7 due. Slides in Powerpoint. Slides in Postscript. Slides in Adobe Acrobat.

Labels: