SYLLABUS
Course ID IS202
Course Name Database Systems
Semester Spring, 2011
Instructor Prof. Dr. M. Emin DALKILIÇ
E-Mail mehmet.emin.dalkilic@ege.edu.tr
Class Times Wednesday 08:30–11:20 C 501 (Section 2: Software Eng.)
Wednesday 14:30–17:20 C 501 (Section 3: Software Eng.)
Lab Hours Wednesday 11:30–13:20 C 605 (Section 2: Software Eng.)
Wednesday 17:30–19:20 C 605 (Section 3: Software Eng.)
Important
!!! Anouncement on Lab work and mySql (JDBC) homework due on May 18th 2011 !!!
On May 18th, your Lab Homework is 9.6.2. Here is the example code and help
in installing and using
JDBC with MySQL JDBC
on Eclipse PC_all.sql
Anouncement on Lab work and mySql (PSM) homework due
on May 11th 2011 !!!
Anouncement
on Lab work and mySql homework due on May 4th 2011 !!!
Anouncement on Lab work and mySql
homework due on April 27th 2011
Anouncement
on Lab work and mySql homework due on April 20th 2011 !!!
Midterm Exam: April 16th, 2011 13:30 -15:30 at M401, M402, M403
How to
download and install mySql and World database due on April 6th 2011
Important
anouncement on Lab work and mySql homework due on April 13th 2011 !!!
Objectives
The goal of this course is to give basic knowledge of database systems to a
student who intends
to be a computer or software engineer. It provides a comprehensive introduction
to data models
including entity-relationship data model and object oriented data model.
SQL database language
and object orientation in querry languages are studied in detail together
with laboratory practices.
Course Outline
|
Week |
Chap. Sect. |
Topic |
|
01(15-02) |
1, 2, 11 |
Introduction, Relational Data Model, XML |
|
02(22-02) |
4 |
Entity-Relationship Data Model |
|
03(01-03) |
3 |
Design of Relational Databases, Functional Dependencies |
|
04(08-03) |
3 |
Design of Relational Databases, Multivalued Dependencies |
|
05(15-03) |
2, 5 |
Relational Algebra |
|
06(22-03) |
6 |
Introduction to SQL (Part I) |
|
07(29-03) |
6 |
Introduction to SQL (Part II) |
|
08(05-04) |
|
MIDTERM EXAM |
|
09(12-04) |
7 |
Constraints and Triggers |
|
10(19-04) |
9 |
PSM, Embedded SQL |
|
11(26-04) |
9 |
SQL/CLI, JDBC, PHP |
|
12(03-05) |
6, 8 |
Transactions, Views, Indexes |
|
13(10-05) |
10 |
SQL Authorization |
|
14(17-05) |
Review |
|
|
15(24-05) |
5, 10 |
Logical Query Languages (Datalog) and SQL Recursion |
Textbook
J. D. Ullman and J. Widom, A First Course In
Database Systems, 3rd Ed., Prentice-Hall,
( ISBN-10: 013600637X, ISBN-13: 9780136006374).
Reference Book
Silberschatz et. al., Database System Concepts, 4th ed., McGraw-Hill, 2002
Web References
The book’s home page is http://www-db.stanford.edu/~ullman/fcdb.html
The course home page is http://homes.ieu.edu.tr/ttunali/courses/database/database.htm
Assignments
To fully prepare for the exams, study lecture notes, go through the
examples in the text book and
study/solve the exercises in the text book to test your understanding of
the subject. In addition,
make sure that you go through the
starred exercises (with solutions in the text book’s website)
and understand them.
Quizes 1st quiz on March 9th 2011,
2nd quiz on March 23th 2011
(content: fds and mvds)
3rd quiz on April 6th 2011 (
content: ra1, ra2, sql1)
Late Comers
Exams
Attendance
where X is your attendance percentage throughout
the semester
Participation
that will form the basis of attendance grade
bonus points (not greater than 5) accumulated
throughout the semester.
Evaluation:
Midterm Exam %25
Quizes %15
Lab %15
Final Exam %35
Attendance %05
Participation %05
Announcements
The students are expected to check their e-mails and the web site of the course for the announcements.