Database Management (COP-4540)
Summer A 2008
Announcements
|
project phase I |
midterm |
|
|
Median |
48 |
77 |
|
min |
25 |
43 |
|
Max |
55 |
96 |
·
There will be a review
session for the midterm on Thursday May 29 right after the class. 7:40-9pm, at
ECS 235.
· MySQL accounts are ready.
1. Connect to ocelot.aul.fiu.edu using your JCCL account. The login is your FIU E-mail username and the password is <first initial><pantherid><last initial>.
2. Then
start MySQL as explained below, and use your MySQL account, which is:
Username: sum08_username
Database name: sum08_username
Password: The user's panther ID
If your account does not work contact John F Flynn
III flynnj@cs.fiu.edu.
For other project related questions contact Fernando Farfan ffarf001@cs.fiu.edu.
· Instructions to connect to mysql from tomcat.
· Create all your tables with the option TYPE=INNODB. For example, create table test (id integer) TYPE=INNODB. The reason is that in MySQL foreign key constraints are only enforced when you create the table with this option, so use this option always since it does not harm you.
·
MySQL tips: To start MySQL, first ssh to connect
to ocelot.aul.fiu.edu and then type
mysql -u username -D databasename -h
ocelot.aul.fiu.edu –p.
Then, to see tables in the db, type: show
tables; To see schema of a table, type: describe
tablename;
· 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 5pm-7:40pm
Location: ECS 132
Office hours: Tuesday 4 pm - 5 pm
Grading
30% midterm
40% final
30% project
Late submissions, submitted before assignments are graded, 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. Students can work in groups of two, but in the end they should report
on the primary responsibilities of each partner.
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 |
|
5/6/2008 |
No class, instructor out of town |
|
|
5/8/2008 |
Overview of DBMSs |
1 |
|
5/13/2008 |
Database Design |
2 (except 2.7) |
|
5/15/2008 |
Relational Model |
3 (except 3.6.2) |
|
5/20/2008 |
Relational Algebra |
4 (except 4.3) |
|
5/22/2008 |
Normal Forms |
19.1-19.6 |
|
5/27/2008 |
SQL |
5.1-5.5 |
|
5/29/2008 |
SQL - Review Session |
|
|
6/3/2008 |
MIDTERM |
material covered up to midterm date |
|
6/5/2008 |
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) |
|
If there is time |
Views, Constraints |
3.6, 5.6-5.7 |
|
6/10/2008, 6/12/2008 |
Indexing |
8.1-8.3, 8.5, 10.1, 10.3, 10.4, 12.1 |
|
6/17/2008 |
Intro to XML - Review Session |
7.4, 27.7, (slides: XML), final review |
|
6/19/2008 |
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.