| Course Name |
Database Systems
|
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
|
MBIL 103
|
Fall/Spring
|
2
|
2
|
3
|
5
|
| Prerequisites |
None
|
|||||
| Course Language |
Turkish
|
|||||
| Course Type |
Elective
|
|||||
| Course Level |
Short Cycle
|
|||||
| Mode of Delivery | - | |||||
| Teaching Methods and Techniques of the Course | Group WorkLecture / Presentation | |||||
| National Occupation Classification | - | |||||
| Course Coordinator | - | |||||
| Course Lecturer(s) | ||||||
| Assistant(s) | - | |||||
| Course Objectives | The objective of this course is to introduce students to the fundamental principles, concepts, and application areas of database systems. |
| Learning Outcomes |
The students who succeeded in this course;
|
| Course Description | The core content of this course will cover database design, programming, and management phases in detail to provide students with comprehensive and detailed knowledge regarding the design and programming processes 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 to Databases and SQL | Kaya, Y., Tekin, R., "Database and Applications", Papatya Publishing (2017) |
| 2 | Creating Databases, Creating Tables, Data Types, and Rules | Kaya, Y., Tekin, R., "Database and Applications", Papatya Publishing (2017) |
| 3 | Designing Databases Compliant with Normalization | Kaya, Y., Tekin, R., "Database and Applications", Papatya Publishing (2017) |
| 4 | Constraints in Databases | Kaya, Y., Tekin, R., "Database and Applications", Papatya Publishing (2017) |
| 5 | Inserting, Modifying, and Querying Data in Tables | Kaya, Y., Tekin, R., "Database and Applications", Papatya Publishing (2017) |
| 6 | Data Grouping and Data Filtering | Kaya, Y., Tekin, R., "Database and Applications", Papatya Publishing (2017) |
| 7 | Virtual Views (Views) in Databases | Köseoğlu, K., "Database Logic", Papatya Publishing (2005 |
| 8 | Midterm Exam | |
| 9 | Functions | Köseoğlu, K., "Database Logic", Papatya Publishing (2005 |
| 10 | Triggers | Köseoğlu, K., "Database Logic", Papatya Publishing (2005 |
| 11 | Procedures | Köseoğlu, K., "Database Logic", Papatya Publishing (2005 |
| 12 | Transactions | Köseoğlu, K., "Database Logic", Papatya Publishing (2005 |
| 13 | Project Presentations | |
| 14 | Project Presentations | |
| 15 | Semester Review | |
| 16 | Final Exam |
| Course Notes/Textbooks | Course slides, handouts, and digital source codes in SQL language. Köseoğlu, K., "Database Logic", Papatya Publishing (2005). ISBN: 9786052359624 |
| Suggested Readings/Materials | Kaya, Y., Tekin, R., "Database and Applications", Papatya Publishing (2017). ISBN: 9789756797785 |
| 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 |
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. |
-
|
-
|
-
|
-
|
-
|
|
| 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. |
-
|
-
|
-
|
-
|
-
|
|
| 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 |
-
|
-
|
-
|
-
|
-
|
|
| 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..