|
|
| YBS1006 | Introduction to Database Systems | 2+1+0 | ECTS:5 | | Year / Semester | Spring Semester | | Level of Course | First Cycle | | Status | Compulsory | | Department | DEPARTMENT of MANAGEMENT INFORMATION SYSTEMS | | Prerequisites and co-requisites | None | | Mode of Delivery | | | Contact Hours | 14 weeks - 2 hours of lectures and 1 hour of practicals per week | | Lecturer | Dr. Öğr. Üyesi Mustafa Bilgehan İMAMOĞLU | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | In this course, practical applications are included alongside theoretical knowledge related to database systems. The course covers the fundamentals of database systems, the SQL language, the MsSQL database system, and advanced topics related to database systems. |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | Know database systems | 2,4,6 | 1,3, | | LO - 2 : | Design and create a relational database | 2,4,6 | 1,3, | | LO - 3 : | With the SQL language, can select data from the database. | 2,4,6 | | | LO - 4 : | To be able to add, delete and update data in the database with SQL language. | 2,4,6 | 1,3, | | LO - 5 : | Prepare raw data for suitable a database system. | 2,4,6 | | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome | | |
| Database Systems, Relational Database Model, MS SQL Server and SQL Server Management Studio, SQL Language, SQL Data Operations (selecting, inserting, deleting, updating data), SQL Table Operations (creating and modifying tables) |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Introduction to Database Systems | | | Week 2 | Basic Concepts | | | Week 3 | Relational Database Model | | | Week 4 | Database Systems and MsSQL | | | Week 5 | SQL(Select) | | | Week 6 | SQL(Insert) | | | Week 7 | SQL(Delete and Update) | | | Week 8 | SQL(select data with conditional statements) | | | Week 9 | Midterm exam | | | Week 10 | SQL(Create table) | | | Week 11 | SQL(Alter table) | | | Week 12 | Open data sources | | | Week 13 | Project (Defining the data and designing the database) | | | Week 14 | Project (Creating database and adding data) | | | Week 15 | Project (Query applications and reporting on database) | | | Week 16 | Final exam | | | |
| 1 | Veritabanı Yönetim Sistemleri-1, Ekin Yayınevi, Turgut ÖZSEVEN, 6. Baskı | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | 04/2024 | 1 | 50 | | End-of-term exam | 16 | 06/2024 | 1 | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | Yüz yüze eğitim | 3 | 14 | 42 | | Sınıf dışı çalışma | 1 | 14 | 14 | | Laboratuar çalışması | 0 | 0 | 0 | | Arasınav için hazırlık | 1 | 8 | 8 | | Arasınav | 1 | 1 | 1 | | Uygulama | 0 | 0 | 0 | | Klinik Uygulama | 0 | 0 | 0 | | Ödev | 0 | 0 | 0 | | Proje | 0 | 0 | 0 | | Kısa sınav | 0 | 0 | 0 | | Dönem sonu sınavı için hazırlık | 3 | 6 | 18 | | Dönem sonu sınavı | 1 | 1 | 1 | | Diğer 1 | 0 | 0 | 0 | | Diğer 2 | 0 | 0 | 0 | | Total work load | | | 84 |
|