COSC 30603: Database Systems

Dept. of Computer Science, TCU

Dr. Lisa Burnell Ball

Last update 08.23.09

Course Information & Materials

Database Links

---

Announcements

Office hours will be announced in class. Office is 334 TTC.
Exam dates are described in the syllabus. Homework due dates will be announced in class.

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