| 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 | |||||
| National Occupation Classification | - | |||||
| 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 |
| Related Sustainable Development Goals |
|
|
|
Core Courses |
X
|
| Major Area Courses | ||
| Supportive Courses | ||
| Media and Management Skills Courses | ||
| Transferable Skill Courses |
| 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 |
| Semester Activities | Number | Weigthing |
| Participation | ||
| Laboratory / Application | ||
| Field Work | ||
| Quizzes / Studio Critiques | ||
| Portfolio | ||
| Homework / Assignments | ||
| Presentation / Jury | ||
| Project |
1
|
35
|
| Seminar / Workshop | ||
| Oral Exams | ||
| Midterm |
1
|
25
|
| Final Exam |
1
|
40
|
| Total |
| Weighting of Semester Activities on the Final Grade |
2
|
60
|
| Weighting of End-of-Semester Activities on the Final Grade |
1
|
40
|
| Total |
| 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 |
0
|
||
| Project |
1
|
18
|
18
|
| Seminar / Workshop |
0
|
||
| Oral Exam |
0
|
||
| Midterms |
1
|
16
|
16
|
| Final Exam |
1
|
20
|
20
|
| Total |
150
|
|
#
|
Program Competencies/Outcomes |
* Contribution Level
|
|||||
|
1
|
2
|
3
|
4
|
5
|
|||
| 1 |
To be able to have basic computer hardware and software knowledge. |
-
|
X
|
-
|
-
|
-
|
|
| 2 |
Explain web programming and network technologies and develop applications. |
X
|
-
|
-
|
-
|
-
|
|
| 3 |
Have written, verbal and non-verbal communication skills by doing team work. |
X
|
-
|
-
|
-
|
-
|
|
| 4 |
Do research, analyze and produce solutions for the problems encountered in the field. |
-
|
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 |
-
|
-
|
-
|
-
|
-
|
|
| 12 |
Have knowledge about occupational safety, environmental awareness and quality standards. |
-
|
-
|
-
|
-
|
-
|
|
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
As Izmir University of Economics transforms into a world-class university, it also raises successful young people with global competence.
More..Izmir University of Economics produces qualified knowledge and competent technologies.
More..Izmir University of Economics sees producing social benefit as its reason for existence.
More..