| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| Database Management Systems | YBS211 | 3. Semester | 3 + 0 | 3.0 | 6.0 |
| Prerequisites | None |
| Language of Instruction | Turkish |
| Course Level | Undergraduate |
| Course Type | |
| Mode of delivery | Lecture, Brainstorming, Demonstration and Computer Application |
| Course Coordinator |
Res. Assist. Dr. TUĞÇE KARAYEL |
| Instructors |
TUĞÇE KARAYEL |
| Assistants | |
| 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. |
| Learning Outcomes |
- Understanding the concept of database management system, its components and its importance in the IT world - To be able to design a conceptual database including constraints by analyzing job descriptions. - To be able to transform the conceptual database design to a logical table design. - To be able to implement the logical table design in a physical database environment (using SQL and using the tools of the database server). - To be able to make necessary queries and other operations in business processes using SQL - To be able to code procedures / functions and triggers using programming structures specific to SQL and database server system. - To be able to set up and operate a database server and use the necessary tools / environments for access. - To be able to design and develop a database for a specific job by working in a team, - To prepare and present the necessary documentation and presentation for the database project. |
| Week | Topics | Learning Methods |
|---|---|---|
| 1. Week | Data and data structure, data compilation and analysis; Database Management Systems | Course Hours |
| 2. Week | DBMS Basic Concepts: Database, Table, Primary Key etc. | Course Hours |
| 3. Week | Creating asset and property tables | Research Course Hours |
| 4. Week | Relationships between assets | Research Course Hours |
| 5. Week | Dependent asset independent asset relationships | Research Course Hours |
| 6. Week | Relationship between asset and table | Course Hours Research |
| 7. Week | Introduction to SQL language Database and database principals | Course Hours Research |
| 8. Week | MIDTERM EXAM | |
| 9. Week | Tables and Field Constraints Relationships between tables | Course Hours Research Practice |
| 10. Week | Using the nested "select" command | Practice Course Hours Research |
| 11. Week | DML commands: Insert, Update, Delete | Research Practice Course Hours |
| 12. Week | DDL-DCL commands and database objects | Course Hours Practice Research |
| 13. Week | Stored procedures and functions | Research Practice Course Hours |
| 14. Week | General evaluation on the topics of the semester | Course Hours Practice Research |
| Dr. Kerem KÖSEOĞLU, Veritabanı Mantığı, Pusula Yayıncılık, 11. Baskı |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 | DK7 | DK8 | DK9 | Measurement Method |
|---|---|---|---|---|---|---|---|---|---|---|---|
| PY1 | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 4 | 40,60,40,60 |
| PY2 | 4 | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 4 | 40,60 |
| PY3 | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 40,60 |
| PY4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | - |
| PY5 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40,60 |
| PY6 | 5 | 4 | 5 | 4 | 3 | 3 | 3 | 4 | 5 | 5 | 40 |
| PY7 | 3 | 5 | 5 | 5 | 5 | 4 | 4 | 5 | 4 | 5 | 40 |
| PY8 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 60 |
| PY9 | 4 | 5 | 5 | 5 | 3 | 5 | 4 | 5 | 5 | 5 | 60 |
| PY10 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 4 | 4 | 60 |
| PY11 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 60 |
| PY12 | 3 | 4 | 4 | 4 | 4 | 3 | 3 | 5 | 5 | 4 | 60 |
| PY13 | 1 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 1 | 2 | - |
| PY14 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | - |
| 0 | 1 | 2 | 3 | 4 | 5 | |
|---|---|---|---|---|---|---|
| Course's Level of contribution | None | Very Low | Low | Fair | High | Very High |
| Method of assessment/evaluation | Written exam | Oral Exams | Assignment/Project | Laboratory work | Presentation/Seminar |
| Event | Quantity | Duration (Hour) | Total Workload (Hour) |
|---|---|---|---|
| Course Hours | 14 | 3 | 42 |
| Research | 14 | 3 | 42 |
| Other Activities | 6 | 3 | 18 |
| Midterm 1 | 1 | 1 | 1 |
| Homework 2 | 1 | 30 | 30 |
| Final | 1 | 2 | 2 |
| Practice | 14 | 2 | 28 |
| Total Workload | 163 | ||
| ECTS Credit of the Course | 6.0 | ||
