CPTR 319 Database Management Systems

• Syllabus
• Class Schedule (Watch for updates)
• Directory of Class files used in lectures

Slides and other resources

• Chapter 1 (Introduction Slides)
• Chapter 2: Export to SQL Sever and Access Files and SQL Server Backup
• Chapter 3 PPT Slides (Modified)
• Chapter 4 PPT and SQL Backup of file used in lecture. Normalization Exercise Answers
• Chapter 5 PPT Part 1, 2, 3, 4
• Chapter 6 Resources
• Exam 1 Review + Answers
• Chapter 7
  • Artist_Table.sql
  • Work_Table.sql
  • The Rest Of The Tables.sql
  • RE of Art Database.vsd (Visio file 2007)
• Chapter 11
  • Chapter 11 Notes.pdf
  • CH11_Lecture_SQL.zip
• Exam 2 Review
• Project Information: See my wiki for writing rules, templates and LaTeX tips.
• Chapter 13 XML & ADO.NET
  • Set of C# ADO.NET Tutorials
  • ADO.NET 3.5 on Microsoft
  • ASP.NET Developer Center
• Chapter 14
  • See JDBC Notes for SQL Server
• Final Exam Review

Older Materials

• Class Videos - I'll try to make classes available to those who are sick.