| Teaching Staff
|
Dr. Öğr. Üyesi Mehmet Ali ÇİNİCİ |
| Language of Instruction |
Türkçe (Turkish) |
| Type Of Course |
Vocational |
| Prerequisites |
|
| Recommended Optional Programme Component |
Teaching consists of lectures, questions and answers, seminars, lab applications and practical studies and case studies (database designs). Practical work is done in groups or individually. It is compulsory to attend these events. |
| Course Objectives |
The competencies of analyzing database needs, making conceptual / physical design, creating, querying, and using database administrative functions will be gained. |
| Course Content |
Course content:
• Basic concepts of database management systems,
• Design of data models for database design,
• Query processing and optimization issues,
• Database system architectures, etc. To gain the necessary skills at the comprehension and application level of the subjects. |
| Learning Outcomes (LO) |
After completion of this course the students will be able:
LO.1: Designing a database at a conceptual and physical level;
LO.2: Advanced-reverse engineering;
LO.3: To understand the basic database assets and the relationships between these entities;
LO.4: Creating-deleting the database;
LO.5: Basic/advanced querying in the database;
LO.6: Performing basic data operations in the database. |
| Mode of Delivery |
Face to face |
| Course Outline |
| Week |
Topics |
| 1. Week |
Introduction To Database And Database Management Systems
|
| 2. Week |
Relational Database Design and Development (Analysis, Conceptual and Physical Design), Related Tools |
| 3. Week |
Entity-Relationship Modeling (Conceptual Design) with ER and UML, and Related Tools |
| 4. Week |
Basic database entities and integrity constraints |
| 5. Week |
Converting conceptual database design to physical database design |
| 6. Week |
Physical database design (creating tables and specifying their properties) |
| 7. Week |
SQL: Querying, Data Processing, Updating and Their Applications |
| 8. Week |
MIDTERM EXAM |
| 9. Week |
SQL: Multilevel, Nested Querying, Query Optimization,Functions and Their Usages |
| 10. Week |
Data Definition Language (DDL) / Data Manipulation Language (DML) |
| 11. Week |
Editing the table structure |
| 12. Week |
Forward/reverse engineering |
| 13. Week |
Advanced SQL operations and bulk data transfer |
| 14. Week |
PL/SQL: Introduction To Embeded Databases, Functions and Defining The Packets |
|
| Assessment |
| |
Percentage(%) |
| Mid-term (%) |
40 |
| Quizes (%) |
|
| Homeworks/Term papers (%) |
|
| Practice (%) |
|
| Labs (%) |
|
| Projects/Field Work (%) |
|
| Seminars/Workshops (%) |
|
| Final (%) |
60 |
| Other (%) |
|
| Total(%) |
100 |
|
| Course Book (s) and/or References |
1. Prof. Dr. A. Ünal YARIMAĞAN (2000). Veritabanı Sistemleri. Akademi & Türkiye Bilişim Vakfı.
2. Ramez Elmasri & Shamkant B. Navathe (2016). Fundamentals of Database Systems. Pearson Higher Education. 7th Global Edition. |
| Work Placement(s) |
|
| The Relationship between Program Qualifications (PQ) and Course Learning Outcomes (LO) |
| | PQ.1 | PQ.2 | PQ.3 | PQ.4 | PQ.5 | PQ.6 | PQ.7 | PQ.8 | PQ.9 | PQ.10 | PQ.11 | LO.1 | 4 | 5 | 5 | 5 | | 2 | 2 | | | | | LO.2 | 5 | 5 | 5 | 5 | 3 | | 3 | | | 2 | | LO.3 | 5 | 5 | 5 | 5 | | 4 | 2 | | | | 3 | LO.4 | 5 | | 5 | 5 | 2 | 3 | 3 | | 3 | | | LO.5 | 5 | 5 | 5 | 5 | 4 | | 3 | | | | | LO.6 | 5 | 5 | 5 | 5 | | 3 | 3 | | | 2 | |
|