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 | Elective Courses |
| Course Level | Bachelor’s Degree (First Cycle) |
| Mode of Delivery | Face To Face |
| Learning and Teaching Strategies | Lecture. |
| Course Lecturer(s) |
|
| 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;
|
| 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 | X |
|---|---|
| Major Area Courses | |
| 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 computing fields; ability to apply theoretical and practical knowledge of these fields in solving engineering problems related to information systems. | |||||
| 2 | Ability to identify, define, formulate and solve complex engineering problems; selecting and applying proper analysis and modeling techniques for this purpose. | X | ||||
| 3 | Ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; ability to apply modern design methods for this purpose. | |||||
| 4 | Ability to develop, select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in information systems engineering applications; ability to use information technologies effectively. | X | ||||
| 5 | Ability to gather data, analyze and interpret results for the investigation of complex engineering problems or research topics specific to the information systems discipline. | X | ||||
| 6 | Ability to work effectively in inter/inner disciplinary teams; ability to work individually. | |||||
| 7 | a. Effective oral and written communication skills in Turkish; ability to write effective reports and comprehend written reports, to prepare design and production reports, to make effective presentations, to give and receive clear and understandable instructions. b. Knowledge of at least one foreign language; ability to write effective reports and comprehend written reports, to prepare design and production reports, to make effective presentations, to give and receive clear and understandable instructions. | |||||
| 8 | Recognition of the need for lifelong learning; the ability to access information and follow recent developments in science and technology with continuous self-development. | |||||
| 9 | a. Ability to behave according to ethical principles, awareness of professional and ethical responsibility. b. Knowledge of the standards utilized in information systems engineering applications. | |||||
| 10 | a. Knowledge on business practices such as project management, risk management and change management. b. Awareness about entrepreneurship, and innovation. c. Knowledge on sustainable development. | |||||
| 11 | a. Knowledge of the effects of information systems engineering applications on the universal and social dimensions of health, environment, and safety. b. Awareness of the legal consequences of engineering solutions. | |||||
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 | ||