| Course Type | Compulsory Course |
|---|
| Course Level | Bachelor's Degree |
|---|
| Year of Study | 2 |
|---|
| Semester | Fourth Term (Spring) |
|---|
| ECTS | 4 |
|---|
| Name of Lecturer(s) |
|
| Learning Outcomes |
At the end of this course, the students;
- Acquire knowledge and skills at the level of understanding regarding the fundamental concepts of databases.
- Analyze database and database management system problems holistically, break them down, and identify similarities and differences between problem components.
- Gain knowledge and skills at the levels of comprehension and application regarding the stages of the information system development life cycle and database design stages.
- Acquire knowledge and skills at the comprehension and application levels regarding relational data models and data transformations.
- Gain knowledge and skills at the levels of understanding and application regarding Sql, data definition language, data manipulation language, and related commands.
- Acquire knowledge and cognitive skills at the level of comprehension regarding relationship types, keys, and constraints.
- Gain basic knowledge and skills related to the MySQL Database; develops designs and applications using "MySQL Workbench" for solving database problems.
- Acquire knowledge and skills to conduct a database design and application term project for solving a business-related problem, carrying out the necessary analysis, design, and application processes, and producing the required project outputs.
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | None |
|---|
| Course Description | The aim of this course is to acquire knowledge and skills related to database design stages, database applications, SQL commands and the installation of database management systems. |
|---|
| Course Contents |
| WEEK |
TOPICS |
|
1st Week |
Course introduction and objectives, fundamental concepts, database approaches, introduction to database management systems |
|
2nd Week |
Database design stages (4 stages), database requirements analysis and specification, verb-noun analysis, UML diagrams, data flow diagram |
|
3rd Week |
Database design stages (4 stages), database requirements analysis and specification, verb-noun analysis, UML diagrams, data flow diagram |
|
4th Week |
Conceptual design and entity-relationship modeling |
|
5th Week |
Relational data models and transformations |
|
6th Week |
Relational data models and transformations |
|
7th Week |
Integrity constraints, relationship types, keys, constraints; Submission of project progress reports |
|
8th Week |
Midterm exam |
|
9th Week |
Physical design, modeling, and implementation; MySQL installation, introduction and usage of "MySQL Workbench", data definition language (DDL) and SQL commands |
|
10th Week |
CREATE and ALTER statements, INSERT, UPDATE, DELETE, SQL statements |
|
11th Week |
SELECT and GROUP BY statements |
|
12th Week |
SELECT LEFT JOIN, INNER JOIN statements |
|
13th Week |
Case study and general review |
|
14th Week |
Project presentations and evaluation |
|
| Recommended or Required Reading | Yarımağan, Ü. (2010). Veri Tabanı Sistemleri. Akademi Yayınevi.
Mannino, M. V. (2007). Database Design, Application Development, and Administration. McGraw-Hill.
Connolly, T. M., & Begg, C. E. (2005). Database Systems: A Practical Approach to Design, Implementation, and Management. Addison-Wesley.
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2010). Database Systems Concepts (6th ed.). McGraw-Hill.
Elmasri, R., & Navathe, S. B. (2010). Fundamentals of Database Systems (6th ed.). Pearson Education.
Ramakrishnan, R., & Gehrke, J. (2002). Database Management Systems (3rd ed.). McGraw-Hill. |
|---|
| Planned Learning Activities and Teaching Methods |
- Lecture
- Questions/Answers
- Practice
- Project
- Problem Solving
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
30 |
| Quiz |
1 |
20 |
| Project |
1 |
20 |
| Total(%) |
|
70 |
| Contribution of In-term Studies to Overall Grade(%) |
|
70 |
| Contribution of Final Examination to Overall Grade(%) |
|
30 |
| Total(%) |
|
100 |
|
| ECTS Allocated Based on Student Workload |
| Activities |
Quantity |
Duration (Hour) |
Total Workload (Hour) |
| Midterm exam |
1 |
1.5 |
1.5 |
| Preparation for Quiz |
|
|
|
| Individual or group work |
14 |
3 |
42 |
| Preparation for Final exam |
1 |
22 |
22 |
| Course hours |
13 |
2 |
26 |
| Preparation for Midterm exam |
1 |
15 |
15 |
| Laboratory (including preparation) |
13 |
1 |
13 |
| Final exam |
1 |
1.5 |
1.5 |
| Homework |
0 |
0 |
0 |
| Project |
1 |
20 |
20 |
| Total Work Load | 141 |
| Total Work Load / 30 (h) | 4.7 |
| ECTS Credit of the Course | 4 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
