COP4710 Theory and Structure of Databases, Computer Science Department, FSU

COP4710 Fall 2009: Theory and Structure of Databases, Computer Science Department, FSU

Instructor: Feifei LI

[Overview] [Announcements] [Syllabus] [Textbook] [Schedule] [Slides] [Written Assignments] [Project] [Additional Resources] [Contact]　

Overview

Undergraduate-level introduction to database systems and applications using databases. Introduces the ER model and its mapping to the relational data model. Studies the logical language in the relational data model and its relationship to the commercial relational query language: SQL. Examines in depth how to design a database conforming to different normal forms. Understand how various programs are able to connect to the database through ODBC. Briefly covers indexing and hashing. Finally, we will cover database integrity and security. An important related topic is the social and ethical issues with data management, examples include but not limit to data privacy, laws and technologies that protect data, encryption and interception of information. Furthermore, students will participate in a semester-long project and build a web-based database system (e.g., an online bookstore) starting with a customer specification. In summary, this course is about the principles of designing and developing applications using the relational database system.

Announcements

      08/19/09: Course website is up. Course syllabus is ready for review.
      08/27/09: HW1 has been released.
      09/03/09: The due date for HW1 has been extended to Thursday, 09/10/09.
      9/15/09: HW2 has been released.
      09/17/09: To access the database server, please follow the following steps. 1. Connect to a linux server in our department, specifically, you should use the linprog server. 2. Type the following command: mysql -h dbsrv2.cs.fsu.edu -u username -p dababasename. In which, the username is your database user account and the databasename is the database you are trying to access in the database server; this could be your account for your term project if you are accessing your team's project database (cop4710t01 and cop4710t01db, say if you are team 1); or this should be cop4710 and cop4710db. 3. Once you've entered this command, it will ask for a password, simply supply the right password depending on which useraccount/datbase combination you are using. We have provided you with the password for the cop4710 user name to access the class-wide database cop4710db in the class. 4. You can also access the database server using the windows client program installed on the windows machines in the Majors Lab in the computer science department.
      09/28/09: Solution to HW2 has been released.
      09/29/09: HW3 has been released. The due date is Oct 8.
      09/29/09: Project has been released.
      09/29/09: The midterm is scheduled on Thursday, Oct 15, in class: 3:30pm-5:00pm.
      10/09/09: Solution to HW3 has been posted.
      10/13/09: Sample Java codes have been posted (in the same directory with the HW solutions, under the folder javaexample, including the mysql.jar library).
11/12/09: HW4 is released.

Syllabus

Syllabus for the course in PDF format:

Textbook

Database Management System by R. Ramakrishnan and J. Gehrke, 3rd Edition. Details and additional material supporting this book could be found here.

Schedule

Lecture: Tuesday, Thursday 3:35pm - 4:50pm, Love 0301.

Office Hour: Mon 10am-11am; Wed 10am-11am.

Exam: Midterm: Thursday, Oct 15, 3:30pm-5:00pm; Final: Monday, Dec. 7, 5:30pm-7:30pm.

Detailed weekly schedule could be found in the course syllabus.

Slides

Slides will be posted before each lecture. Updates to slides may happen after the lecture.
Lecture 1: Course Administration and Introduction, Overview of Database Systems
Lecture 2: Data Modelling: ER Diagram
Lecture 3: Data Modelling: Relational Model
Lecture 4: ER-Diagram to Relational Model
Lecture 5: Relational Algebra
Lecture 6: Tuple Relational Calculus
Lecture 7: SQL: Part1
Lecture 8: SQL: Part2
Lecture 9: SQL: Part3
Lecture 10: Java Part 1 Part 2

Lecture 11: JSP Tutorial JSP Tutorial
Lecture 12: Funtional Dependency
Lecture 13: Normalization
Lecture 14: Minimal Cover
Lecture 15: B+ Tree Index

Written Assignments

1. Assignment will be posted after it is announced in the class.
2. Solution will be posted once the assignment due date is passed.

Written Assignment One:

HW1, Due: Tuesday, 09/08/09, in Class.
Written Assignment Two:

HW2, Due: Thursday, 09/24/09, in Class.
Written assignment Three:

part a and

part b, due: Thursday, 10/08/08, in class.
Written Assignment Four:

HW4, Due: Tuesday, 11/24/09, in Class.