VOCATIONAL SCHOOL
Department of Computer Programming (Turkish)
MBP 108 | Course Introduction and Application Information
| Course Name |
Database Systems II
|
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
|
MBP 108
|
Spring
|
2
|
2
|
3
|
5
|
| Prerequisites |
None
|
|||||
| Course Language |
Turkish
|
|||||
| Course Type |
Required
|
|||||
| Course Level |
Short Cycle
|
|||||
| Mode of Delivery | face to face | |||||
| Teaching Methods and Techniques of the Course | Group WorkLecture / Presentation | |||||
| Course Coordinator | - | |||||
| Course Lecturer(s) | ||||||
| Assistant(s) | - | |||||
| Course Objectives | The aim of this course is to provide knowledge on basic principles, concepts and application areas of database systems |
| Learning Outcomes |
The students who succeeded in this course;
|
| Course Description | Design, programming and management of database systems |
|
|
Core Courses |
X
|
| Major Area Courses | ||
| Supportive Courses | ||
| Media and Management Skills Courses | ||
| Transferable Skill Courses |
WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES
| Week | Subjects | Related Preparation |
| 1 | Introduction | |
| 2 | Review of Database I | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017). Part 1-3 |
| 3 | Review of Database I | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017). Part 1-3 |
| 4 | Constraints | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 1 |
| 5 | Views | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 2 |
| 6 | Transactions | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 3 |
| 7 | Relational Database | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 4 |
| 8 | Midterm | |
| 9 | Functions | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 5 |
| 10 | Triggers | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 6 |
| 11 | Stored procedures | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 7 |
| 12 | Programming Lab | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 1-7 |
| 13 | Programming Lab 2 | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 1-7 |
| 14 | Programming Lab 3 | Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 1-7 |
| 15 | Review of the semester | |
| 16 | Final |
| Course Notes/Textbooks | Course slides, output and SQL language source codes in digital format Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). ISBN: 9786052359624 |
| Suggested Readings/Materials | Veri tabanı ve uygulamaları Yılmaz Kaya, Ramazan Tekin. Papatya yayınları. Veritabanı Mantığı, Kerem Köseoğlu, Papatya Yayıncılık |
EVALUATION SYSTEM
| Semester Activities | Number | Weigthing |
| Participation |
1
|
10
|
| Laboratory / Application | ||
| Field Work | ||
| Quizzes / Studio Critiques | ||
| Portfolio | ||
| Homework / Assignments | ||
| Presentation / Jury |
1
|
10
|
| Project |
1
|
20
|
| Seminar / Workshop | ||
| Oral Exams | ||
| Midterm |
1
|
20
|
| Final Exam |
1
|
40
|
| Total |
| Weighting of Semester Activities on the Final Grade |
4
|
60
|
| Weighting of End-of-Semester Activities on the Final Grade |
1
|
40
|
| Total |
ECTS / WORKLOAD TABLE
| Semester Activities | Number | Duration (Hours) | Workload |
|---|---|---|---|
| Theoretical Course Hours (Including exam week: 16 x total hours) |
16
|
2
|
32
|
| Laboratory / Application Hours (Including exam week: '.16.' x total hours) |
16
|
2
|
32
|
| Study Hours Out of Class |
16
|
2
|
32
|
| Field Work |
0
|
||
| Quizzes / Studio Critiques |
0
|
||
| Portfolio |
0
|
||
| Homework / Assignments |
0
|
||
| Presentation / Jury |
1
|
10
|
10
|
| Project |
1
|
10
|
10
|
| Seminar / Workshop |
0
|
||
| Oral Exam |
0
|
||
| Midterms |
1
|
16
|
16
|
| Final Exam |
1
|
18
|
18
|
| Total |
150
|
COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP
|
#
|
Program Competencies/Outcomes |
* Contribution Level
|
||||
|
1
|
2
|
3
|
4
|
5
|
||
| 1 | To be able to have basic computer hardware and software knowledge. |
X | ||||
| 2 | To be able to develop the necessary applications by using internet and network technologies. |
X | ||||
| 3 | To follow developments in the field to adapt to changing conditions. |
X | ||||
| 4 | To be able to conduct experiments in the field and analyze the results. |
X | ||||
| 5 | To be able to use basic programming languages related to the field. |
X | ||||
| 6 | To be able to design and install a computer system that includes software, hardware, or both, meeting the basic needs of the field. |
X | ||||
| 7 | To be able to interpret and follow current developments in the field of computer programming. |
|||||
| 8 | To be able to carry professional and ethical responsibility and have awareness of professional ethics in their practices. |
X | ||||
| 9 | To have basic theoretical and practical knowledge about mathematics, computing and computer science. |
|||||
| 10 | To be able to follow the information in the field and communicate with colleagues by using English at the general level of European Language Portfolio A2. |
|||||
| 11 | To be able to direct his/her education to a further level of education |
|||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
NEWS |ALL NEWS
'Success' formula of the masters
Former CEO of Turkcell and investor Süreyya Ciliv, who held senior positions in high technology companies, met with students at the "Students
'Digital' mobilization
Izmir University of Economics (IUE) started a 'digital transformation' movement in order for students to improve themselves in this field by not