COSC 30603: Database Systems

Dept. of Computer Science, Texas Christian University

Dr. Lisa Ball

Last update 08.15.07

Course Information & Materials

Database Links

---

Announcements

Office hours will be announced in class. Office is 334 TTC; Crescent Lab for Intelligent Systems is M12 SWR (North Mezzanine level).
Email is the best way to reach me.
Exam dates are described in the syllabus. Homework due dates will be announced in class.

Please let me know if you have a link you think should be added or if a link is broken

Due to the possible large number of announcements, older announcements will appear at the bottom of this page. 

---

Course Information

• Syllabus
• Furniture DB Creation (example)
  
• Furniture DB (in Access)
  
• Sample Exams. These are old exams that may cover different material. They are offered to show you basic exam format and some sample questions. 
• Sample Exam #1 in MS Word
• Sample Exam #2 in MS Word
• Sample Exam #3 in MS Word
  
• Sample Final Exam in MS Word
• Older Lecture and Reference Notes (Powerpoint) in addition to those provided by your textbook author. 
• Lecture notes for 4th edition of the textbook
  
• Relational Algebra Notes in Powerpoint
• SQL Notes in Powerpoint
• Triggers - notes in Powerpoint
• PostgreSQL PL/pgSQL notes
  
• JDBC Lecture Notes
• PostgreSQL JDBC Lecture Notes
• PostgreSQL sample file   and   driver
  

Database Links

MySQL

POSTGRES

PostgreSQL

PostgreSQL : The most advanced Open Source database system in the world

The POSTGRES Rule Manager

The Implementation of POSTGRES

CMD | Command Prompt, Inc. | Practical PostgreSQL 

---

Previous Announcements