| SOFTWARE ENGINEERING | |||||
| Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 | ||
| Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
| SEN2104 | Database Management Systems | Spring | 3 | 2 | 4 | 7 |
| Language of instruction: | English |
| Type of course: | Must Course |
| Course Level: | Bachelor’s Degree (First Cycle) |
| Mode of Delivery: | Hybrid |
| Course Coordinator : | Dr. Öğr. Üyesi TAMER UÇAR |
| Course Lecturer(s): |
Dr. Öğr. Üyesi TAMER UÇAR RA SEVGİ CANPOLAT Dr. Öğr. Üyesi ÖZGÜR ERKUT ŞAHİN RA MERVE ARITÜRK Prof. Dr. ADEM KARAHOCA |
| Recommended Optional Program Components: | None |
| Course Objectives: | The students will have the ability to analyze and design databases using the entity-relationship model. They will have the ability to define database querying techniques such as relational algebra and SQL. Besides these topics, the students will have the ability to identify relational database design approaches, indexing, query processing, and query optimization. Students will be able to define basic data analysis and data mining concepts. |
|
The students who have succeeded in this course; 1. Define the entity-relationship model. 2. Define the relational data model. 3. Define the relational algebra query language. 4. Define the SQL language. 5. Identify the relational database design approach. 6. Identify indexing, query processing and query optimization. 7. Define basic data analysis and data mining concepts. |
| The course content is composed of entity-relationship model, relational data model, relational algebra, SQL, relational database design, indexing, query processing, query optimization, data analysis and data mining related topics. |
| Week | Subject | Related Preparation |
| 1) | Introduction to Database Management Systems | |
| 2) | Entity-Relationship Model | |
| 3) | Introduction to Relational Data Model | |
| 4) | Relational Algebra | |
| 5) | Relational Algebra | |
| 6) | Applying Relational Algebra Principles to Database Design and Practice | |
| 7) | Structured Query Language (SQL) | |
| 8) | Structured Query Language (SQL) | |
| 9) | Relational Database Design | |
| 10) | Relational Database Design | |
| 11) | Relational Database Design | |
| 12) | Indexing and Query Processing | |
| 13) | Query Processing and Query Optimization | |
| 14) | Data Analysis and Data Mining |
| Course Notes / Textbooks: | Database System Concepts (6th Edition), Abraham Silberschatz, Henry Korth and S. Sudarshan, ISBN-13: 978-0073523323 Fundamentals of Database Systems (7th Edition), Ramez Elmasri and Shamkant Navathe, ISBN-13: 978-0133970777 |
| References: | - |
| Semester Requirements | Number of Activities | Level of Contribution |
| Quizzes | 3 | % 20 |
| Project | 1 | % 15 |
| Midterms | 1 | % 25 |
| Final | 1 | % 40 |
| Total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 45 | |
| PERCENTAGE OF FINAL WORK | % 55 | |
| Total | % 100 | |
| Activities | Number of Activities | Duration (Hours) | Workload |
| Total Workload | |||
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | Be able to specify functional and non-functional attributes of software projects, processes and products. | 3 |
| 2) | Be able to design software architecture, components, interfaces and subcomponents of a system for complex engineering problems. | 3 |
| 3) | Be able to develop a complex software system with in terms of code development, verification, testing and debugging. | 3 |
| 4) | Be able to verify software by testing its program behavior through expected results for a complex engineering problem. | 4 |
| 5) | Be able to maintain a complex software system due to working environment changes, new user demands and software errors that occur during operation. | 4 |
| 6) | Be able to monitor and control changes in the complex software system, to integrate the software with other systems, and to plan and manage new releases systematically. | 3 |
| 7) | Be able to identify, evaluate, measure, manage and apply complex software system life cycle processes in software development by working within and interdisciplinary teams. | 4 |
| 8) | Be able to use various tools and methods to collect software requirements, design, develop, test and maintain software under realistic constraints and conditions in complex engineering problems. | 4 |
| 9) | Be able to define basic quality metrics, apply software life cycle processes, measure software quality, identify quality model characteristics, apply standards and be able to use them to analyze, design, develop, verify and test complex software system. | 4 |
| 10) | Be able to gain technical information about other disciplines such as sustainable development that have common boundaries with software engineering such as mathematics, science, computer engineering, industrial engineering, systems engineering, economics, management and be able to create innovative ideas in entrepreneurship activities. | 3 |
| 11) | Be able to grasp software engineering culture and concept of ethics and have the basic information of applying them in the software engineering and learn and successfully apply necessary technical skills through professional life. | 3 |
| 12) | Be able to write active reports using foreign languages and Turkish, understand written reports, prepare design and production reports, make effective presentations, give clear and understandable instructions. | 4 |
| 13) | Be able to have knowledge about the effects of engineering applications on health, environment and security in universal and societal dimensions and the problems of engineering in the era and the legal consequences of engineering solutions. |