VOCATIONAL SCHOOL
Department of Computer Programming (Turkish)
MBP 203 | Course Introduction and Application Information
| Course Name |
Database and Management
|
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
|
MBP 203
|
Fall
|
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 | Application: Experiment / Laboratory / WorkshopLecture / Presentation | |||||
| Course Coordinator | - | |||||
| Course Lecturer(s) | ||||||
| Assistant(s) | - | |||||
| Course Objectives | The aim of this course is to provide students a deep knowledge and experience in database design, management and programming topics. |
| Learning Outcomes |
The students who succeeded in this course;
|
| Course Description | The content of this course includes entity-relationship database model, functional dependencies, primary key concept and also practical table creation, update and deletion processes in database server. |
|
|
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 to Database | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 1 |
| 2 | Introduction to SQL | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 1 |
| 3 | Data Types | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 1 |
| 4 | Table Creation | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 6 |
| 5 | Table Creation 2 | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 6 |
| 6 | Relational Database | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 2 |
| 7 | Relational Database 2 | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 2 |
| 8 | Midterm | |
| 9 | Data Grouping | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 8 |
| 10 | Data Grouping 2 | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 8 |
| 11 | Data Filtering | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 9 |
| 12 | Table Update | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 9 |
| 13 | Advanced Projects | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 10 |
| 14 | Reporting and Report Formatting | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 11 |
| 15 | Review of the semester | |
| 16 | Final |
| Course Notes/Textbooks | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015). ISBN: 9786053271574 |
| Suggested Readings/Materials |
EVALUATION SYSTEM
| Semester Activities | Number | Weigthing |
| Participation |
1
|
5
|
| Laboratory / Application | ||
| Field Work | ||
| Quizzes / Studio Critiques | ||
| Portfolio | ||
| Homework / Assignments |
1
|
10
|
| Presentation / Jury | ||
| Project |
1
|
20
|
| Seminar / Workshop | ||
| Oral Exams | ||
| Midterm |
1
|
25
|
| 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
|
1
|
16
|
| Field Work |
0
|
||
| Quizzes / Studio Critiques |
0
|
||
| Portfolio |
0
|
||
| Homework / Assignments |
1
|
10
|
10
|
| Presentation / Jury |
0
|
||
| Project |
1
|
20
|
20
|
| Seminar / Workshop |
0
|
||
| Oral Exam |
0
|
||
| Midterms |
1
|
15
|
15
|
| Final Exam |
1
|
20
|
20
|
| Total |
145
|
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. |
X | ||||
| 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