CSC 5-415 Database Management Systems

OBJECTIVES OF THE COURSE:
  1. The background and history of database management systems
  2. The fundamentals of using a database management systems
  3. Industry standards used for database management systems
  4. Theoretical background of the relational model
  5. Queries and Updates
  6. Transactions and Security
  7. Logical, object-oriented, object-relational, semi-structured and XML database systems.
  8. Data warehouses and data mining.

CLASS SCHEDULE:

Note: This schedule is tentative and therefore is subject to change.
***  Slides are adaptions of and  courtesy of:   1         Text Connolly Begg Addison Wesley Longman
                                                                             2 - 6    Jeff Ullman, Stanford University
                                                                             7 - 12   SQL Essentials, Jones and Bartlett
                                                                             13 - 25 Arthur Keller, Univ. California Santa Cruz
           All Readings are from  Database Systems  Connolly and Begg 4/e                       
  1. Sep. 7 (W) Introduction to Database Management Systems.                                                                                                                                 Read Chapters 1 and 2 3 Slides in Powerpoint.
  2. Sep. 12 (M) Intro, Entity-Relationship Model.
    Read Chapter 11  Slides in Powerpoint. 
  3. Sep. 14 (W) Weak Entity Sets, Entity-Relationship Design.
    Read Chapter 12 . Slides in Powerpoint. 
  4. Sep. 19 (M) Functional Dependencies                                                                                                                                                                        Read  Chapter Sections 13.1-13.4. Slides in Powerpoint. 
  5. Sep. 21 (W) Normal Forms, Multivalued Dependencies.                                                                                                                                          Read Chapter Sections 13.5-13.9 . Assignment 1 due. Slides in Powerpoint. 
  6. Sep. 26 (M) Relational Algebra.                                                                                                                                                                                  Read Chapter 4. Project Part 1 due. Slides in Powerpoint. 
  7. Sep. 28 (W) SQL Queries.
    Read Sections 5.1-5.2. Assignment 2 due. Slides in Powerpoint. 
  8. Oct. 3   (M)  More SQL                                                                                                                                                                                               Read Chapter Chapter Section 5.3. Assignment 3 due. Slides in Powerpoint. 
  9. Oct. 5 (W)   More SQL                                                                                                                                                                                               Read Chapter 8. Assignment 4 due. Slides in Powerpoint.
  10. Oct. 10 (M) Fall Recess
  11. Oct. 12 (W)   More SQL                                                                                                                                                                                              Read Chapter Sections 6.1-6.3. Assignment 5 due. Slides in Powerpoint.  
  12. Oct. 17 (M)   More SQL                                                                                                                                                                                               Read Chapter Sections 6.4-6.6. Assignment 6 due. Slides in Powerpoint.
  13. Oct.  19 (W) Midterm Exam
  14. Oct. 24  (M) Constraints.                                                                                                                                                                                             Read  6.2 and 8.1.4-8.1.5. Project Part 3 due. Slides in Powerpoint.
  15. Oct. 26(W) Triggers,PL/SQL.                                                                                                                                                                                     Read Chapter Section 8.2.7, 28.4.12.  Assignment  7 due. Slides in Powerpoint. 
  16. Oct. 31(M) PL/SQL, Embedded SQL, CLI, JDBC.
    Read Sections 8.2.4, E.1.4-E.1.5. Project Part 4 due. Slides in Powerpoint.
  17. Nov. 2 (W) Object-Relational Systems.
    Read Chapter 28. Assignment 8 due. Slides in Powerpoint. 
  18. Nov. 7 (M) Transactions, Authorization.
    Read Chapters 19, 20. Project Part 5 due. Slides in Powerpoint. 
  19. Nov. 9 (W) Datalog.                                                                                                                                                                                                    Read Sections 10.1-10.2. Assignment 9 due. Slides in Powerpoint. 
  20. Nov 14 (M) Datalog and SQL Recursion, ODL.
    Read Chapter 26. Project Part 6 due. Slides in Powerpoint.
  21. Nov. 16 (W) More ODL, OQL.                                                                                                                                                                                   Read Chapter 27 Assignment 10 due. Slides in Powerpoint. 
  22. Nov. 21 (M)More OQL.                                                                                                                                                                                             Read Chapter 27 (continued). Slides in Powerpoint.
  23. Nov 23 -27 Thanksgiving  
  24. Nov. 28 (M) Semistructured Data, XML,Query.                                                                                                                                                     Read Chapter 30. Assignment 11 due. Slides in Powerpoint.  
  25. Nov  30 (W) Data Warehouses, Data Mining.
    Read Chapter 31, 34. Project Part 7 due. Slides in Powerpoint
  26. Dec. 5  (M) Catch up
  27. Dec  7  (W) Catch up
  28. Dec. 12 (M) Final Exam 2-4 pm