CS 4347: Database Systems (Spring 2012)

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

Announcements

 
* 05/04: Time for project demo: May 7 - May 10 (Mon-Thu): 1:00 PM - 4:30 PM.
         No appointment needed.

* 05/02: Topics for Final exam on Wed, May 9 (5:00-7:00 PM, ECSN 2.120):
         Relational model, Normal forms and algorithms for normal forms,
         Storage organization and index files, Query optimization,
         Transaction processing, Recovery, Security issues, Data mining.
         Test has 2 parts.  Part 1 (closed book/notes) has short questions.
         Part 2 (open book/notes) has exercises and problems.

* 04/19: Assignment 4 (due Wed, 4/30).

* 04/04: Assignment 3 (due Wed, 4/11).

* 04/02: Project description (only for those who have not chosen a special project).
         Sample PHP search application, PHP tutorial, PHP MDB2 tutorial

* 02/15: Assignment 2 (due Mon, 3/5).
         Files for HW2: List of Courses, List of CLOs, Sample assessment form.

* 02/14: ER design examples to be discussed in class on Feb 15

* 02/08: Examples discussed in class on Feb 8:
	 PHP Hello world (src)
	 Log in page allowing SQL injection attack (Perl code inject.pl that processes form)
	 Log in page that uses prepared query to avoid SQL injection (Perl code prepared.pl)
	 PHP example allowing HTML injection attack (src)

	 Some on-line PHP resources: www.php.net, PHP-MySQL manual
         PHP tutorials: www.w3schools.com/php, php.net/manual/en/tutorial.php

	 Perl language reference

         DoD's security guides: Databases, SQL server, Oracle
         Wikipedia page on UI design principles
         User Interface Design, SSW's rules to better ...

* 02/07: SQL programming example with Perl, PHP (will not work from outside UTD without VPN).

* 02/01: Assignment 1 (due Wed, 2/15).

* 01/25: The class room for CS/SE 4347: Database systems (MW 5:30-6:45)
         has been changed to ECSN 2.126  [ECS North building] from today.