TR EN

ISTANBUL GELİŞİM UNIVERSITY INFORMATION SYSTEM

DATABASE MANAGEMENT SYSTEMS I COURSE IDENTIFICATION AND APPLICATION INFORMATION

Code Name of the Course Unit Semester In-Class Hours (T+P) Credit ECTS Credit
CMP151 DATABASE MANAGEMENT SYSTEMS I 1 3 3 5

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week Preparatory Topics(Subjects) Method
1 Literature research Data and Database Concepts, Needs Analysis Expression
2 Research Data Models, Entity Relationship Diagram Expression
3 Research Normalization Application
4 Research Installing Database Tools, Creating Tables and Specifying Properties Application
5 Research Creating Tables and Specifying Properties Application
6 Research Create Query and Using The Type Application
7 Research Creating Query and Using Its Types, Preparing Query with Related Tables Application
8 Research Preparing Query with Related Tables Application
9 Research Using DML Queries Application
10 - MID-TERM EXAM -
11 Research Using DML Queries, Writing User Queries Application
12 Research Writing View Queries, Writing Trigger Queries Application
13 Research Writing Subprogram Queries, Making Transactions Application
14 Research Writing Index Queries Application
15 Research Database Security and Backup Application
16 - FINAL EXAM -
17 - FINAL EXAM -