Database Administration

Comp 305-001/488-003

Spring 2014: Tuesdays, 4:15-6:45, LT 410

Text: Elmasri & Navathe, Fundamentals of Database Systems 6e, Pearson 2010, ISBN-10: 0136086209, ISBN-13:  9780136086208

There will be some homework assignments during the semester, plus a midterm and final. The assignments will be worth about 15-20% of your grade, the midterm 30-35%, and the final about 50%. The midterm is set for March 11; the final will be Tuesday, April 29, at our usual time.

My general course groundrules are here.


Here's where to get MySQL Community Server, an open-source database. The current version is 5.6.15, although earlier versions will almost certainly work as well. I also recommend downloading the reference manual. (Note that Oracle, through its purchase of Sun, now owns the commercial part of MySQL.) I believe you do not have to create an account to download MySQL, though they ask you to.

If you wish, here is where to get Oracle Database 12c Release 1 (standard edition). You may have to create a free account before you can download, and to do that you must sign up for at least one mailing list (you can cancel later). (Maybe this has changed?)

We will also use Postgresql in class, at postgresql.org, in some class examples.

Further installation information is here (for MySQL and Oracle)


The midterm study guide is here. There is now a link to the solutions within the study guide.

The final exam study guide is here. Solutions will be available by Sunday April 27.

Class notes and readings:

Week 1, Jan 14
Week 2, Jan 21        contains homework 1
Week 3, Jan 28
Week 4, Feb 4         contains homework 2
Week 5, Feb 11
Week 6, Feb 18
Week 7, Feb 25
Spring break
Week 8, Mar 11: midterm exam
Week 9, Mar 18
Week 10, Mar 25
Week 11, Apr 1
Week 12, Apr 8
Week 13, Apr 15
Week 14, Apr 22

Examples


The company database (spreadsheet, files). To load this into MySQL, the two main files are the table definitions and the data-insertion commands. You can paste these in, or use the source command in MySQL.

The university database (E&N p 8, Fig 1.2) is here: student.text. I added three additional students, and their grades. You should be able to paste this in to MySQL.


We will consider some of the following topics: