FACULTY OF ENGINEERING
GEOMATICS ENGINEERING
Course Name   DATABASES IN ENGINEERING
Semester Course Code Theoretical / Practice time ECTS
3 1205325 2 / 0 3
Course Degree Bachelor's degree
Course Language Turkish
Format of Delivery: Face to Face
Course Coordinator Prof.Dr.Hakan KARABÖRK
Coordinator e-mail hkarabork selcuk.edu.tr
Instructors
Yrd. Doç.Dr. Şükran YALPIR
Asistant Instructors
Course Objectives The purpose of this course is to introduce basic database structures and database management systems with the basic query language SQL language..
Basic Sciences Engineering Scinces Social Sciences Educational Sciences Artistic sciences Medical Science Agricultural sciences
40 60 0 0 0 0 0
Course Learning Methods and Techniquies
Teaching in classroom, application using computer
Week Course Content Resource
1 Basic Concepts in Data Base Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
2 Entity Relationship Model Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
3 Relational Data Model Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
4 Relational Database Design Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
5 Relational Algebra Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
6 SQL (Structured Query Language) Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
7 Using SQL Functions Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
8 Analyzing the data by grouping Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
9 Multiple Tables Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
10 Mid-term Exam
11 Complex Queries Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
12 Multi-Line Sub-Queries Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
13 DML (Data Manipulation Language) Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
14 Adding restrictions Statements Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
15 Controlling User Access Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000 : R. Ramakrishnan, Data Base Management Systems, Mc Graw Hill, 2002. : R. Elmasri, S. Navathe, Fundamentals of Database Systems, Third Edition, Addison ? Wesley, 2000 : Graeme C. Simsion, Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005
Assesment Criteria   Mid-term exam Final exam
  Quantity Percentage Quantity Percentage  
Term Studies : - - - -
Attendance / Participation : - - - -
Practical Exam : - - - -
Special Course Exam : - - - -
Quiz : - - - -
Homework : - - - -
Presentations and Seminars : - - - -
Projects : - - - -
Workshop / Laboratory Applications : - - - -
Case studies : - - - -
Field Studies : - - - -
Clinical Studies : - - - -
Other Studies : - - - -
Mid-term exam   1 40 - -
Final exam   - - 1 60
ECTS WORK LOAD TABLE   Number Duration
Course Duration : 14 2
Classroom Work Time : 14 2
Presentations and Seminars : - -
Course Internship : - -
Workshop / Laboratory Applications : - -
Field Studies : - -
Case studies : - -
Projects : - -
Homework : - -
Quiz : - -
Mid-term exam : 1 14
Final Exam : 1 20
ECTS 3
No COURSE LEARNING OUTCOMES CONTRIBUTION
D.Ö.Ç. 1 Able to describe the basic concepts for database 4
D.Ö.Ç. 2 Able to define components of relational databases 4
D.Ö.Ç. 3 Able to understand database models 4
D.Ö.Ç. 4 Able to describe database normalization 3
D.Ö.Ç. 5 Ability to design database 3
D.Ö.Ç. 6 The ability to use the SQL language at a basic level 3
* 1: Zayıf - 2: Orta - 3: İyi - 4: Çok İyi
COURSE LEARNING OUTCOMES AND PROGRAM OUTCOMES AND RELATIONSHIPS MATRIX

DÖÇ1DÖÇ2DÖÇ3DÖÇ4DÖÇ5DÖÇ6DÖÇ7DÖÇ8DÖÇ9DÖÇ10DÖÇ11DÖÇ12DÖÇ13DÖÇ14DÖÇ15DÖÇ16DÖÇ17DÖÇ18DÖÇ19DÖÇ20
PÇ1
PÇ2
PÇ3
PÇ4
PÇ5
PÇ6
PÇ7
PÇ8
PÇ9
PÇ10
PÇ11
PÇ12
PÇ13
PÇ14
PÇ15
PÇ16
PÇ17
PÇ18
PÇ19
PÇ20