| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | BLG1062010773 | DATABASE I | Compulsory | 1 | 2 | 4 |
|
| Level of Course Unit |
| Short Cycle |
| Objectives of the Course |
| The aim of the course is
• to gain sufficiencies of designing and creating databases, making queries and using database management functions
|
| Name of Lecturer(s) |
| Dr. Öğr. Üyesi Murat ÇETİNKAYA |
| Learning Outcomes |
| 1 | Database Designing | | 2 | Create Database | | 3 | Querying the database | | 4 | Database Using Administrative Functions |
|
| Mode of Delivery |
| Formal Education |
| Prerequisites and co-requisities |
|
| Recommended Optional Programme Components |
| Week 1 Database requirement analysis, Normalization
Week2 Normalization
Week 3 Normalization
Week 4 Installation of database tools, Creating tables and determining fields
Week 5 Creating tables and determining fields
Week 6 Creating tables and determining fields
Week 7 Creating various queries
Week 8 Creating various queries, Creating queries with related tables
Week 9 Creating queries with related tables
Week 10 Using DML queries
Week 11 Using DML queries, Writing user queries
Week 12 Writing views, Writing triggers
Week 13 Writing triggers, Writing stored procedures
Week 14 Making transaction operations, Writing index queries
|
| Course Contents |
| Database requirement analysis, Normalization
• Installation of database tools, Creating tables and determining fields
• Creating tables and determining fields
• Creating various queries
• Creating queries with related tables
• Using DML queries
• Writing user queries
• Writing views
• Writing triggers
• Writing stored procedures
• Writing stored procedures
• Making transaction operations
• Writing index queries
|
| Weekly Detailed Course Contents |
|
| 1 | Needs Analysis Database Normalization | | | | 2 | Normalization | | | | 3 | Normalization | | | | 4 | From the Setup Database Tools. Creating tables and to determine the characteristics | | | | 5 | Creating Tables and select Properties | | | | 6 | Create the table and determine the properties | | | | 7 | Create and use the query type | | | | 8 | Midterm Exam | | | | 9 | Create a query and use it to type. Queries related to Prepared Statements | | | | 10 | Prepare the query with related tables | | | | 11 | Using DML queries | | | | 12 | Using DML queries. Writing Queries | | | | 13 | Views Writing Queries. Trigger Query Writing | | | | 14 | Transaction Processing to do. Writing Queries Index | | |
|
| Recommended or Required Reading |
|
| 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) | |
|
| Workload Calculation |
|
| Midterm Examination | 1 | 1 | 1 |
| Final Examination | 1 | 1 | 1 |
| Attending Lectures | 14 | 4 | 56 |
| Self Study | 12 | 3 | 36 |
| Individual Study for Homework Problems | 5 | 2 | 10 |
| Individual Study for Mid term Examination | 2 | 7 | 14 |
| Individual Study for Final Examination | 2 | 7 | 14 |
|
| Contribution of Learning Outcomes to Programme Outcomes |
| LO1 | | | | | | | | 5 | | 5 | 5 | | | | | | | | | | | | | | | | | | | LO2 | | | | | | | | 5 | | 5 | 5 | | | | | | | | | | | | | | | | | | | LO3 | | | | | | | | 5 | | 4 | 5 | | | | | | | | | | | | | | | | | | | LO4 | | | | | | | | 5 | | 4 | 5 | | | | | | | | | | | | | | | | | |
|
| * 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
|