COMPUTER PROGRAMMING (TURKISH) | |||||
Associate | TR-NQF-HE: Level 5 | QF-EHEA: Short Cycle | EQF-LLL: Level 5 |
Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
BPR1009 | Database I | Fall | 1 | 2 | 2 | 5 |
The course opens with the approval of the Department at the beginning of each semester |
Language of instruction: | Tr |
Type of course: | Must Course |
Course Level: | Associate |
Mode of Delivery: | Face to face |
Course Coordinator : | Dr. Öğr. Üyesi ÖZGÜR ERKUT ŞAHİN |
Course Lecturer(s): |
Dr. Öğr. Üyesi ÖZGÜR ERKUT ŞAHİN Instructor BARIŞ ERDOĞAN Instructor DOĞAN AYDIN Instructor KEMAL YILDIRIM |
Course Objectives: | This course covers fundamentals of database design and architecture, database queries, and database management systems. Principles and methodologies of database design, and techniques for database application development. |
The students who have succeeded in this course; 1)Database Design 2)Database Table Design 3)Database Queries 4)Database Management Functions |
The administrator of a database should be able to fullfil database inner operations, setup a full database using MySQL ,designing and planning a database using SQL commands/applications. |
Week | Subject | Related Preparation | |
1) | Database Needs Analysis | ||
2) | Entity Relationship Diagrams | ||
3) | Entity Relationship Diagrams | ||
4) | Normalization | ||
5) | Installation of Database Tools Construct Tables and identify properties of tables | ||
6) | Construct Tables and identify properties of tables | ||
7) | Construct Queries | ||
8) | Construct Queries. Relational Tables and Queries | ||
9) | Construct Queries | ||
10) | DML Queries | ||
11) | DML Queries and User queries | ||
12) | View Queries Triger Queries | ||
13) | Triger Queries and subqueries | ||
14) | Transaction Operations Index queries |
Course Notes: | Yaşar DEMİR. Veri Tabanı Yönetim Sistemleri. Türkmen Kitabevi, 2004 |
References: | Dr.Yalçın Özkan.Veri Tabanı Sistemleri. ALFA. 2006 |
Semester Requirements | Number of Activities | Level of Contribution |
Attendance | 0 | % 0 |
Laboratory | 0 | % 0 |
Application | 0 | % 0 |
Field Work | 0 | % 0 |
Special Course Internship (Work Placement) | 0 | % 0 |
Quizzes | 1 | % 20 |
Homework Assignments | 0 | % 0 |
Presentation | 0 | % 0 |
Project | 0 | % 0 |
Seminar | 0 | % 0 |
Midterms | 1 | % 25 |
Preliminary Jury | 0 | % 0 |
Final | 1 | % 55 |
Paper Submission | 0 | % 0 |
Jury | % 0 | |
Bütünleme | % 0 | |
Total | % 100 | |
PERCENTAGE OF SEMESTER WORK | % 45 | |
PERCENTAGE OF FINAL WORK | % 55 | |
Total | % 100 |
Activities | Number of Activities | Duration (Hours) | Workload |
Course Hours | 14 | 4 | 56 |
Laboratory | 0 | 0 | 0 |
Application | 14 | 2 | 28 |
Special Course Internship (Work Placement) | 0 | 0 | 0 |
Field Work | 0 | 0 | 0 |
Study Hours Out of Class | 14 | 3 | 42 |
Presentations / Seminar | 0 | 0 | 0 |
Project | 0 | 0 | 0 |
Homework Assignments | 0 | 0 | 0 |
Quizzes | 1 | 1 | 1 |
Preliminary Jury | 0 | ||
Midterms | 1 | 1 | 1 |
Paper Submission | 0 | ||
Jury | 0 | ||
Final | 1 | 1 | 1 |
Total Workload | 129 |
No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
Program Outcomes | Level of Contribution | |
1) | Students will have knowledge of fundemantals of mathemetaics and phsics | 5 |
2) | Students will have konowledge of relevant software and hardware requirements in the office environment | 4 |
3) | Having the ability to define and explain the fundemental concepts, principles and essentilas of software and having the ability to develop software. | 5 |
4) | Having the ability to use tools, machines and having the ability to recognize and diagnose problems in the related computer fields. | 1 |
5) | Having the ability to communicate efficiently in verbal and written Turkish, to know at least one foreign language in order to communicate with the colleagues and customers. | 4 |
6) | Having the ability to setup,diagnose and maintanance of databases | 5 |
7) | Having the ability to design graphical animations for desktop applications and internet programming. | |
8) | Having the ability to develop and control internet projects | 5 |
9) | Having the ability to develop group projects, team work, software and hardware projects | 3 |
10) | Having the ability to set up,diagnose operating systems and network systems | 3 |