Database Management (COP-4540)
Spring 2010
Announcements
· Final will be Tue 4/20 12-2pm.
· Amanda will be having office hours in ECS 232 on Tuesdays from 2:30 - 4:30pm.
|
Midterm |
project phase I |
project phase II |
|
|
Median |
64 |
44.5 |
|
|
Min |
30 |
40.5 |
|
|
Max |
91 |
50 |
|
· Instructions to connect to mysql from tomcat.
·
MySQL account ready:
Server: ocelot.aul.fiu.edu
Username: spr10_username
Database name: spr10_username
Password: the student's Panther ID
· Version 5.5 of MySQL does not enforce constraints (http://dev.mysql.com/doc/refman/5.5/en/alter-table.html
· Create all your tables with the option ENGINE=INNODB. For example, create table test (id integer) ENGINE=INNODB. The reason is that in MySQL foreign key constraints are only enforced when you create the table with this option
· Note that the MySQL accounts are different from your UNIX accounts that you need to connect to the school computers. Your UNIX login is your regular FIU username, and <first initial><pantherid><last initial> for your password, if you haven't used it yet. You can log into margay from outside of campus, but you must use ssh.
· When building the E-R diagram for the project, don’t use the E-R package of Visio since it uses different notation.
· Midterm and final have closed books. A single-sheet cheat sheet is allowed.
· Welcome to the COP-4540 web page!
General Info
Instructor: Vagelis Hristidis
Lecture time: Tue/Thu 12:30 -13:45 pm
Location: ECS 235
Office hours: Tuesday 11-12:30 pm
Teaching Assistant: Amanda Crick kuzuye_bb@hotmail.com
TA Office hour: ECS232 on Tuesdays from 2:30 - 4:30pm
Grading
30% midterm
40% final
30% project
Late submissions, submitted before assignments are graded and returned, will receive a 20% score reduction.
Course Description
This course that introduces the principles of database management systems. After the students successfully finish this course, they should have a better understanding on different aspects of a database management system. They should also be familiar with relational model, SQL, storage and indexing, query evaluation, transaction management, and some selected topics.
The class involves a project of accessing a database through a web application. In particular, the technologies that we will use are:
- JSP to write dynamic web
pages
- JDBC to connect to the
database system
- MySQL as the database
system
Prior
knowledge of these technologies is not required as learning materials will be
provided.
Some of the topics presented will be:
- Database Design with ER model
- Relational Model
- Relational Algebra
- SQL
- Indexing
- Transaction Processing
- XML
Project
Description
Tentative
Lectures’ Schedule
(for chapter slides you can go to http://www.cs.wisc.edu/~dbbook/)
|
Date |
Topic |
Book Chapters or Other Material |
|
1/5, 1/7 |
Overview of DBMSs |
1 |
|
1/12, 1/14 |
Database Design |
2 (except 2.7) |
|
1/19, 1/21 |
Relational Model |
3 (except 3.6.2) |
|
1/26, 1/28 |
Relational Algebra |
4 (except 4.3) |
|
2/2, |
Normal Forms |
19.1-19.6 |
|
No class, instructor out of town |
||
|
2/9, 2/11 |
Normal Forms, SQL |
5.1-5.5 |
|
2/16, |
SQL (cont’d) |
|
|
Review Session |
||
|
2/25 |
MIDTERM |
material covered up to midterm date |
|
3/2, 3/4 |
JDBC, Stored Procedures Web Applications, JSP+MySQL |
6.2, 6.3, 6.5.1, 6.5.2, 6.6 7.5, JSP tutorial (slides: JDBC-JSP) |
|
3/9 |
cont’d, Views |
3.6 |
|
3/11 |
No class, instructor out of town |
|
|
3/23 |
Constraints |
5.6-5.7 |
|
3/25, 3/30, 4/1 |
Indexing |
8.1-8.3, 8.5, 10.1, 10.3, 10.4, 12.1 |
|
4/6 |
Intro to XML |
7.4, 27.7, (slides: XML) |
|
4/8 |
Projects’ Demo |
|
|
4/13 |
Review Session |
|
|
4/15 |
No class, study for final |
|
|
Tue 4/20 12-2pm |
FINAL |
material covered after midterm |
Other Resources
http://dev.mysql.com/doc/mysql/en/index.html
http://jakarta.apache.org/tomcat/
Textbook
Database Management Systems
by Raghu Ramakrishnan, Johannes Gehrke
Third Edition
ISBN: 0072465638
http://www.cs.wisc.edu/~dbbook/
Policies
Code of Academic Integrity:
http://www.fiu.edu/~oabp/misconductweb/2codeofacainteg.htm
University Policies: academic misconduct, sexual harassment, religious holydays, and information on services for students with disabilities.