CS457 Syllabus & Progress

CS377 Syllabus & Progress


To save an example from a webpage, do the following in Netscape:
     Click File -> Save As
     Complete the file name in the "Selection" box
       (Make sure you specify the right directory name and file name !)
     Click OK when the file name is right


  1. Managing Information using Computers:


    Hand out Project 1: click here


  2. Data modeling using the Entity-Relationship model (Chapter 3)


    Hand out Homework 2: click here


  3. The Relational Data model (Chapter 5 in book)
    Hand out Homework 3: click here


  4. Relational Algebra


    Hand out Homework 4: click here


  5. (Tuple) Relational Calculus




  6. SQL - Structured Query Language







  7. Stored Procedures (in MySQL) (SKIPPED in Fall 2017 to save time for other stuff)




  8. Accessing MySQL with the C programming language (SKIPPED --- the prereq course CS171 does not cover C)




  9. JDBC: a Java library class for accessing Relational DBMS





  10. Java GUI programming





  11. Web Access of Dababases





  12. Database Design using decomposition to 3NF/BCNF



  13. Database Design using the synthesis algorithm to the 3NF






  14. Transaction Processing --- if time permits....


    Under construction...
  15. Concurrency Control (Chapter 18)
  16. Recovery (Chapter 19)
  17. Oracle Pro*C embedded SQL environment: click here