SE 385 Home Page
SE 385 is an introduction to Database theory. It is closed for the year.
This course is complete for Fall of 2019.
The final exam will be on Tuesday, December 17 at 8:00.
Create a Transact SQL program. Due on Monday, 12/2.
Create a normalized schema. Due on Wednesday, 11/20.
Second Normalization Worksheet. Postponed to Friday, 11/15.
First Normalization Worksheet. Due on Wednesday, 11/6.
Fifth SQL Query Worksheet. Due on Friday, 10/25.
Creating the college database on your machine. Due on Monday, 10/21. This will require that you download the free Express version of SQL Server and then install. At the end of the install click on the Install SSMS button.
Fourth SQL Query Worksheet. Due on Wednesday, 10/16.
Third SQL Query Worksheet. Due Tuesday, 10/15.
Second SQL Query Worksheet. Due on Monday, 10/7.
ERD exercise. Due on Monday, September 30.
First SQL Query Worksheet. Due on Friday, 9/27. Be sure to follow all the instructions on the sheet.
Another relational algebra worksheet. Due Wednesday, September 18.
An exercise using RelaX. Due Friday, September 13.
The intent is to have the presentations available before the start of class.
They will be left here for some time after presentation. The introductory presentation has no testable material and is not posted.
Not yet covered.
No SQL databases.
Hadoop, an open source system for processing big data.
SQL security statements. Updated as of 11/20 to combine the two related presentations.
The final count and average of classes of balance demo from 11/15.
Microsoft's enhancements to SQL.
Below this will be on the third test.
Index Creation in SQL.
Schema refinement 3.
Schema refinement 2.
The disk manager.
Recovery of a DB.
Database concurrency considerations.
Everything below this will be on the second test, except the MakeMoo thing.
On 10/16 a very long demo of SQLServer Management Studio was recorded on Yuja.
The MakeMoo utility. This is what will keep you from typing in all of the college data.
The SQL Data Manipulation Language.
The SQL Data Definition Language.
Client server paradigm.
SQL Queries 3.
How Joins are done.
SQL Queries 2.
Entity relationship diagrams.
Introduction to SQL.
Everything below this will be on the first test.
Error Correction Codes.
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 and a page of help for the 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: December 23, 2019.