CS/SE 4347.HON: Database Systems (Spring 2013)

Course Syllabus   Class log   Table of contents of 6th ed text  

Announcements

 
5/2: Notes from class on 5/2

     Instructions for final exam

4/26: Case studies for discussion on 4/30

4/18: Assignment 5 (due Thu, May 2).

4/16: Notes on transaction processing

4/05: Assignment 4 (due Thu, Apr 18).

4/01: Topics for exam 1 (Thu, Apr 4): Sec 10.1-2, 15.1-4, 16.1-3, 13.1-3.
	Database design process (10.2), Design theory, normal forms, 
	algorithms for 2NF/3NF/BCNF, Minimal covers.
	Short questions on SQL programming (Ch 13), SQL injection.
	No programming questions.

3/22: Assignment 3 (due Thu, Apr 2).

3/20: Class notes for lecture on March 7
      Problems for discussion in class on 3/21

3/06: Django Framework Presentation (ppt)
      Sample Django application (RAR file)

3/01: Project (due Thu, 3/28)

2/28: Notes on SQL programming (thanks to Christian S. Jensen)

2/26: Some on-line PHP resources: www.php.net, PHP-MySQL manual
         PHP tutorials: www.w3schools.com/php, php.net/manual/en/tutorial.php
         PHP Quick reference sheet (thanks to dreamincode.net)
	 Perl language reference,

         PHP/Perl demo (accessible only from UTD sites or with UTD VPN)

2/20: Book store project (PHP/MySQL): Zip file
      Topics for exam 1 (Thu, Feb 21): Chapters 1-8.
	  Introduction, Relational model, Queries (Relational Algebra, SQL),
	  ER/EER modeling.

2/14: Notes on EER/Mapping

2/08: Assignment 2 (due Thu, Feb 21).

2/1:  ER Design problems (for discussion in class on 2/5 and 2/7)

1/29: Assignment 1 (due Thu, Feb 7).

1/24: SQL queries for query worksheet (to access from outside UTD, use UTD VPN)

      MySQL files for Company database

1/22: Query worksheet (relational algebra and SQL)

1/16: Read chapters 1-2