|
|
| IST3012 | Database Management Systems | 4+0+0 | ECTS:6 | | Year / Semester | Spring Semester | | Level of Course | First Cycle | | Status | Elective | | Department | DEPARTMENT of STATISTICS and COMPUTER SCIENCES | | Prerequisites and co-requisites | None | | Mode of Delivery | Face to face, Practical | | Contact Hours | 14 weeks - 4 hours of lectures per week | | Lecturer | Dr. Öğr. Üyesi Uğur ŞEVİK | | Co-Lecturer | None | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | The object of this course is to make students to learn Database Management accompanied by file processing and relational data models, query languages and basic relational operators. |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | understand database management systems better through MS Access and to use MS Access media | 7,9 | 1,3 | | LO - 2 : | plan and define a relational database with MsSQL | 8,9,11 | 1,3 | | LO - 3 : | use Visual C# for Database Applications | 4,7,8,9,11 | 1,3 | | LO - 4 : | use XML technologies with C# | 7,8,9,11 | 1,3 | | 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 | | |
| Basic Concepts, Purpose of DataBase Organization, Database System Structure, and Data Models: Hyra, Network, query and object oriented database models. Data definition, data processing, query languages, SQL, QBE, QUEL. Database design, logical, conceptual and physical models. Normalization. Database Interface and access methods. Database management, Operational necessity, safety integrity and database applications. |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Introduction to Database Systems | | | Week 2 | Relational database design | | | Week 3 | Relational algebra | | | Week 4 | Introduction to MS. Access | | | Week 5 | SQL structured query language | | | Week 6 | SQL functions | | | Week 7 | Analysis by grouping the data | | | Week 8 | Multiple tables | | | Week 9 | Mid-term exam | | | Week 10 | Complex queries | | | Week 11 | DML Operations | | | Week 12 | Database objects | | | Week 13 | Introduction to MS SQL | | | Week 14 | Introduction to Ado.Net | | | Week 15 | Csharp applications | | | Week 16 | End-of-term exam | | | |
| 1 | Yalçın ÖZKAN, 2006, Veri Tabanı Sistemleri, Alfa Yayınevi, İstanbul | | | |
| 1 | David Sceppa, 2006, Programming Microsoft ADO.NET 2.0, Microsoft Press, Washington | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 09 | 31/03/2012 | 1 | 30 | | Project | 13 | | 1 | 20 | | End-of-term exam | 16 | 01/06/2012 | 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 | 3 | 14 | 42 | | Arasınav için hazırlık | 4 | 1 | 4 | | Arasınav | 1 | 1 | 1 | | Proje | 6 | 4 | 24 | | Dönem sonu sınavı için hazırlık | 6 | 1 | 6 | | Dönem sonu sınavı | 1 | 1 | 1 | | Total work load | | | 120 |
|