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 |
|---|---|---|---|---|---|---|---|
| 03820102 | Database Management | 1 | Spring | 2 | 3+1+1 | 7 | 7 |
| Course Type | Compulsory |
| Course Cycle | Associate (Short Cycle) (TQF-HE: Level 5 / QF-EHEA: Short Cycle / EQF-LLL: Level 5) |
| Course Language | Turkish |
| Methods and Techniques | Ders 3 saat teorik bilgi ve 1 saat laboratuvar ortamında teorik bilginin uygulamaya dönüştürülmesi şeklinde işlenmektedir. Ms sql server 2020 kullanılarak veri tabanı sistemi tasarlanıp sql yazımı gerçekleştirilmiştir. |
| Mode of Delivery | Face to Face |
| Prerequisites | - |
| Coordinator | Lect. Seda YILDIRIM |
| Instructor(s) | Lect. Seda YILDIRIM |
| Instructor Assistant(s) | - |
Course Instructor(s)
| Name and Surname | Room | E-Mail Address | Internal | Meeting Hours |
|---|---|---|---|---|
| Lect. Seda YILDIRIM | A-122 | [email protected] | 7915 | Wednesday 14.00-17.00 |
Course Content
Database concept, Database Basic Components, Database needs analysis, Entity-Relationship Model, Relational Database Design, Normalization, SQL Data Types, Data Integrity and Constraints, Installation and Running of SQL Server Program, SQL- Data Definition Language Commands, SQL- Data Processing Language Housings, SQL-Data Control Language Commands, Queries in a Single Table, Arithmetic Operators and Functions, Querying by Grouping, Querying on Multiple Tables, Subqueries and Their Properties
Objectives of the Course
With this course, the student: It is aimed to provide students with the competencies to design, create, query and use database administrative functions.
Contribution of the Course to Field Teaching
| Basic Vocational Courses | X |
| 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 |
|---|---|---|
| P4 | Effectively uses information technologies (software, programs, animations, etc.) related to her/his profession. | 5 |
| P11 | Creates algorithms and data structures and performs mathematical calculations. | 5 |
| P13 | Performs database design and management. | 5 |
| P14 | Tests software and fixes bugs. | 5 |
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,7 |
| O2 | Has knowledge of current programming languages. | P.11.3 | 1,4,7 |
| O3 | Has knowledge of database design. | P.13.1 | 1,4,7 |
| O4 | Has knowledge of database management. | P.13.2 | 1,4,7 |
| O5 | Can perform database queries. | P.13.3 | 1,4,7 |
| O6 | Tests software and fixes bugs. | P.14.1 | 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 | Database and DBMS Concepts Entrance |
| 2 | Relational Database Models |
| 3 | Database Table Design, ER Diagram creation |
| 4 | Database Table Design, ER Diagram creation |
| 5 | Creating Relationships Between Tables |
| 6 | Normalisation |
| 7 | Normalisation |
| 8 | Midterm 1 |
| 9 | Determining Primary Key - Foreign Key for Tables |
| 10 | DDL (Data Definition Language)-Create,Drop ,Alter |
| 11 | DML (Data Manuplation Language) -select,insert,update,delete |
| 12 | Sample for SQL |
| 13 | Functions for SQL |
| 14 | İnner Join and Nested Queries |
| 15 | Final Exam |
Textbook or Material
| Resources | Veri tabanı Sistemleri, Ünal Yarımağan, Akademi Kitapevi |
| Veri tabanı Sistemleri, Ünal Yarımağan, Akademi Kitapevi |
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 | 30 (%) |
| Final Exam | 1 | 70 (%) |
| Total | 100 (%) | |
ECTS / Working Load Table
| Quantity | Duration | Total Work Load | |
|---|---|---|---|
| Course Week Number and Time | 16 | 6 | 96 |
| Out-of-Class Study Time (Pre-study, Library, Reinforcement) | 0 | 0 | 0 |
| Midterms | 1 | 14 | 14 |
| Quiz | 0 | 0 | 0 |
| Homework | 0 | 0 | 0 |
| Practice | 14 | 3 | 42 |
| Laboratory | 14 | 3 | 42 |
| 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: | 208 | ||
| Total Work Load / 30 | 6,93 | ||
| Course ECTS Credits: | 7 | ||
Course - Learning Outcomes Matrix
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Learning Outcomes | P4 | P11 | P13 | P14 |
|---|---|---|---|---|---|
| O1 | Knows how to develop algorithms and creates a data structure suitable for the algorithm. | 5 | - | - | - |
| O2 | Has knowledge of current programming languages. | - | 4 | - | - |
| O3 | Has knowledge of database design. | - | - | 5 | - |
| O4 | Has knowledge of database management. | - | - | 5 | - |
| O5 | Can perform database queries. | - | - | 5 | - |
| O6 | Tests software and fixes bugs. | - | - | - | 5 |