Management Information Systems (English) | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
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 | |||||||||||||
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 |
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 |
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 |