| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | MBP1082014646 | DATABASE - I | Compulsory | 1 | 2 | 4 |
|
| Level of Course Unit |
| Short Cycle |
| Objectives of the Course |
| With this course the student, data base designing, creating, querying a database using the administrative functions of the gain qualifications. |
| Name of Lecturer(s) |
|
| Learning Outcomes |
| 1 | Database Design | | 2 | Creating a database | | 3 | Query the database to make | | 4 | Using the Database Administration Functions |
|
| Mode of Delivery |
| Formal Education |
| Prerequisites and co-requisities |
| None |
| Recommended Optional Programme Components |
| None |
| Course Contents |
| Database Design, Creating a database, Query the database to make and Using the Database Administration Functions |
| Weekly Detailed Course Contents |
|
| 1 | Database Needs Analysis Normalizasyon Normalization | | | | 2 | Normalization | | | | 3 | Normalization | | | | 4 | Database Tools Setup to make Creating Tables and Identify Features | | | | 5 | Creating Tables and Identify Features | | | | 6 | Creating tables and determine the characteristics of | | | | 7 | Create and use Query Varieties | | | | 8 | Create and use Query Varieties Prepare a query with related tables | | | | 9 | Prepare a query with related tables | | | | 10 | Using DML queries | | | | 11 | Using DML queries User Queries Writing | | | | 12 | Write to the View Queries Writing Queries Trigger | | | | 13 | Writing Queries Trigger Write to the Sub-Programme Queries | | | | 14 | Transaction Processing to do Writing Queries Index | | | | 15 | Transaction Processing to do Writing Queries Index | | | | 16 | Final Exam | | |
|
| Recommended or Required Reading |
| ÖZSEVEN TURGUT, VERİTABANI YÖNETİM SİSTEMLERİ 1 MURATHAN YAYINLARI |
| Planned Learning Activities and Teaching Methods |
|
| Assessment Methods and Criteria | |
| SUM | 0 | |
| SUM | 0 | | Yarıyıl (Yıl) İçi Etkinlikleri | 40 | | Yarıyıl (Yıl) Sonu Etkinlikleri | 60 | | SUM | 100 |
| | Language of Instruction | | Turkish | | Work Placement(s) | | None |
|
| Workload Calculation |
|
| Midterm Examination | 1 | 1 | 1 |
| Final Examination | 1 | 1 | 1 |
| Attending Lectures | 16 | 2 | 32 |
| Practice | 14 | 1 | 14 |
| Self Study | 14 | 2 | 28 |
| Individual Study for Mid term Examination | 8 | 2 | 16 |
| Individual Study for Final Examination | 8 | 2 | 16 |
|
| Contribution of Learning Outcomes to Programme Outcomes |
| LO1 | 3 | 3 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | | LO2 | 3 | 3 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | | LO3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | | LO4 | 5 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 4 |
|
| * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
|
|
|
|
Ordu University Rectorate Building ,Cumhuriyet Campus , Center / ORDU / TURKEY • Tel: +90 452 226 52 00
|