Course Detail
Course Description
| Course | Code | Semester | T+P (Hour) | Credit | ECTS |
|---|---|---|---|---|---|
| DATA BASE and DATA BASE MANAGEMENT SYSTEMS | - | Fall Semester | 3+0 | 3 | 4 |
| Course Program |
| Prerequisites Courses | |
| Recommended Elective Courses |
| Language of Course | Turkish |
| Course Level | First Cycle (Bachelor's Degree) |
| Course Type | Required |
| Course Coordinator | Assist.Prof. Kevser ŞAHİNBAŞ |
| Name of Lecturer(s) | Assist.Prof. Kevser ŞAHİNBAŞ |
| Assistant(s) | |
| Aim | To teach of the database and the fact that the database is the basic element of a software and also teaching the students the platforms that will use this language by effectively bringing the SQL language to the students. |
| Course Content | This course contains; Introduction to Database Systems, Prevention of data redundancy and data inconsistency. The importance of concurrent access,Entity Relational Model, Relational Model, Bensne Based Vevey Design Concepts.,Database schema design Primary key, attribute, registration concepts. Concurrent access suitable scheme design.,Relational algebraic, logic used in database queries, and mathematical methods.,SQL: Select, union, distinct, where, having, group by concepts and sample queries.,SQL: Inner join, outer join, bulk select concepts and sample queries.,Database Design with MS SQL,Midterm,Database Design with MS SQL, sample application development,Web based database design,Web based database design, sample application development,Database security, access management,Database security, access management,General Repetition and Evaluation of Student Projects. |
| Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
| 1. will be able to learn database concept and file systems. | 9 | A |
| 1.1. Defines the concept of data. | 6, 9 | A |
| 1.2. Lists file systems. | 6 | A |
| 2. will be able to understand the advantages of database management system. | 6, 9 | A |
| 2..2. Simultaneous access explorations. | 6, 9 | A |
| 2.1. Defines atomicity. | 6, 9 | A |
| 2.3. Explains data security. | 6, 9 | A |
| 2.4. Explores the ease of finding data in the framework of DB. | 6 | A |
| 3. will be able to schematically set up the relational model for any software. | 2, 6 | A |
| 3.1. Lists the basic properties of the relational database. | 6 | A |
| 3.2. Explains the concepts of relationship and key. | 6 | A |
| 4. Will be able to query on the database in SQL language. | 2, 6 | A |
| 4.1. Performs add, delete, update operations with SQL commands. | 6 | A |
| 4.2. Explains the operators and tasks used in the SQL. | 6 | A |
| 4.3. Applies the filtering operations on the data. | 6 | A |
| 4.4. Uses interrogation inside. | 6 | A |
| 5. Will be able to use SQL language in languages such as C #, VB. | 5, 6 | A |
| 5.1. Runs the SQL Server services. | 6 | A |
| 5.2. Develops views. | 6 | A |
| 6. will be able to design web based database applications. | 6 | A |
| 6.1. Inserts database connection. | 6 | A |
| 6.2. Designs own functions. | 6 | A |
| 7. will be able to look at the whole software with the database. | 6 | A |
| 7.1. Develops advanced SQL commands. | 6 | A |
| Teaching Methods: | 2: Project Based Learning Model, 5: Cooperative Learning, 6: Experiential Learning, 9: Lecture Method |
| Assessment Methods: | A: Traditional Written Exam |
Course Outline
| Order | Subjects | Preliminary Work |
|---|---|---|
| 1 | Introduction to Database Systems, Prevention of data redundancy and data inconsistency. The importance of concurrent access | Related chapter in the course book should be read. |
| 2 | Entity Relational Model, Relational Model, Bensne Based Vevey Design Concepts. | Related chapter in the course book should be read. |
| 3 | Database schema design Primary key, attribute, registration concepts. Concurrent access suitable scheme design. | Related chapter in the course book should be read. |
| 4 | Relational algebraic, logic used in database queries, and mathematical methods. | Related chapter in the course book should be read. |
| 5 | SQL: Select, union, distinct, where, having, group by concepts and sample queries. | Related chapter in the course book should be read. |
| 6 | SQL: Inner join, outer join, bulk select concepts and sample queries. | Related chapter in the course book should be read. |
| 7 | Database Design with MS SQL | Applied sample |
| 8 | Midterm | |
| 9 | Database Design with MS SQL, sample application development | Related chapter in the course book should be read. |
| 10 | Web based database design | Related chapter in the course book should be read. |
| 11 | Web based database design, sample application development | sample application |
| 12 | Database security, access management | Related chapter in the course book should be read. |
| 13 | Database security, access management | Related chapter in the course book should be read. |
| 14 | General Repetition and Evaluation of Student Projects |
| Resources |
| Veritabanı Sistemleri Dersi: Teoriden Pratiğe, N. ERCİL-ÇAĞILTAY ve G. TOKDEMİR, 2010 |
| Reading List 1. Veritabanı kavramı ve MS-SQL uygulamaları, Telciler, Coşkun, yazar, 2013 2. Database Mangement Systems, R. Ramakrishnan, J.Gehrke, Third Edition – Mc Graw Hill. 3. Database System Concepts Avi Silberschatz, Henry F. Korth, S. SudarshanSeventh Edition, 2019 |
Course Contribution to Program Qualifications
| Course Contribution to Program Qualifications | |||||||
| No | Program Qualification | Contribution Level | |||||
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | Defines the theoretical issues in the field of information and management. | ||||||
| 2 | Describes the necessary mathematical and statistical methods in the field of information and management. | ||||||
| 3 | Uses at least one computer program in the field of information and management. | X | |||||
| 4 | Sustains proficiency in a foreign language requiredor information and management studies. | ||||||
| 5 | Prepares informatics/software projects and work in a team. | X | |||||
| 6 | Constantly updates himself / herself by following developments in science and technology with an understanding of the importance of lifelong learning through critically evaluating the knowledge and skills that s/he has got.7. Uses theoretical and practical expertise in the field of information and management | X | |||||
| 7 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication skills. | ||||||
| 8 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication. | ||||||
| 9 | Adopts organizational / institutional and social ethical values. | ||||||
| 10 | Within the framework of community involvement adopts social responsibility principles and takes initiative when necessary. | ||||||
| 11 | Uses and analyses basic facts and data in various disciplines (economics, finance, sociology, law, business) in order to conduct interdisciplinary studies. | ||||||
| 12 | Writes software in different platforms such as desktop, mobile, web on its own and / or in a team. | X | |||||
Assessment Methods
| Contribution Level | Absolute Evaluation | |
| Rate of Midterm Exam to Success | 40 | |
| Rate of Final Exam to Success | 60 | |
| Total | 100 | |
| ECTS / Workload Table | ||||||
| Activities | Number of | Duration(Hour) | Total Workload(Hour) | |||
| Course Hours | 14 | 3 | 42 | |||
| Guided Problem Solving | 0 | 0 | 0 | |||
| Resolution of Homework Problems and Submission as a Report | 0 | 0 | 0 | |||
| Term Project | 0 | 0 | 0 | |||
| Presentation of Project / Seminar | 1 | 40 | 40 | |||
| Quiz | 0 | 0 | 0 | |||
| Midterm Exam | 1 | 10 | 10 | |||
| General Exam | 1 | 20 | 20 | |||
| Performance Task, Maintenance Plan | 0 | 0 | 0 | |||
| Total Workload(Hour) | 112 | |||||
| Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(112/30) | 4 | |||||
| ECTS of the course: 30 hours of work is counted as 1 ECTS credit. | ||||||
Detail Informations of the Course
Course Description
| Course | Code | Semester | T+P (Hour) | Credit | ECTS |
|---|---|---|---|---|---|
| DATA BASE and DATA BASE MANAGEMENT SYSTEMS | - | Fall Semester | 3+0 | 3 | 4 |
| Course Program |
| Prerequisites Courses | |
| Recommended Elective Courses |
| Language of Course | Turkish |
| Course Level | First Cycle (Bachelor's Degree) |
| Course Type | Required |
| Course Coordinator | Assist.Prof. Kevser ŞAHİNBAŞ |
| Name of Lecturer(s) | Assist.Prof. Kevser ŞAHİNBAŞ |
| Assistant(s) | |
| Aim | To teach of the database and the fact that the database is the basic element of a software and also teaching the students the platforms that will use this language by effectively bringing the SQL language to the students. |
| Course Content | This course contains; Introduction to Database Systems, Prevention of data redundancy and data inconsistency. The importance of concurrent access,Entity Relational Model, Relational Model, Bensne Based Vevey Design Concepts.,Database schema design Primary key, attribute, registration concepts. Concurrent access suitable scheme design.,Relational algebraic, logic used in database queries, and mathematical methods.,SQL: Select, union, distinct, where, having, group by concepts and sample queries.,SQL: Inner join, outer join, bulk select concepts and sample queries.,Database Design with MS SQL,Midterm,Database Design with MS SQL, sample application development,Web based database design,Web based database design, sample application development,Database security, access management,Database security, access management,General Repetition and Evaluation of Student Projects. |
| Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
| 1. will be able to learn database concept and file systems. | 9 | A |
| 1.1. Defines the concept of data. | 6, 9 | A |
| 1.2. Lists file systems. | 6 | A |
| 2. will be able to understand the advantages of database management system. | 6, 9 | A |
| 2..2. Simultaneous access explorations. | 6, 9 | A |
| 2.1. Defines atomicity. | 6, 9 | A |
| 2.3. Explains data security. | 6, 9 | A |
| 2.4. Explores the ease of finding data in the framework of DB. | 6 | A |
| 3. will be able to schematically set up the relational model for any software. | 2, 6 | A |
| 3.1. Lists the basic properties of the relational database. | 6 | A |
| 3.2. Explains the concepts of relationship and key. | 6 | A |
| 4. Will be able to query on the database in SQL language. | 2, 6 | A |
| 4.1. Performs add, delete, update operations with SQL commands. | 6 | A |
| 4.2. Explains the operators and tasks used in the SQL. | 6 | A |
| 4.3. Applies the filtering operations on the data. | 6 | A |
| 4.4. Uses interrogation inside. | 6 | A |
| 5. Will be able to use SQL language in languages such as C #, VB. | 5, 6 | A |
| 5.1. Runs the SQL Server services. | 6 | A |
| 5.2. Develops views. | 6 | A |
| 6. will be able to design web based database applications. | 6 | A |
| 6.1. Inserts database connection. | 6 | A |
| 6.2. Designs own functions. | 6 | A |
| 7. will be able to look at the whole software with the database. | 6 | A |
| 7.1. Develops advanced SQL commands. | 6 | A |
| Teaching Methods: | 2: Project Based Learning Model, 5: Cooperative Learning, 6: Experiential Learning, 9: Lecture Method |
| Assessment Methods: | A: Traditional Written Exam |
Course Outline
| Order | Subjects | Preliminary Work |
|---|---|---|
| 1 | Introduction to Database Systems, Prevention of data redundancy and data inconsistency. The importance of concurrent access | Related chapter in the course book should be read. |
| 2 | Entity Relational Model, Relational Model, Bensne Based Vevey Design Concepts. | Related chapter in the course book should be read. |
| 3 | Database schema design Primary key, attribute, registration concepts. Concurrent access suitable scheme design. | Related chapter in the course book should be read. |
| 4 | Relational algebraic, logic used in database queries, and mathematical methods. | Related chapter in the course book should be read. |
| 5 | SQL: Select, union, distinct, where, having, group by concepts and sample queries. | Related chapter in the course book should be read. |
| 6 | SQL: Inner join, outer join, bulk select concepts and sample queries. | Related chapter in the course book should be read. |
| 7 | Database Design with MS SQL | Applied sample |
| 8 | Midterm | |
| 9 | Database Design with MS SQL, sample application development | Related chapter in the course book should be read. |
| 10 | Web based database design | Related chapter in the course book should be read. |
| 11 | Web based database design, sample application development | sample application |
| 12 | Database security, access management | Related chapter in the course book should be read. |
| 13 | Database security, access management | Related chapter in the course book should be read. |
| 14 | General Repetition and Evaluation of Student Projects |
| Resources |
| Veritabanı Sistemleri Dersi: Teoriden Pratiğe, N. ERCİL-ÇAĞILTAY ve G. TOKDEMİR, 2010 |
| Reading List 1. Veritabanı kavramı ve MS-SQL uygulamaları, Telciler, Coşkun, yazar, 2013 2. Database Mangement Systems, R. Ramakrishnan, J.Gehrke, Third Edition – Mc Graw Hill. 3. Database System Concepts Avi Silberschatz, Henry F. Korth, S. SudarshanSeventh Edition, 2019 |
Course Contribution to Program Qualifications
| Course Contribution to Program Qualifications | |||||||
| No | Program Qualification | Contribution Level | |||||
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | Defines the theoretical issues in the field of information and management. | ||||||
| 2 | Describes the necessary mathematical and statistical methods in the field of information and management. | ||||||
| 3 | Uses at least one computer program in the field of information and management. | X | |||||
| 4 | Sustains proficiency in a foreign language requiredor information and management studies. | ||||||
| 5 | Prepares informatics/software projects and work in a team. | X | |||||
| 6 | Constantly updates himself / herself by following developments in science and technology with an understanding of the importance of lifelong learning through critically evaluating the knowledge and skills that s/he has got.7. Uses theoretical and practical expertise in the field of information and management | X | |||||
| 7 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication skills. | ||||||
| 8 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication. | ||||||
| 9 | Adopts organizational / institutional and social ethical values. | ||||||
| 10 | Within the framework of community involvement adopts social responsibility principles and takes initiative when necessary. | ||||||
| 11 | Uses and analyses basic facts and data in various disciplines (economics, finance, sociology, law, business) in order to conduct interdisciplinary studies. | ||||||
| 12 | Writes software in different platforms such as desktop, mobile, web on its own and / or in a team. | X | |||||
Assessment Methods
| Contribution Level | Absolute Evaluation | |
| Rate of Midterm Exam to Success | 40 | |
| Rate of Final Exam to Success | 60 | |
| Total | 100 | |