Class Time and Place: M/W 1:00-2:15; IS 404
Instructor: Vladimir Zadorozhny
Office Hours: by appointment
Tel: (412) 624 9411
e-mail: vladimir@sis.pitt.edu
GSA: Evgeny Karataev
Office: 2B10, DSL Lab, 2nd Floor, SIS
Office Hour: Thur, 3:00 - 4:00 pm
Tel: (412) 624 7378
e-mail: epk8@pitt.edu
This is an introductory undergraduate course on database systems. It covers the external and conceptual levels of database systems, and provides an introduction to the physical implementation of database systems. The focus of this course is on centralized, relational database systems.
Prerequisites: INFSCI 0012, and INFSCI 0017, or permission of instructor.
Data abstraction; data independence; data definition and data manipulation languages.
Relational data models, relational query languages, SQL.
Database design, entity-relationship model, functional dependencies; introduction to normalization theory.
Query processing, database catalog system.
Storage strategies and indices.
Introduction to transaction management, concurrency control and recovery.
This course is being offered for three credits. The grading is as follows:
|
Homeworks |
30% |
|
Final Exam |
40% |
|
Project |
30% |
Late Policy: Homework are due at the beginning of class on the due date. Homework can be turned in the following class for a 25% penalty. No assignments will be accepted after that time.
Through the project, you will gain hands-on experience in designing and implementing an application on a database system. The project is done in groups of 3 students and is documented by a written group report. A demo will be scheduled for each group. The groups are "self-policed".
Project Description
| Lesslet Topic | Contributors | Lesslets Post Due Date | Lesslets Take&Like Due Date | |
| Primary Key |
|
Wed, Jan 25th | Mon, Jan 30th | |
| Foreign Key |
|
Wed, Feb 1st | Mon, Feb 6th | |
| !!!CURRENT!!! | Natural Join |
|
Wed, Feb 8st | Mon, Feb 13th |
All students are required to periodically check the class home page on the WWW. We will use this page to make announcements and to post information about the assignments and projects.
Week |
Day |
Topics (Chapters) |
Special Notes |
1 |
Wed 1/4 | Class Introduction |
|
| 2 | Mon 1/9 | Introduction (1) | |
|
Wed 1/11 |
Relational Model (2) |
|
3 |
Mon 1/16 |
NO CLASS |
Dr. Martin Luther King's Birthday |
|
Wed 1/18 |
Relational Model (2)/SQL(3,4) |
|
4 |
Mon 1/23 |
Lab |
Room 404 |
|
Wed 1/25 |
Lab |
Room 404 |
5 |
Mon 1/30 |
SQL(3,4) |
Project Assigned |
|
Wed 2/1 |
SQL(3,4) |
|
6 |
Mon 2/6 |
SQL(3,4) |
HW#1 Due |
|
Wed 2/8 |
SQL(3,4) |
Proj. Group Lists Due |
| 7 | Mon 2/13 |
SQL(3,4) |
|
|
Wed 2/15 |
SQL(3,4) |
HW#2 Due |
8 |
Mon 2/20 |
SQL(3,4) |
|
|
Wed 2/22 |
DB Design and E-RModel (7) |
|
9 |
Mon 2/27 |
DB Design and E-RModel(7) |
|
|
Wed 2/29 |
Relational DB Design (8) |
HW#3 Due |
| 10 | Mon 3/5 |
NO CLASS |
Spring Recess |
Wed 3/7 |
NO CLASS |
Spring Recess |
|
11 |
Mon 3/12 |
Relational DB Design (8) |
|
|
Wed 3/14 |
Storage and File Structure (10) |
|
12 |
Mon 3/19 |
Storage and File Structure (10) |
|
|
Wed 3/21 |
Indexing and Hashing (11) |
|
13 |
Mon 3/26 |
Indexing and Hashing (11) |
|
|
Wed 3/28 |
Transactions (14) |
|
14 |
Mon 4/2 |
Transactions (14) |
HW#4 Due |
| Wed 4/4 | Transactions (14) | ||
15 |
Mon 4/9 |
Concurrency (15) |
|
|
Wed 4/11 |
Concurrency (15) |
HW #5 Due |
16 |
Mon 4/16 |
Recovery (16) |
|
|
Wed 4/18 |
Recovery (16) |
Project Report Due |
| 17 | TBA | FINAL EXAM |
Last Modified: 1/3/2011