BİLGİ PAKETİ / DERS KATALOĞU
| COMPUTER ENGINEERING (MASTER) (WITHOUT THESIS) | |||||
| Master | TR-NQF-HE: Level 7 | QF-EHEA: Second Cycle | EQF-LLL: Level 7 | ||
Ders Genel Tanıtım Bilgileri
| Course Code: | BMB 536 | ||||||||
| Ders İsmi: | Database Management Systems | ||||||||
| Ders Yarıyılı: | Fall | ||||||||
| Ders Kredileri: |
|
||||||||
| Language of instruction: | TR | ||||||||
| Ders Koşulu: | |||||||||
| Ders İş Deneyimini Gerektiriyor mu?: | No | ||||||||
| Type of course: | Bölüm Seçmeli | ||||||||
| Course Level: |
|
||||||||
| Mode of Delivery: | Face to face | ||||||||
| Course Coordinator : | Dr.Öğr.Üyesi ENDER ŞAHİNASLAN | ||||||||
| Course Lecturer(s): |
|
||||||||
| Course Assistants: |
Dersin Amaç ve İçeriği
| Course Objectives: | The aim of the database management systems course is to teach the basic concepts of the database, database management systems, entity-relationship model, fundamentals and design of relational data models, basic concepts and uses of structured query language (SQL). In this course, students will learn step by step how to design a relational database. A database project will be carried out within the scope of the course. |
| Course Content: | Database Systems and Basic Concepts, Data Models, Relational Database Model, Entity-Relationship Model, Database Tables and Normalization, Introduction to SQL Structured Query Language, SQL Operators, Advanced SELECT Queries, Virtual Tables, Advanced String Operators, SQL Functions, DML Operations, Database Project Sample Presentations |
Learning Outcomes
The students who have succeeded in this course;
|
||||||||||||||||||||||||||||||||||||||
Ders Akış Planı
| Week | Subject | Related Preparation |
| 1) | Database and Management Systems Basic Concepts - Basic concepts related to database, - Data access methods, - Database management systems, - Why should database management systems be preferred? - Database types, - Database users, - What is SQL? - Database Creation Stages | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 2) | Entity-Relationship Model Concepts - Concepts of existence and relationship, - Basic concepts of the entity-relationship model, - Mapping of assets and their types, - The concept of the condition of existence, - Key and super key and their functions, - Functions of entity-relationship diagrams, - Arrangement of entity-relationship diagrams, - Conversion of entity-relationship schemas to database tables. | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 3) | Relational Data Model and Relational Algebra Expressions - The concept of relational database and the properties of its main components, tables, - Database schema concept, - Concept of database integrity, - The importance of keys in integrity constraints, - Database limitation types, - Concept of relational algebra, - Basic operations in relational algebra. | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 4) | Database design stages, normalization and a sample database. | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 5) | Microsoft SQL Server - Entrance - History, - Server Structure, - Comparison with Other Databases, - Basic and Customized Versions - Replication, Analysis, Reporting, Integrity, - What is T-SQL? - MS SQL Server Installation. | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 6) | Structured Query Language (SQL) - Introduction to SQL structured query language, - Basic database concepts, - Basic data types, - Basic structure of the SELECT statement, - Use of arithmetic expressions in queries, - Checking rows with the same value, - Comparison operators, - Use of logical operators, - The order of operations of the operators, - Sorting of data. | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 7) | Use of SQL Functions - Function concept, - Location of functions in SQL, - Use of single line functions: character functions, numerical functions, Date functions. | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 8) | Midterm | Studying shared lecture presentations and auxiliary resources on the subject. |
| 9) | Grouping and Analyzing Data - Defining group functions, - Grouping operations, - Points to be considered in grouping operations, - Grouping by more than one column, - Definition of group conditions. | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 10) | T-SQL and View - Variable Types, - Variable Definition and Rules, - Assigning Values to Variables, - Stack Operations with T-SQL, - Control Statements in T-SQL, If-Else Statement, Case Statement, While Loop, Break Statement, Continue Statement. | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 11) | Stored Procedure - Stored Procedure (SP) Concept and Types - Creating and Running Stored Procedures - Using Parameters in Stored Procedures | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 12) | Transactions - Concept of Transaction in Database - Database Transaction Example - Transaction Rules - Operation of Transaction Block - Transaction Blocks - Server and Transaction | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 13) | Trigger - Trigger Concept in Database - Database Trigger Usage - Trigger Features - Trigger Operation - Creating a Trigger | Preparing for the course by reading helpful sources on the topics to be covered, researching and examining them on the internet, and watching educational videos. |
| 14) | Database Project Presentations | Database Project Study Presentation |
Sources
| Course Notes / Textbooks: | Ders sunumları ve yardımcı kaynaklar |
| References: | - Peter Rob and Carlos Coronel, “Database Systems: Design, Implementation and Management (7th edition), Thomson Learning, 2007. - Yaşar Gözüdeli, “Yazılımcılar için SQL Server 2014 ve Veritabanı Programlama”, 8. Baskı, Seçkin Yayınevi, 2014. - Atatürk Üniversitesi, «Veri Tabanı Yönetim Sistemleri» ders kitabı. - Anadolu Üniversitesi, «Veritabanı Sistemleri» ders kitap ve notları. https://ddp.anadolu.edu.tr/#/home - Anadolu Üniversitesi, «Veritabanı Programlama» ders kitap ve notları. https://ddp.anadolu.edu.tr/#/home - BTK Akademi: https://www.btkakademi.gov.tr/portal - Microsoft SQL Server programı: https://www.microsoft.com/tr-tr/sql-server/sql-server-downloads |
Ders - Program Öğrenme Kazanım İlişkisi
| Ders Öğrenme Kazanımları | 1 |
2 |
3 |
4 |
5 |
6 |
7 |
|||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Program Outcomes | ||||||||||||
| 1) Having comprehensive knowledge in information systems development, including planning, analysis, design and configuration stages, and familiarity with relevant development methods and modeling tools. | ||||||||||||
| 2) Having comprehensive knowledge to perform advanced applications in the field of computer engineering. | ||||||||||||
| 3) Ability to access, evaluate and apply information by conducting applied research in the field of Information and Communication Technologies, and integrate information from different disciplines. | ||||||||||||
| 4) Discovering, drawing conclusions, sharing and applying knowledge with scientific methods in different fields; Relating information from different disciplines. | ||||||||||||
| 5) Ability to independently carry out a study that requires expertise in the field of information technologies. | ||||||||||||
| 6) Ability to develop new strategic approaches to solve unforeseen complex problems encountered in applications related to the field of Information and Communication Technologies and to produce solutions by taking responsibility. | ||||||||||||
| 7) Ability to take leadership in environments that require solving problems related to the field of Information and Communication Technologies. | ||||||||||||
| 8) To be able to critically evaluate the expert knowledge and skills acquired in the field of Computer Engineering and to direct his/her learning. | ||||||||||||
| 9) Being aware of current studies in the field of Computer Engineering, constantly following the developments, examining and naming them when necessary. | ||||||||||||
| 10) Communicating effectively verbally and in writing in Turkish and English. | ||||||||||||
| 11) Observing social, scientific and ethical values in their work. | ||||||||||||
| 12) Ability to develop strategies, policies and implementation plans on issues related to Information Technologies and evaluate the results obtained within the framework of quality processes. | ||||||||||||
| 13) Ability to use the knowledge, problem solving and/or application skills they have absorbed in the field of Computer Engineering in interdisciplinary studies. | ||||||||||||
Ders - Öğrenme Kazanımı İlişkisi
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | Having comprehensive knowledge in information systems development, including planning, analysis, design and configuration stages, and familiarity with relevant development methods and modeling tools. | 4 |
| 2) | Having comprehensive knowledge to perform advanced applications in the field of computer engineering. | 4 |
| 3) | Ability to access, evaluate and apply information by conducting applied research in the field of Information and Communication Technologies, and integrate information from different disciplines. | 5 |
| 4) | Discovering, drawing conclusions, sharing and applying knowledge with scientific methods in different fields; Relating information from different disciplines. | 5 |
| 5) | Ability to independently carry out a study that requires expertise in the field of information technologies. | 1 |
| 6) | Ability to develop new strategic approaches to solve unforeseen complex problems encountered in applications related to the field of Information and Communication Technologies and to produce solutions by taking responsibility. | 3 |
| 7) | Ability to take leadership in environments that require solving problems related to the field of Information and Communication Technologies. | 2 |
| 8) | To be able to critically evaluate the expert knowledge and skills acquired in the field of Computer Engineering and to direct his/her learning. | 2 |
| 9) | Being aware of current studies in the field of Computer Engineering, constantly following the developments, examining and naming them when necessary. | 1 |
| 10) | Communicating effectively verbally and in writing in Turkish and English. | |
| 11) | Observing social, scientific and ethical values in their work. | |
| 12) | Ability to develop strategies, policies and implementation plans on issues related to Information Technologies and evaluate the results obtained within the framework of quality processes. | 1 |
| 13) | Ability to use the knowledge, problem solving and/or application skills they have absorbed in the field of Computer Engineering in interdisciplinary studies. | 4 |
Öğrenme Etkinliği ve Öğretme Yöntemleri
| Alan Çalışması | |
| Anlatım | |
| Beyin fırtınası /Altı şapka | |
| Bireysel çalışma ve ödevi | |
| Course | |
| Okuma | |
| Homework | |
| Problem Çözme | |
| Proje Hazırlama | |
| Rapor Yazma | |
| Soru cevap/ Tartışma | |
| Örnek olay çalışması | |
| Web Tabanlı Öğrenme |
Ölçme ve Değerlendirme Yöntemleri ve Kriterleri
| Yazılı Sınav (Açık uçlu sorular, çoktan seçmeli, doğru yanlış, eşleştirme, boşluk doldurma, sıralama) | |
| Sözlü sınav | |
| Homework | |
| Uygulama | |
| Gözlem | |
| Bireysel Proje | |
| Sunum | |
| Bilgisayar Destekli Sunum | |
| Örnek olay sunma |
Assessment & Grading
| Semester Requirements | Number of Activities | Level of Contribution |
| Homework Assignments | 2 | % 10 |
| Presentation | 1 | % 5 |
| Project | 1 | % 20 |
| Midterms | 1 | % 25 |
| Final | 1 | % 40 |
| total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 60 | |
| PERCENTAGE OF FINAL WORK | % 40 | |
| total | % 100 | |
İş Yükü ve AKTS Kredisi Hesaplaması
| Activities | Number of Activities | Duration (Hours) | Workload |
| Course Hours | 14 | 3 | 42 |
| Application | 1 | 20 | 20 |
| Special Course Internship (Work Placement) | 1 | 2 | 2 |
| Field Work | 1 | 6 | 6 |
| Study Hours Out of Class | 14 | 4 | 56 |
| Presentations / Seminar | 1 | 1 | 1 |
| Project | 1 | 60 | 60 |
| Homework Assignments | 1 | 2 | 2 |
| Midterms | 1 | 30 | 30 |
| Paper Submission | 1 | 1 | 1 |
| Final | 1 | 40 | 40 |
| Total Workload | 260 | ||