ECTS - Database Systems and Programming

Database Systems and Programming (CMPE343) Course Detail

Course Name Course Code Season Lecture Hours Application Hours Lab Hours Credit ECTS
Database Systems and Programming CMPE343 Area Elective 2 2 0 3 5
Pre-requisite Course(s)
CMPE341
Course Language English
Course Type Technical Elective Courses
Course Level Bachelor’s Degree (First Cycle)
Mode of Delivery Face To Face
Learning and Teaching Strategies Lecture.
Course Coordinator
Course Lecturer(s)
Course Assistants
Course Objectives The objective of this course is to cover advanced concepts and techniques of DB systems and DB programming. OODB concepts will also be introduced.
Course Learning Outcomes The students who succeeded in this course;
  • Discuss the fundamentals of a transaction processing and DB security
  • Review organizational DB concepts, components, structures, access, security, and management considerations
  • Implement functional DB systems using a suitable DB programming language
  • Compare object relational and other data models
Course Content Concurrent operations on databases; transaction processing and concurrency control; DB recovery, security and authorization; introduction to DB programming, object-oriented DB concepts.

Weekly Subjects and Releated Preparation Studies

Week Subjects Preparation
1 Transactions Chapters 15 (main text)
2 Concurrency Control 1 Chapter 16
3 Concurrency Control 2 Chapter 16
4 Recovery system 1 Chapter 17
5 Recovery system 2 Chapter 17
6 Introduction of Database Programming (PL/SQL) 1 Main text 2
7 Introduction of Database Programming (PL/SQL) 2 Main text 2
8 Query Processing & Optimization Chapter 13-14
9 Concurrent operations on databases 1 Chapter 15, 16
10 Concurrent operations on databases 2 Chapter 15, 16
11 The Internet Database Environment Chapter 10 (main text 2)
12 Introduction to scripting languages Instructor Text
13 Introduction to Object Oriented Database concepts 1 Chapter 9
14 Introduction to Object Oriented Database concepts 2 Chapter 9.6,-9.9

Sources

Course Book 1. Database Systems Concepts, Silberschatz, Abraham, Korth, Henry F.  Sudarshan, S., 4th Ed., Mc-Graw-Hill, 2001
2. Oracle 8i: A Practical Guide to SQL, PL/SQL, and Developer 6, Ali Yazıcı and Aydın Şekihanov, Atılım Yayınları, 2001
Other Sources 3. Modern Database Management By: J. A. Hoffer, M. B. Prescott, F. R McFadden, 8th Edition, ISBN: 013221211-0
4. Introduction to Relational Database and SQL Programming, C Allen, S. Chatwin, C. A. Creary, ISBN: 0-07-222924-1
5. Database Systems, 2nd ED., Garcia-Molina, Dllman, Widom, ISBN: 0-13-135428-0
6. An Introduction Database Systems, by C. J. Date, ISBN 032118956-6
7. Database Management System, R. Ramakrishnan, ISBN: 007-005775-9

Evaluation System

Requirements Number Percentage of Grade
Attendance/Participation - -
Laboratory 2 30
Application - -
Field Work - -
Special Course Internship - -
Quizzes/Studio Critics - -
Homework Assignments - -
Presentation - -
Project - -
Report - -
Seminar - -
Midterms Exams/Midterms Jury 1 30
Final Exam/Final Jury 1 40
Toplam 4 100
Percentage of Semester Work 60
Percentage of Final Work 40
Total 100

Course Category

Core Courses
Major Area Courses X
Supportive Courses
Media and Managment Skills Courses
Transferable Skill Courses

The Relation Between Course Learning Competencies and Program Qualifications

# Program Qualifications / Competencies Level of Contribution
1 2 3 4 5
1 Adequate knowledge in mathematics, science and subjects specific to the computer engineering discipline; the ability to apply theoretical and practical knowledge of these areas to complex engineering problems. X
2 The ability to identify, define, formulate and solve complex engineering problems; selecting and applying proper analysis and modeling techniques for this purpose. X
3 The ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for this purpose. X
4 The ability to develop, select and utilize modern techniques and tools essential for the analysis and determination of complex problems in computer engineering applications; the ability to utilize information technologies effectively. X
5 The ability to design experiments, conduct experiments, gather data, analyze and interpret results for the investigation of complex engineering problems or research topics specific to the computer engineering discipline. X
6 The ability to work effectively in inter/inner disciplinary teams; ability to work individually X
7 Effective oral and writen communication skills in Turkish; the ability to write effective reports and comprehend written reports, to prepare design and production reports, to make effective presentations, to give and to receive clear and understandable instructions. X
8 The knowledge of at least one foreign language; the ability to write effective reports and comprehend written reports, to prepare design and production reports, to make effective presentations, to give and to receive clear and understandable instructions.
9 Recognition of the need for lifelong learning; the ability to access information, to follow recent developments in science and technology. X
10 The ability to behave according to ethical principles, awareness of professional and ethical responsibility; X
11 Knowledge of the standards utilized in software engineering applications
12 Knowledge on business practices such as project management, risk management and change management; X
13 Awareness about entrepreneurship, innovation
14 Knowledge on sustainable development
15 Knowledge on the effects of computer engineering applications on the universal and social dimensions of health, environment and safety;
16 Awareness of the legal consequences of engineering solutions
17 An ability to describe, analyze and design digital computing and representation systems. X
18 An ability to use appropriate computer engineering concepts and programming languages in solving computing problems. X

ECTS/Workload Table

Activities Number Duration (Hours) Total Workload
Course Hours (Including Exam Week: 16 x Total Hours) 16 4 64
Laboratory
Application
Special Course Internship
Field Work
Study Hours Out of Class 16 2 32
Presentation/Seminar Prepration
Project
Report
Homework Assignments 2 5 10
Quizzes/Studio Critics
Prepration of Midterm Exams/Midterm Jury 1 10 10
Prepration of Final Exams/Final Jury 1 15 15
Total Workload 131