Principles of Database Management Systems (COP-5725)

Fall 2010

Announcements

·        On 12/1 6:15-7:50pm in classroom groups will each demo their project to Xing. A  Spreadsheet will be given out in review session of 11/29 to pick your 4 minute time slot.

·        MySQL accounts have been created. For each student:

Server: margay.cs.fiu.edu
Username: fall10_username
Database name: fall10_username
Password: Panther ID

Note that the MySQL accounts are different from your UNIX accounts that you need to connect to the school computers.

 

Project 1

midterm

Project 2

Min

33

39

 

Max

50

95

 

median

44

78.5

 

·        Instructions to connect to mysql from tomcat.

·        Sample schema

·        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

·        MySQL tips: To start MySQL, first ssh to connect to margay.cs.fiu.edu and then type
mysql -u username -D databasename -h margay.cs.fiu.edu –p.
Then, to see tables in the db, type: show tables; To see schema of a table, type: describe tablename;

·        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-5725 web page!

General Info

Instructor: Vagelis Hristidis

Description: Description: Description: Description: U:\public_html\email.JPG

Lecture time: Monday/Wednesday 6:25 pm-7:40 pm

Location: ECS 141

Office hours: Mondays, Wednesdays 5 pm-6:25 pm

 

Teaching Assistant: Xing Yang <xyang006@fiu.edu>

Office hours: ECS 254, Thursdays 4:00 - 5:00 pm

Grading

30% midterm

40% final

30% project

Course Description

This is a graduate level 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 first part of the class will quickly go through the undergraduate databases material and the second part will discuss new material like indexing, query optimization and XML.

 

The class involves a project of accessing a database through a web application. In particular, the technologies that we will use are:

Prior knowledge of these technologies is not required as learning materials will be provided. Students must 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:

 

Project Description

In groups of two. If you cannot find partner, please email me to match you with a partner.

Late submissions, submitted before assignments are graded, will receive a 20% score reduction.

project

 

Tentative Lectures’ Schedule

(for chapter slides you can go to http://www.cs.wisc.edu/~dbbook/)

Date

Topic

Book Chapters or Other Material

8/23

Overview of DBMSs

1

8/25, 8/30

Database Design

2 (except 2.7)

9/1

Relational Model

3 (except 3.6)

9/6

No class, university closed

9/8

Relational Model (cont’d)

9/13, 9/15

No class, instructor out of town in conference

9/20

Practice Exercises

slides

9/22, 9/27

Relational Algebra and Calculus

4

9/29, 10/4, 10/6

SQL, null values, Views

5.1-5.5, 3.6, 5.6, 3.6, practice exercises

10/11, 10/13

Normal Forms

19.1-19.6, 19.8.1

10/18

review session

SQL review, normal forms review, slides, Amanda slides

10/20

MIDTERM

material covered up to midterm date

10/25

solve midterm, SQL constraints

5.7

10/27

No class, instructor out of town in conference

11/1, 11/3

JDBC, Stored Procedures

Web Applications, JSP+MySQL (cont’d)

6.2, 6.3, 6.5.1, 6.5.2, 6.6

7.5, JSP tutorial (slides: JDBC-JSP), mysql stored procedures slides

11/8, 11/10

Indexing

8.1-8.3, 8.5, 10.1, 10.3, 10.4

11/15, 11/17, 11/22

Indexing (cont’d), Query Evaluation I

12

11/24

XML

7.4, 27.7, XQuery tutorial  (slides: XML, XQuery)

11/29

Review Session

slides, cost exercise

12/1 6:15-7:50pm

Project demos in class

12/8 5-7pm

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.

http://www.fiu.edu/provost/polman/sec2/sec2web2-44.htm