SE 385 Home Page

SE 385 is an introduction to Database theory. It is closed for the year.

Tests:


The final exam will be on Thursday, December 17 at 8:00.

The assignments


Create a Transact SQL program. Due on Monday, 12/7.
Create a normalized schema. Due on Friday, 11/20.Sample data. Even though there is sample data, you do not need to create the tables and load it, just design the tables.
Second Normalization Worksheet. Due Monday, 11/16.
First Normalization Worksheet. Due on Monday, 11/9.
Creating the college database on your machine. Due on Friday, 10/30. ***Postponed*** 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.
Fifth SQL Query Worksheet. Due on Monday, 11/2. ***Postponed*** You must do the above first.
Fourth SQL Query Worksheet. Due on Wednesday, 10/28. ***Postponed***
Third SQL Query Worksheet. Due Monday, 10/19.
A BTree worksheet. Due on Wednesday, 10/7.
ERD exercise. Due on Monday, 10/5.
Second SQL Query Worksheet. Due on Friday, 10/2.
First SQL Query Worksheet. Due on Friday, September 25. Be sure to follow all the instructions on the sheet.
Second relational algebra worksheet. Due Friday, September 18. You will need the college database schema for this.
An exercise using RelaX. RelaX is a Relational Algebra calculator. Due Monday, September 14.
The first assignment. Due Friday, September 4.

Presentations

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.
Big Data.
Hadoop, an open source system for processing big data.
SQL security statements. Updated as of 11/20 to combine the two related presentations.
Database concurrency considerations.
Distributed Databases.
Completed.
The final trigger demo.
Data mining.
Triggers.
Data warehouse.
No SQL databases.
The years worked to age ratio Transact program and the corresponding stored procedure.
Stored Procedures.
The Transact demo on zero, low and high balance students.
The Transact demo on credit hours per year.
Microsoft's enhancements to SQL.
Everything below this will be on the third test.
A handout on normal forms.
Index Creation in SQL.
Query Evaluation.
Schema refinement.
Schema refinement 2.
Schema refinement 3.
The disk manager.
Transaction Management.
Recovery of a DB.
Everything below this will be on the second test.
The SQL Data Definition Language.
The MakeMoo utility. This is what will keep you from typing in all of the college data.
The SQL Data Manipulation Language.
Client server paradigm.
Hash Indices.
How Joins are done.
SQL Join.
Hashing.
SQL Queries 3. Corrected
BTrees.
Entity relationship diagrams.
SQL Queries 2.
Error Correction Codes.
RAID.
SQL Queries.
Introduction to SQL.
Everything below this will be on the first test.
System catalog.
Relational calculus.
Relational algebra.
A handout with examples of relational algebra operators. Not an assignment, you do not need to turn in.
Database models.
The relational model.
The functions a database should provide.
History of database.
File organizations.

Textbook

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.

Software

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 links

Return to Curt Hill's home page.

Last time I updated this page: December 9, 2020.