Fatih University

Faculty of Engineering

Department of Computer Engineering

Course Information for CENG 351 Database Systems

 

ANNOUNCEMENTS

 

 

  • CENG 351 final exam and all other grades are here.
  • BILM 351 final ve tüm diğer notları buradan alabilirsiniz.
  • BILM 351 arasınav notlarını buradan alabilirsiniz.
  • CENG 351 midterm grades are here.
  • CENG 351 Homework 5 grading is here.
  • BILM 351 Ödev 5 notlarını buradan alabilirsiniz.
  • BILM 351 Ödev 4 notlarını buradan alabilirsiniz.
  • CENG 351 Homework 3 and 4 grading are here.
  • Homework 5’s submission is postponed to this Thursday until 5:00pm. Submit your homework to the assistant please. You can slip the homework under assistant’s door. Do not forhet to submit by email.
  • Homework 5 is here for you to download. It is due next week.
  • BILM 351 Homework 3 grading is here.
  • ATTENSION: Exam is postponed 1 day. Exam will be tomorrow (Tuesday)
  • A solution for homework 4 is here.
  • When submitting homeworks, please adhere to the rules in homework format file and have a look at the sample homeworks.
  • Homework 4 is here for you to download. It is due next week.
  • CENG 351 Homework 1 and 2 grading are here.
  • BILM 351 Homework 2 grading is here.
  • BILM 351 Homework 1 grading is here.
  • Homework 3 is here for you to download. It is due next week.
  • Homework 2 is here for you to download. It is due next week.
  • Homework 1 is here for you to download. It is due next week.
  • 12.10.2009 Monday class is cancelled due to my illness. I will announce the make date and times for these classes.

 

DOWNLOADS

 

 

I. COURSE DESCRIPTION

 

Course Code: CENG 351                          Course Name: Database Management Systems

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

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: Strong Computer Programming Skills, Data Structures and algorithms      Special Requirements: None

 

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

Office Hours: to be announced

 

Teaching Assistant: Murat Gezer, Office: Basement labs, E-mail: mgezer@fatih.edu.tr, 5522

Office Hours: to be announced

 

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 introductıon 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). Home works are usually 5 points each. You need to collect 50 points to pass the course. The assignments are considered as lab in this course. You need to submit at least 3 out of 5 home works in this course in order to pass.