 |
Description of Individual Course Units| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | 16011201T11205 | DATABASE-II | Compulsory | 2 | 3 | 4 |
| | Level of Course Unit | | Short Cycle | | Language of Instruction | | Turkish | | Objectives of the Course | | The aim of the course is to give students sufficient information about storing and querying data and programs used in an organization. | | Name of Lecturer(s) | | Öğr. Gör. Yeşim AKTAŞ | | Learning Outcomes | | 1 | Setting up the database | | 2 | Managing elementary table operations | | 3 | Managing advanced table operations | | 4 | Administrating database server |
| | Mode of Delivery | | Face to Face | | Prerequisites and co-requisities | | None | | Recommended Optional Programme Components | | None | | Course Contents | | Setting up at least two different database management system software, setting up the database management panel, Creating database and defining users, Creating tables and managing with diagrams, Transferring data, Creating a new database from the existing one, Arranging views, triggers, stored procedures and indexes, Managing user roles and user-defined data types, Managing rules and default values, Copying data and managing maintenance plans, Managing performance analysis restorations. | | Weekly Detailed Course Contents | |
| 1 | Setting up at least two different database server software | Problem session | | | 2 | Setting up database management panel, creating database and defining users | Problem session | | | 3 | Creating database and defining users, defining tables and managing diagrams | Problem session | | | 4 | Defining tables and managing diagrams, transferring data | Problem session | | | 5 | Transferring data, creating a new database from the existing one | Problem session | | | 6 | Creating a new database from the existing one, arranging views, triggers, stored procedures and indexes | Problem session | | | 7 | Arranging views, triggers, stored procedures and indexes | Problem session | | | 8 | Midterm Exam | Assessment | | | 9 | Arranging views, triggers, stored procedures and indexes, user roles and user-defined data types | Problem session | | | 10 | Arranging user roles and user-defined data types | Problem session | | | 11 | Arranging rules and default values | Problem session | | | 12 | Arranging rules and default values, replication of data, making a maintenance plan | Problem session | | | 13 | Replication of data, making a maintenance plan | Problem session | | | 14 | Performanca analysis and recovery | Problem session | | | 15 | Performanca analysis and recovery | 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 | 50 | | Practice | 1 | 50 | | 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 | 2 | 5 | 4 | 5 | | | | 4 | | | | 3 | | LO2 | 5 | 5 | 5 | 5 | | 5 | | | | | | | | | | LO3 | 5 | 5 | 5 | 5 | | 5 | | | | | | | | | | LO4 | 3 | 3 | 3 | 5 | 3 | 5 | 3 | | 4 | 4 | 3 | 3 | | |
| | * 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 |
|
|