Mersin Üniversitesi
Ders Bilgileri
| DATABASE MANAGEMENT | ||||||
|---|---|---|---|---|---|---|
| Kodu | Dönemi | Teori | Uygulama | Ulusal Kredisi | AKTS Kredisi | |
| Saat / Hafta | ||||||
| İBY307 | Fall | 3 | 0 | 3 | 4 | |
| Ön Koşulu Olan Ders( ler ) | None |
| Dili | en |
| Türü | Required |
| Seviyesi | Bachelor's |
| Öğretim Elemanı( ları ) | Inst. Jale BEKTAŞ |
| Öğretim Sistemi | Face to Face |
| Önerilen Hususlar | None |
| Staj Durumu | None |
| Amacı | The aim of this course is to make students recognize relational database model introducing the database concept and make them analyze data with basic database objects using SQL. |
| İçeriği | Descriptions and basic concepts, entity-relationship model, Relational data model, Relational algebra and accounting, SQL Structured Query Language logical operations(Selecting, throwing, joining, constraints, grouping, ordering, character based operations, multi tables, condition operations). SQL Structured Query Language physical operations (Data insert, update, delete). Database backup and security. |
Dersin Öğrenim Çıktıları
| # | Öğrenim Çıktıları |
|---|---|
| 1 | Recognize database management systems. |
| 2 | Analyzes database with entity-relationship diagrams. |
| 3 | Recognizes basic database objects. |
| 4 | Questions databases logically with SQL(Structured Query Language). |
| 5 | Defines physical transformations techniques over databases. |
| 6 | Develops database applications. |
| 7 | Constructs security programmes over databases. |
| 8 | Illustrates database architecture according to data-centric software. |
Haftalık Ayrıntılı Ders İçeriği
| # | Konular | Öğretim Yöntem ve Teknikleri |
|---|---|---|
| 1 | Descriptions and basic concepts. | Lectures, discussion |
| 2 | Entity-relationship model, relational data model, relational algebra and accounting | Lectures, discussion |
| 3 | SQL structured query language logical operations (Selecting, throwing, joining) | Lectures, discussion |
| 4 | SQL structured query language logical operations (Constraints) | Lectures, discussion |
| 5 | SQL structured query language logical operations (Grouping functions and grouping) | Lectures, discussion |
| 6 | SQL structured query language logical operations (Ordering and character operations) | Lectures, discussion |
| 7 | SQL structured query language logical operations (Multi tables) | Lectures, discussion |
| 8 | Mid-term examination | Written examination |
| 9 | SQL s tructured query language logical operations (Wrtinig conditions) | Lectures, discussion |
| 10 | SQL structured query language physical operations (Data insert, delete, update) | Lectures, discussion |
| 11 | SQL structured query language physical operations (Data insert, delete, update) | Lectures, discussion |
| 12 | SQL structured query language physical operations (Data insert, delete, update) | Application |
| 13 | Developing database application | Application |
| 14 | Database backup and database security | Lectures, discussion |
| 15 | Developing database application | Application |
| 16 | Final Exam | Written examination |
Resources
| # | Malzeme / Kaynak Adı | Kaynak Hakkında Bilgi | Referans / Önerilen Kaynak |
|---|---|---|---|
| 1 | Veritabanı Sistemleri I Mersin Üniversitesi, Ders Notu | ||
| 2 | Yaşar Gözüdeli, Yazılımcılar İçin SQL Server 2008 ve Veritabanı Programlama, Seçkin Yayıncılık, 2009, Ankara. | ||
| 3 | Turgut Özseven, Veritabanı yönetim Sistemleri I, Murathan Yayınları, 2010, Trabzon. | ||
| 4 | Gehrke Ramakrishnan, Database Management Systems, McGraw-Hill, 2003. |
Ölçme ve Değerlendirme Sistemi
| # | Ağırlık | Çalışma Türü | Çalışma Adı |
|---|---|---|---|
| 1 | 0.3 | 1 | 1. Mid-Term Exam |
| 2 | 0.05 | 3 | 1. Homework |
| 3 | 0.05 | 3 | 2. Homework |
| 4 | 0.6 | 5 | Final Exam |
Dersin Öğrenim Çıktıları ve Program Yeterlilikleri ile İlişkileri
| # | Öğrenim Çıktıları | Program Çıktıları | Ölçme ve Değerlendirme |
|---|---|---|---|
| 1 | Recognize database management systems. | 1͵7 | 1 |
| 2 | Analyzes database with entity-relationship diagrams. | 7 | 1 |
| 3 | Recognizes basic database objects. | 1͵7 | 1 |
| 4 | Questions databases logically with SQL(Structured Query Language). | 7 | 1 |
| 5 | Defines physical transformations techniques over databases. | 7 | 1 |
| 6 | Develops database applications. | 7 | 1͵3 |
| 7 | Constructs security programmes over databases. | 1͵7 | 1 |
| 8 | Illustrates database architecture according to data-centric software. | 7 | 1 |
Not: Ölçme ve Değerlendirme sütununda belirtilen sayılar, bir üstte bulunan Ölçme ve Değerlerndirme Sistemi başlıklı tabloda belirtilen çalışmaları işaret etmektedir.
İş Yükü Detayları
| # | Etkinlik | Adet | Süre (Saat) | İş Yükü |
|---|---|---|---|---|
| 0 | Course Duration | 14 | 3 | 42 |
| 1 | Course Duration Except Class (Preliminary Study, Enhancement) | 14 | 4 | 56 |
| 2 | Presentation and Seminar Preparation | 0 | 0 | 0 |
| 3 | Web Research, Library and Archival Work | 0 | 0 | 0 |
| 4 | Document/Information Listing | 0 | 0 | 0 |
| 5 | Workshop | 0 | 0 | 0 |
| 6 | Preparation for Midterm Exam | 1 | 8 | 8 |
| 7 | Midterm Exam | 1 | 1 | 1 |
| 8 | Quiz | 0 | 0 | 0 |
| 9 | Homework | 2 | 6 | 12 |
| 10 | Midterm Project | 0 | 0 | 0 |
| 11 | Midterm Exercise | 0 | 0 | 0 |
| 12 | Final Project | 1 | 0 | 0 |
| 13 | Final Exercise | 0 | 0 | 0 |
| 14 | Preparation for Final Exam | 1 | 10 | 10 |
| 15 | Final Exam | 1 | 1 | 1 |
| 130 | ||||