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 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 | |
|---|---|
| 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 | Has adequate knowledge in mathematics, science, and computer engineering-specific subjects; uses theoretical and practical knowledge in these areas to solve complex engineering problems. | X | ||||
| 2 | Identifies, defines, formulates, and solves complex engineering problems; selects and applies appropriate analysis and modeling methods for this purpose. | X | ||||
| 3 | Designs a complex system, process, device, or product to meet specific requirements under realistic constraints and conditions; applies modern design methods for this purpose. | X | ||||
| 4 | Develops, selects, and uses modern techniques and tools necessary for the analysis and solution of complex problems encountered in computer engineering applications; uses information technologies effectively. | X | ||||
| 5 | Designs experiments, conducts experiments, collects data, analyzes and interprets results for the investigation of complex engineering problems or research topics specific to the discipline of computer engineering. | X | ||||
| 6 | Works effectively in disciplinary and multidisciplinary teams; gains the ability to work individually. | X | ||||
| 7 | Communicates effectively in Turkish, both orally and in writing; writes effective reports and understands written reports, prepares design and production reports, makes effective presentations, gives and receives clear and understandable instructions. | X | ||||
| 8 | Knows at least one foreign language; writes effective reports and understands written reports, prepares design and production reports, makes effective presentations, gives and receives clear and understandable instructions. | |||||
| 9 | Has awareness of the necessity of lifelong learning; accesses information, follows developments in science and technology, and continuously improves oneself. | X | ||||
| 10 | Acts in accordance with ethical principles and has awareness of professional and ethical responsibility. | X | ||||
| 11 | Has knowledge about the standards used in computer engineering applications. | |||||
| 12 | Has knowledge about workplace practices such as project management, risk management, and change management. | X | ||||
| 13 | Gains awareness about entrepreneurship and innovation. | |||||
| 14 | Has knowledge about sustainable development. | |||||
| 15 | Has knowledge about the health, environmental, and safety impacts of computer engineering applications in universal and societal dimensions and the contemporary issues reflected in the field of engineering. | |||||
| 16 | Gains awareness of the legal consequences of engineering solutions. | |||||
| 17 | Analyzes, designs, and expresses numerical computation and digital representation systems. | X | ||||
| 18 | Uses programming languages and appropriate computer engineering concepts to solve computational 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 | ||