| International Trade and Business (English) | |||||
| Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 | ||
| Course Code: | MIS207 | ||||
| Course Name: | Database Management Systems | ||||
| Semester: | Spring | ||||
| Course Credits: |
|
||||
| Language of instruction: | English | ||||
| Course Condition: | |||||
| Does the Course Require Work Experience?: | No | ||||
| Type of course: | Departmental Elective | ||||
| 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 | |||||||||||||
| 1) Has a broad and interdisciplinary perspective on international business and trade by the use of social sciences and mathematics, | |||||||||||||
| 2) Possess the knowledge and skills related to different functions and interactions of international business and trade. | |||||||||||||
| 3) Possess the knowledge and skills to interpret the data, concepts and ideas in the field of international business and trade with scientific and technological methods. | |||||||||||||
| 4) Use different theoretical approaches to understanding and solving various business and trade problems. | |||||||||||||
| 5) Explains the competitiveness of the countries with the requirements of international competition and interprets the functioning of the actors and regulatory structures in the international environment. | |||||||||||||
| 6) Understands the value of developing new trade projects and generating strategies within international market needs. | |||||||||||||
| 7) Solves complex business and global trade problems by using various statistical techniques and numerical methods and makes analyzes by using statistical programs effectively. | |||||||||||||
| 8) Uses a foreign language at the B1 General Level in terms of European Language Portfolio criteria according to the level of education. | |||||||||||||
| 9) Develops teamwork, negotiation, leadership and entrepreneurship skills. | |||||||||||||
| 10) Possess the knowledge of universal ethical values, social responsibility and sufficient legal and regulatory knowledge. | |||||||||||||
| 11) Develops positive attitudes related to lifelong learning and identifies individual learning needs and carries out studies to correct them. | |||||||||||||
| 12) Students will be able to communicate their ideas and solutions both written and orally, and present and publish them on both national and international platforms. | |||||||||||||
| 13) Uses information and communication technologies together with computer software at the advanced level of European Computer Using License required by the field. | |||||||||||||
| No Effect | 1 Lowest | 2 Average | 3 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | Has a broad and interdisciplinary perspective on international business and trade by the use of social sciences and mathematics, | |
| 2) | Possess the knowledge and skills related to different functions and interactions of international business and trade. | |
| 3) | Possess the knowledge and skills to interpret the data, concepts and ideas in the field of international business and trade with scientific and technological methods. | |
| 4) | Use different theoretical approaches to understanding and solving various business and trade problems. | |
| 5) | Explains the competitiveness of the countries with the requirements of international competition and interprets the functioning of the actors and regulatory structures in the international environment. | |
| 6) | Understands the value of developing new trade projects and generating strategies within international market needs. | |
| 7) | Solves complex business and global trade problems by using various statistical techniques and numerical methods and makes analyzes by using statistical programs effectively. | |
| 8) | Uses a foreign language at the B1 General Level in terms of European Language Portfolio criteria according to the level of education. | |
| 9) | Develops teamwork, negotiation, leadership and entrepreneurship skills. | |
| 10) | Possess the knowledge of universal ethical values, social responsibility and sufficient legal and regulatory knowledge. | |
| 11) | Develops positive attitudes related to lifelong learning and identifies individual learning needs and carries out studies to correct them. | |
| 12) | Students will be able to communicate their ideas and solutions both written and orally, and present and publish them on both national and international platforms. | |
| 13) | Uses information and communication technologies together with computer software at the advanced level of European Computer Using License required by the field. |
| 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 | ||||||