The rest of these notes are going to look messed up. Yeah, sorry but if you want the full version, you can find the OneNote package here. The notes being posted here are just to help search through the notebook without having to download it first. (more…)

As with all the other notes, the full package is available here. Otherwise, the rest of this article includes the first set of notes which cover the Basic Concepts of Database Systems and include some of the definitions that were likely to show up on the first exam. These are word for word of what Dr. Uckan wrote on the board. (more…)

For this course it is best to be able to take notes in some sort of graphic utility in order to draw all the pictures he puts up on the board. Of course, if you’re not used to such a program, then obviously a good ol piece of pen and paper will do just fine too. However, I take all my notes in Microsoft’s OneNote™. If you want a copy of these notes, you can get them here. Otherwise I’ll make several posts of these notes as I upload them.

The topics however will be as follows:
- Basic Concepts of Database Systems
- Databases
- Design of a Simple Database
- Identifying Identities and Relationships
- The Entity-Relationship Database Model
- Integrity Constraints
- Quantifiers in Predicate Calculus
- Views in Relational Systems
- Deductive Databases
- Deductive View
- Relational Database Design
- File Structures

One of the curses of the CSA department is the infamous Database Systems course- CSA 385. Taught by, and only taught by, Dr. Yuksel Uckan, this class is the absolute definition of hell. As of taking this class this semester, I am proud to say that my extensive knowledge and experience of utilizing databases in a web and business environment was absolutely useless. (more…)

CSA 385 Notes. More basic database concepts and definitions. (more…)

We were given sample exams to study from which differed quite a bit from our actual midterm and final. The midterm exam is included but the final is not. (more…)

Handouts and solutions… (more…)

Here are the exercises and their solutions. Be mindful that this is for educational purposes only. I am not including these that, if for some reason they should be reused in future courses, that they may be freely copied and distributed. (more…)

Along with the rest of the course documents for CSA 278, here are the powerpoint lectures. (more…)

I’ve uploaded all the assignments we had for Computer Architecture (CSA 278). They are available on my public server as well: Assignments. Continue reading this article for brief descriptions of each assignment. (more…)