SE 385 Home Page
SE 385 is an introduction to Database theory. It is closed for the year.
No class on Friday, October 1. You should have a SQL Query assignment.
The first exam is scheduled for Wednesday, September 15.
The final exam is scheduled for Tuesday, December 14 at 8:00.
Second SQL Query Worksheet. Due on Wednesday, 9/29.
An exercise using RelaX. RelaX is a Relational Algebra calculator. Due Friday, September 10.
First SQL Query Worksheet. Due on Monday, September 20 - postponed because of the test. Be sure to follow all the instructions on the sheet.
The intent is to have the presentations available before the start of class.
They will be left here for some time after presentation.
Not yet finished.
Entity relationship diagrams.
SQL Queries 2.
Error Correction Codes.
Introduction to SQL.
A handout with examples of relational algebra operators. Not an assignment, you do not need to turn in.
The functions a database should provide.
The relational model.
History of database.
Fundamentals of Database Systems by Elmasri and Navathe.
Important documents overviewing the course:
The syllabus for SE 385 or the ADA friendly syllabus for SE 385.
Files and handouts
A description of the sample schemas for the college database (Word format). We will use this both for examples and exercises. Revised 9/11.
The SQL test page.
Download the free Express version of SQL Server. Download and then install. During the install you should also be able to install the SSMS, which you will need.
A Relational Algebra calculator.
The SQL test page.
Source code for another Relational Algebra calculator.
A free online drawing tool.
Articles of interest
SQL Injection Attacks.
SQL misconceptions illuminated.
The shrinking SQL NoSQL divide.
A ranking of popularity of data base engines.
How to fake database design.
First things to look for on a SQLServer implementation.
Survey of ACID implementation in common databases
Jim Gray's Data Management History This predates and foresees the NOSQL movement.
12 years of CAP
Other links of interest
Banks are BASE and not ACID.
Feeling lucky? Download the free version of DB2.
Also of interest. Download the free version of Oracle 11.
DataBase Adminstrator Jokes.
Return to Curt Hill's home page.
Last time I updated this page: September 20, 2021.