COURSE INFORMATION
Course Title: DATABASE MANAGEMENT SYSTEMS
Code Course Type Regular Semester Lecture Recit. Lab Credits ECTS
CEN 252 B 4 - - - 3 5
Lecturer and Office Hours: Mükremin Özkul
Teaching Assistant(s) and Office Hours: -
Language: English
Compulsory/Elective: Compulsory
Classroom and Meeting Time: N/A
Course Description: Database design using entity-relationship model and relational data model, SQL (data definition and data manipulation languages), data integrity and integrity constraints, triggers, stored procedures, indexing and application development.
Course Objectives: The purpose of this course is to provide an introduction to the design and use of database systems, as well as an appreciation of the key issues in building such systems, and working with multiple database systems.
COURSE OUTLINE
Week Topics
1 Databases and Database Users
2 Database System Concepts and Architecture
3 Data Modeling Using the Entity Relationship Model
4 The Relational Data Model and SQL
5 SQL Basics and Schema Definition, Interactive SQL
6 Interactive SQL
7 Interactive SQL
8 Midterm
9 Relational Algebra
10 SQL Programming
11 SQL Programming
12 Web Database Programming Using PHP
13 Normalization for Relational Databases
14 Review Week
Prerequisite(s): None
Textbook: FUNDAMENTALS OF Database Systems, Ramez Elmasri, Shamkant B. Navathe
Other References:
Laboratory Work: N/A
Computer Usage: N/A
Others: No
COURSE LEARNING OUTCOMES
1 Recognize database management systems
2 Make the models of database with entity-relation diagrams
3 Implement databases using SQL
COURSE CONTRIBUTION TO... PROGRAM COMPETENCIES
(Blank : no contribution, 1: least contribution ... 5: highest contribution)
No Program Competencies Cont.
COURSE EVALUATION METHOD
Method Quantity Percentage
Midterm Exam(s)
1
40
Quiz
1
10
Final Exam
1
50
Total Percent: 100%
ECTS (ALLOCATED BASED ON STUDENT WORKLOAD)
Activities Quantity Duration(Hours) Total Workload(Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 4 64
Hours for off-the-classroom study (Pre-study, practice) 16 2 32
Mid-terms 1 9 9
Assignments
Final examination 1 10 10
Other 2 5 10
Total Work Load:
125
Total Work Load/25(h):
5
ECTS Credit of the Course:
5