Computer Programming
Course Details
KTO KARATAY UNIVERSITY
Trade and Industry Vocational School
Programme of Computer Programming
Course Details
Trade and Industry Vocational School
Programme of Computer Programming
Course Details
| Course Code | Course Name | Year | Period | Semester | T+A+L | Credit | ECTS |
|---|---|---|---|---|---|---|---|
| 03831209 | Advanced Database Management | 2 | Autumn | 3 | 2+1+0 | 5 | 5 |
| Course Type | Elective |
| Course Cycle | Associate (Short Cycle) (TQF-HE: Level 5 / QF-EHEA: Short Cycle / EQF-LLL: Level 5) |
| Course Language | Turkish |
| Methods and Techniques | - |
| Mode of Delivery | Face to Face |
| Prerequisites | - |
| Coordinator | - |
| Instructor(s) | Lect. Seda YILDIRIM |
| Instructor Assistant(s) | - |
Course Instructor(s)
| Name and Surname | Room | E-Mail Address | Internal | Meeting Hours |
|---|---|---|---|---|
| Lect. Seda YILDIRIM | TSMYO-T213 | [email protected] | 7915 |
Course Content
Logical organization of data, problem definition, entity and relationship concepts, attributes, entity-relationship (ER) modeling of data, obtaining ER diagrams from problem definition statements, translating ER diagrams to SQL tables, relational algebra, union, division, intersection, filtering operations, data description and query languages, basic SQL data manipulation and data definition commands, single table and multi-table queries, division.
Objectives of the Course
To learn how to use and design database management systems and how to develop database applications.
Contribution of the Course to Field Teaching
| Basic Vocational Courses | |
| Specialization / Field Courses | X |
| Support Courses | |
| Transferable Skills Courses | |
| Humanities, Communication and Management Skills Courses |
Relationships between Course Learning Outcomes and Program Outcomes
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Program Learning Outcomes | Level |
|---|---|---|
| P1 | He/she has basic, current and applied information about his/her profession. | 5 |
| P3 | He/She follows current developments and practices in his profession and uses them effectively. | 4 |
| P11 | Creates algorithms and data structures and performs mathematical calculations. | 4 |
| P13 | Performs database design and management. | 5 |
| P14 | Tests software and fixes bugs. | 4 |
Course Learning Outcomes
| Upon the successful completion of this course, students will be able to: | |||
|---|---|---|---|
| No | Learning Outcomes | Outcome Relationship | Measurement Method ** |
| O1 | Knows how to develop algorithms and creates a data structure suitable for the algorithm. | P.4.1 | 1,4,7 |
| O2 | Tests software and fixes bugs. | P.5.1 | 1,4,7 |
| O3 | Offers solutions to problems within the project. | P.7.2 | 1,4,7 |
| O4 | Has knowledge of database design. | P.13.1 | 1,4,7 |
| O5 | Has knowledge of database management. | P.13.2 | 1,4,7 |
| O6 | Can perform database queries. | P.13.3 | 1,4,7 |
| ** Written Exam: 1, Oral Exam: 2, Homework: 3, Lab./Exam: 4, Seminar/Presentation: 5, Term Paper: 6, Application: 7 | |||
Weekly Detailed Course Contents
| Week | Topics |
|---|---|
| 1 | Introduction to databases |
| 2 | Intro to ER Model |
| 3 | Relational Model: Relational Algebra, Relational Calculus |
| 4 | Query Languages: SQL |
| 5 | Basic SQL data manipulation and data definition commands |
| 6 | Design of Relational databases |
| 7 | Midterm |
| 8 | Peformance Modelling, Database Tuning |
| 9 | File and System Structures: file organization |
| 10 | Indexing and Sorting |
| 11 | Query-Processing |
| 12 | Transaction Management |
| 13 | Exam |
Textbook or Material
| Resources | Database Management Systems, by Raghu Ramakrishnan and Johannes Gehrke, (2007) |
Evaluation Method and Passing Criteria
| In-Term Studies | Quantity | Percentage |
|---|---|---|
| Attendance | - | - |
| Laboratory | - | - |
| Practice | - | - |
| Field Study | - | - |
| Course Specific Internship (If Any) | - | - |
| Homework | - | - |
| Presentation | - | - |
| Projects | - | - |
| Seminar | - | - |
| Quiz | - | - |
| Listening | - | - |
| Midterms | 1 | 40 (%) |
| Final Exam | 1 | 60 (%) |
| Total | 100 (%) | |
ECTS / Working Load Table
| Quantity | Duration | Total Work Load | |
|---|---|---|---|
| Course Week Number and Time | 16 | 2 | 32 |
| Out-of-Class Study Time (Pre-study, Library, Reinforcement) | 16 | 1 | 16 |
| Midterms | 1 | 14 | 14 |
| Quiz | 0 | 0 | 0 |
| Homework | 0 | 0 | 0 |
| Practice | 1 | 14 | 14 |
| Laboratory | 0 | 0 | 0 |
| Project | 0 | 0 | 0 |
| Workshop | 0 | 0 | 0 |
| Presentation/Seminar Preparation | 0 | 0 | 0 |
| Fieldwork | 0 | 0 | 0 |
| Final Exam | 1 | 14 | 14 |
| Other | 0 | 0 | 0 |
| Total Work Load: | 90 | ||
| Total Work Load / 30 | 3 | ||
| Course ECTS Credits: | 3 | ||
Course - Learning Outcomes Matrix
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Learning Outcomes | P4 | P5 | P7 | P13 |
|---|---|---|---|---|---|
| O1 | Knows how to develop algorithms and creates a data structure suitable for the algorithm. | 4 | - | - | - |
| O2 | Tests software and fixes bugs. | - | 4 | - | - |
| O3 | Offers solutions to problems within the project. | - | - | 4 | - |
| O4 | Has knowledge of database design. | - | - | - | 5 |
| O5 | Has knowledge of database management. | - | - | - | 5 |
| O6 | Can perform database queries. | - | - | - | 5 |