| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | 6012001122010 | DATABASE-I | Compulsory | 1 | 2 | 4 |
|
| Level of Course Unit |
| Short Cycle |
| Language of Instruction |
| Turkish |
| Objectives of the Course |
| The aim of this course is to make students gain the ability to design and create databases, writing queries and using the database administartion functions. |
| Name of Lecturer(s) |
| Öğr. Gör. Yeşim AKTAŞ |
| Learning Outcomes |
| 1 | Designing database | | 2 | Creating database | | 3 | Querying in database | | 4 | Using database administrative functions |
|
| Mode of Delivery |
| Face to Face |
| Prerequisites and co-requisities |
| None |
| Recommended Optional Programme Components |
| None |
| Course Contents |
| Database requirement analysis, Normalization, Setting up database tools, Creating tables and determining its properties, Creating queries and using different types of queries, Creating queries with relational tables, Using DML queries, Writing user queries, Writing trigger queries, Writing stored procedure queries, Transaction operations, Writing index queries. |
| Weekly Detailed Course Contents |
|
| 1 | Database requirement analysis, normalization | Problem Session | | | 2 | Normalization | Problem Session | | | 3 | Normalization | Problem Session | | | 4 | Setting up database tools, creating tables and determining properties | Problem Session | | | 5 | Creating tables and determining properties | Problem Session | | | 6 | Creating tables and determining properties | Problem Session | | | 7 | Creating queries and using different query types | Problem Session | | | 8 | Midterm Exam | Assessment | | | 9 | Creating queries and using different query types, creating queries with relational tables | Problem Session | | | 10 | Creating queries with relational tables | Problem Session | | | 11 | Using DML queries | Problem Session | | | 12 | Using DML queries, writing user queries | Problem Session | | | 13 | Writing view and trigger queries | Problem Session | | | 14 | Writing trigger and stored procedure queries | Problem Session | | | 15 | Transaction operations and writing index queries | Problem Session | | | 16 | Final Exam | Assessment | |
|
| Recommended or Required Reading |
| Daşdemir Y., Veritabanı Yönetim Sistemleri, Türkmen Kitabevi, 2004.
Groff J.R., Weinberg P.N, Herkes İçin SQL, Alfa Yayıncılık, 2003. |
| Planned Learning Activities and Teaching Methods |
|
| Assessment Methods and Criteria | |
| Midterm Examination | 1 | 100 | | SUM | 100 | |
| Final Examination | 1 | 100 | | SUM | 100 | | Term (or Year) Learning Activities | 40 | | End Of Term (or Year) Learning Activities | 60 | | SUM | 100 |
| | Work Placement(s) | | None |
|
| Workload Calculation |
|
| Midterm Examination | 1 | 1 | 1 |
| Final Examination | 1 | 1 | 1 |
| Attending Lectures | 14 | 3 | 42 |
| Practice | 14 | 1 | 14 |
| Individual Study for Homework Problems | 8 | 2 | 16 |
| Individual Study for Mid term Examination | 1 | 12 | 12 |
| Individual Study for Final Examination | 1 | 16 | 16 |
| Reading | 10 | 2 | 20 |
|
| Contribution of Learning Outcomes to Programme Outcomes |
| LO1 | 4 | 4 | 5 | 4 | 4 | 5 | 3 | 3 | | 5 | 4 | | | | | LO2 | 4 | 4 | 5 | 4 | 4 | 5 | 3 | 3 | | 5 | 4 | | | | | LO3 | 5 | 5 | 5 | 4 | 4 | 5 | 3 | 4 | | 5 | 3 | | | | | LO4 | 3 | 3 | 4 | 5 | 5 | 5 | | 3 | 4 | 5 | 4 | 3 | | 2 |
|
| * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
 |
| |
| Ege University, Bornova - İzmir / TURKEY • Phone: +90 232 311 10 10 • e-mail: intrec@mail.ege.edu.tr |