CS/SE 4347.HON: Database Systems (Spring 2013)
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
Return to Balaji Raghavachari's
home page.