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 |