| Course Code: | MIS207 | ||||
| Course Name: | Database Management Systems | ||||
| Semester: | Fall | ||||
| Course Credits: |
|
||||
| Language of instruction: | English | ||||
| Course Condition: | |||||
| Does the Course Require Work Experience?: | No | ||||
| Type of course: | Compulsory Courses | ||||
| Course Level: |
|
||||
| Mode of Delivery: | Face to face | ||||
| Course Coordinator: | Dr. Öğr. Üy. HASAN UFUK GÖKÇE | ||||
| Course Lecturer(s): | Eyüp Kaan Ülgen | ||||
| Course Assistants: |
| Course Objectives: | The goal of this course for each student is: To learn data and database concepts, and SQL for structural data within database management system by applying. |
| Course Content: | Designing database management system by understanding data structure. Understanding V’s of big data and storing architecture by discussing standard SQL and NoSQL structure. |
|
The students who have succeeded in this course;
1) Knows the differences between data, information and knowledge and defines them by giving examples 2) Knows the structured, semi-structured and unstructured data 3) Defines the entity-relationship diagrams and designs for a database 4) Explains and applies normalization on tables 5) Understanding relational algebra 6) Understands, explains and build the SQL queries 7) Designs a database by using a tool 8) Understanding NoSQL databases, knows the difference with SQL queries |
| Week | Subject | Related Preparation |
| 1) | Concepts of data, information and knowledge, increase of data within years and issues on storing, development history of database | |
| 2) | Data types, table design for database, key | |
| 3) | Entity Relationship Model (E-R), Chen notation | |
| 4) | Relationship types, normalization and relational algebra | |
| 5) | SQL queries | |
| 6) | SQL queries | |
| 7) | Designing database for structural data and usage of queries (MySQL / Python (mysql.connector)) | |
| 8) | MIDTERM EXAM WEEK | |
| 9) | Designing database for structural data and usage of queries (MySQL / Python (mysql.connector)) | |
| 10) | Designing database for structural data and usage of queries (MySQL / Python (mysql.connector)) | |
| 11) | Designing database for structural data and usage of queries (MySQL / Python (mysql.connector)) | |
| 12) | Understanding NoSQL databases, JSON-BSON data formats, MongoDB | |
| 13) | Designing database for unstructured data and usage of queries (MongoDB / Python (pymongo)) | |
| 14) | Designing database for unstructured data and usage of queries (MongoDB / Python (pymongo)) | |
| 15) | Designing database for unstructured data and usage of queries (MongoDB / Python (pymongo)) | |
| 16) | FINAL EXAM WEEK |
| Course Notes / Textbooks: | YAŞAR DAŞDEMİR, VERİTABANI SİSTEMLERİ: SQL VE NOSQL, 2019 YALÇIN ÖZKAN, VERİTABANI YONETİM SİSTEMLERİ, 2009 KRISTINA CHODOROW, MONGODB: THE DEFINITIVE GUIDE: POWERFUL AND SCALABLE DATA STORAGE, 2013 ABRAHAM SİLBERSCHATZ, HENRY KORTH AND S. SUDARSHAN, DATABASE SYSTEM CONCEPTS, 2020 |
| References: | MOOC ORTAMLARINDAKI YARDIMCI DERSLER ÖĞRETİM ÜYESİNİN DERS NOTLARI COURSES ON THE MOOCS LECTURER'S HANDOUTS |
| Course Learning Outcomes | 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
|---|---|---|---|---|---|---|---|---|
| Program Outcomes |
| No Effect | 1 Lowest | 2 Average | 3 Highest |
| Program Outcomes | Level of Contribution |
| Semester Requirements | Number of Activities | Level of Contribution |
| Homework Assignments | 2 | % 20 |
| Project | 1 | % 30 |
| Final | 1 | % 50 |
| total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 50 | |
| PERCENTAGE OF FINAL WORK | % 50 | |
| total | % 100 | |
| Activities | Number of Activities | Preparation for the Activity | Spent for the Activity Itself | Completing the Activity Requirements | Workload | ||
| Course Hours | 14 | 1 | 2 | 42 | |||
| Study Hours Out of Class | 14 | 2 | 1 | 42 | |||
| Project | 1 | 10 | 1 | 11 | |||
| Homework Assignments | 2 | 4 | 1 | 10 | |||
| Final | 1 | 15 | 2 | 17 | |||
| Total Workload | 122 | ||||||