ISTINYE UNIVERSITY BİLGİ PAKETİ / DERS KATALOĞU
| Management Information Systems (English) | |||||
| Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 | ||
Course Introduction and Application Information
| 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 Objective and Content
| 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. |
Learning Outcomes
|
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 |
Course Flow Plan
| 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 |
Sources
| 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 - Program Learning Outcome Relationship
| Course Learning Outcomes | 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
|||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Program Outcomes | |||||||||||||
| 1) It has a wide range of interdisciplinary approaches to management information systems, primarily business and computer engineering. | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |||||
| 2) Comprehends the management information systems in terms of technical, organizational and managerial aspects and uses the current programming language by knowing the logic of programming. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||||
| 3) Uses different information technologies and systems for understanding and solving various business problems. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||||
| 4) Interpret the data, concepts and ideas in the field of management information systems with scientific and technological methods. | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | |||||
| 5) Analyze the needs for an information system and analyze the processes of analysis, design and implementation of the database. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||||
| 6) Gains technical and managerial contributions to IT projects and takes responsibility. | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | |||||
| 7) Solve complex business and informatics problems by using various statistical techniques and numerical methods and make analyzes using statistical programs effectively. | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | |||||
| 8) Uses a foreign language at the B1 General Level in terms of European Language Portfolio criteria according to the level of education. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
| 9) Develops teamwork, negotiation, leadership and entrepreneurship skills. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
| 10) Has universal ethical values, social responsibility awareness and sufficient legal knowledge. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
| 11) Develops positive attitudes related to lifelong learning and identifies individual learning needs and carries out studies to correct them. | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
| 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. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
| 13) It uses information and communication technologies together with computer software at the advanced level of European Computer Driving License required by the field. | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | |||||
Course - Learning Outcome Relationship
| No Effect | 1 Lowest | 2 Average | 3 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | It has a wide range of interdisciplinary approaches to management information systems, primarily business and computer engineering. | 3 |
| 2) | Comprehends the management information systems in terms of technical, organizational and managerial aspects and uses the current programming language by knowing the logic of programming. | 3 |
| 3) | Uses different information technologies and systems for understanding and solving various business problems. | 3 |
| 4) | Interpret the data, concepts and ideas in the field of management information systems with scientific and technological methods. | 3 |
| 5) | Analyze the needs for an information system and analyze the processes of analysis, design and implementation of the database. | 3 |
| 6) | Gains technical and managerial contributions to IT projects and takes responsibility. | 2 |
| 7) | Solve complex business and informatics problems by using various statistical techniques and numerical methods and make analyzes using statistical programs effectively. | 2 |
| 8) | Uses a foreign language at the B1 General Level in terms of European Language Portfolio criteria according to the level of education. | 1 |
| 9) | Develops teamwork, negotiation, leadership and entrepreneurship skills. | 1 |
| 10) | Has universal ethical values, social responsibility awareness and sufficient legal knowledge. | 1 |
| 11) | Develops positive attitudes related to lifelong learning and identifies individual learning needs and carries out studies to correct them. | 1 |
| 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. | 1 |
| 13) | It uses information and communication technologies together with computer software at the advanced level of European Computer Driving License required by the field. | 3 |
Assessment & Grading
| 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 | |
Workload and ECTS Credit Calculation
| 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 | ||||||