| Course Title | Code | Language | Type | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|---|---|
| Database Management Systems | YBS211 | Turkish | Compulsory | 3. Semester | 3 + 0 | 3.0 | 6.0 |
| Prerequisite Courses | |
| Course Level | Undergraduate |
| Mode of delivery | Lecture, Brainstorming, Demonstration and Computer Application |
| Course Coordinator | Ar. Gör. Dr. TUĞÇE KARAYEL |
| Instructor(s) | Ar. Gör. Dr. TUĞÇE KARAYEL (Güz) |
| Goals | The aim of this course is to provide students with knowledge and experience about the importance, necessity, design, development and applications of database management systems. Database creation, data processing and query methods are explained with examples. |
| Course Content | After the basic concepts about the relational database are given, the logic of database design is transferred. Database Management System Application program (MS SQL) visual interface and SQL (Structured Query Language) to explain the methods of creating a database, data processing and querying with examples. |
| # | Öğrenme Kazanımı |
| 1 | Understanding the concept of database management system, its components and its importance in the IT world |
| 2 | To be able to design a conceptual database including constraints by analyzing job descriptions. |
| 3 | To be able to transform the conceptual database design to a logical table design. |
| 4 | To be able to implement the logical table design in a physical database environment (using SQL and using the tools of the database server). |
| 5 | To be able to make necessary queries and other operations in business processes using SQL |
| 6 | To be able to code procedures / functions and triggers using programming structures specific to SQL and database server system. |
| 7 | To be able to set up and operate a database server and use the necessary tools / environments for access. |
| 8 | To be able to design and develop a database for a specific job by working in a team, |
| 9 | To prepare and present the necessary documentation and presentation for the database project. |
| Week | Topics/Applications | Method |
|---|---|---|
| 1. Week | Data and data structure, data compilation and analysis; Database Management Systems | |
| 2. Week | DBMS Basic Concepts: Database, Table, Primary Key etc. | |
| 3. Week | Creating asset and property tables | Research |
| 4. Week | Relationships between assets | Research |
| 5. Week | Dependent asset independent asset relationships | Research |
| 6. Week | Relationship between asset and table | Research |
| 7. Week | Introduction to SQL language Database and database principals | Research |
| 8. Week | MIDTERM EXAM | |
| 9. Week | Tables and Field Constraints Relationships between tables | Research, Practice |
| 10. Week | Using the nested "select" command | Research, Practice |
| 11. Week | DML commands: Insert, Update, Delete | Research, Practice |
| 12. Week | DDL-DCL commands and database objects | Research, Practice |
| 13. Week | Stored procedures and functions | Research, Practice |
| 14. Week | General evaluation on the topics of the semester | Research, Practice |
| No | Program Requirements | Level of Contribution | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | Graduates will have a holistic perspective on business functions | ✔ | |||||
| 1 | Graduates will have a holistic perspective on business functions | ✔ | |||||
| 2 | Graduates will have conceptual knowledge in the field of informatics in the sector average. | ✔ | |||||
| 3 | Graduates may integrate the business functions and IT infrastructure | ✔ | |||||
| 4 | Graduates will have awareness and knowledge about the processes of analyzing, designing, developing, and using information systems. | ✔ | |||||
| 5 | Students will have the ability to define the problem, collect data, analyze, interpret, evaluate, and develop a solution proposal for the solution of problems encountered in business. | ✔ | |||||
| 6 | Graduates may develop new strategic approaches for the efficiency of applications used in businesses. | ✔ | |||||
| 7 | Graduates may understand the logic of the algorithm and convert the designed algorithm into an up-to-date programming language. | ✔ | |||||
| 8 | Gradutes may have basic knowledge and understanding in the field of data science. | ✔ | |||||
| 9 | Graduates may have basic knowledge and understanding in the field of data science. | ✔ | |||||
| 10 | Graduates may base their vision on continuous learning and renewal. | ✔ | |||||
| 11 | Graduates may have an awareness of ethical and professional responsibility in business life. | ✔ | |||||
| 12 | Graduates may have an awareness of the individual and social effects of informatics applications and their legal consequences. gets the awareness of social responsibility. | ✔ | |||||
| 13 | Graduates may be able to use at least one foreign language in written and oral communication in the fields of information systems and business administration. | ✔ | |||||
| 14 | Graduates may take responsibility as an individual or team member in solving problems encountered in business life. | ✔ | |||||
| Program Requirements | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 | DK7 | DK8 | DK9 |
|---|---|---|---|---|---|---|---|---|---|
| PY1 | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 4 |
| PY2 | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 4 |
| PY3 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
| PY4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
| PY5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |
| PY6 | 4 | 5 | 4 | 3 | 3 | 3 | 4 | 5 | 5 |
| PY7 | 5 | 5 | 5 | 5 | 4 | 4 | 5 | 4 | 5 |
| PY8 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
| PY9 | 5 | 5 | 5 | 3 | 5 | 4 | 5 | 5 | 5 |
| PY10 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 4 | 4 |
| PY11 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 |
| PY12 | 4 | 4 | 4 | 4 | 3 | 3 | 5 | 5 | 4 |
| PY13 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 1 | 2 |
| PY14 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 3 |
| Ders Kitabı veya Notu | Ders Kitabı veya Ders Notu bulunmamaktadır. |
|---|---|
| Diğer Kaynaklar |
|
| ECTS credits and course workload | Quantity | Duration (Hour) | Total Workload (Hour) | |
|---|---|---|---|---|
|
Ders İçi |
Class Hours | 14 | 3 | 42 |
|
Ders Dışı |
Research | 14 | 3 | 42 |
| Other Activities | 6 | 3 | 18 | |
|
Sınavlar |
Midterm 1 | 1 | 1 | 1 |
| Homework 2 | 1 | 30 | 30 | |
| Final | 1 | 2 | 2 | |
| Practice | 14 | 2 | 28 | |
| Total Workload | 163 | |||
| *AKTS = (Total Workload) / 25,5 | ECTS Credit of the Course | 6.0 | ||
