Fatih University

Faculty of Engineering

Department of Computer Engineering

Course Information for CENG 351 Database Systems

 

ANNOUNCEMENTS

 

 

  • Here are all grades in this course. Bu dersteki tüm notlar buradadır.
  • Here is the midterm grades.
  • Here is the extra slides on triggers I used in class.
  • Here is one homework solution from past semesters. Here is another one. Remember, the solutions in these documents may be incomplete or wrong. I have given you the right and complete solutions in class.
  • Home work 4 is here. MySQL driver is here. An example is at http://www.vogella.de/articles/MySQLJava/article.html or http://www.mkyong.com/jdbc/how-to-connect-to-mysql-with-jdbc-driver-java/
  • Midterm is here which is your third homework due next Tuesday to be done in MySQL.
  • Midterm is on Monday 12.12.2011 from Chapters 1 (intro), 6 (ER), and 3 (SQL).
  • Homework 2 is here and due next Tuesday 13.12.2001. student.sql is here for this homework.
  • Last year’s homeworks are in last years web page here.
  • Last year’s final is here.
  • Last year’s midterm 2011 is here and here.
  • Download Assignment 1 here. It is due on Oct 31 2011. Remember submission the class on submission data and no late submission.
  • Wellcome to one of the fundemantal subjects in Computer Science: Database Systems.

 

DOWNLOADS

 

 

I. COURSE DESCRIPTION

 

Course Code: CENG 351                          Course Name: Database Management Systems

Course Web page: http://www.fatih.edu.tr/~akurt/courses/ceng351/fall2011/

Course Objectives: This course will introduce the essential aspects of database management systems from relational data model point of view. In addition to database design using Entity-relationship model, foundation of relational data model, SQL programming will be main theme of this course. A number of homework assignments will be given.

 

Prerequisites: Computer Programming Skills, Data Structures and algorithms    

Special Requirements: None

 

Instructor: Atakan Kurt, Office: Bldg. E, Room EA 306, Phone:5513 E-mail: akurt@fatih.edu.tr

Office Hours: Mon 13-14, Wed 10-11

 

Teaching Assistant:

  • BILM 351 Yasemin, Office: E 604, tel: 5516 E-mail: ysahinfatih.edu.tr
  • CENG 351 Harun R. Zafer, Office: E 317, tel: 5578 E-mail: hrzaferfatih.edu.tr

 

Office Hours: Mon 12-13, Tue 15-16 Wed 11-12

 

Textbook:

1.       Database Systems Concepts, 5th edition, Abraham Silberschatz, et al, McGRawHill, 0-07-710365-3, http://www.bell-labs.com/topic/books/db-book, http://www.mhhe.com/silberschatz

2.       Veri Tabanı Sistemleri, Dr. Yalçın Özkan, Alfa Yayınları, 2003, 975-297-360-4

 

II. COURSE CONTENTS

 

·         An introduction to database systems

·         Entity-Relationship model

·         Relational Data Model

·         SQL

·         Data Definition Language

·         Data Manipulation Language

·         Data Control Language

·         Odbc/jdbc

·         Integrity and Security

·         Stored Procedures and Triggers

·         Physical Database Design

·         Indexing

·         Normalization

 

III. LABORATORY EXPERIMENTS, TUTORIALS, AND OTHER ACTIVITIES

The course involves programming assignments, homeworks. There may be a number of popup quizzes.

 

IV. GRADING

5-7 homeworks (~35points), 1 midterm (~25 points), 1 final (~40 points). Homeworks are usually 5 points each. You need to collect 50 points to pass the course. You need to do & submit at least 3 out of 5 homeworks in this course in order to pass.