Information
Course Goal / Objective
The aim of the course is to solve a real life problem by using the basic knowledge of database design and management.
Course Content
This course will address the issues in building real world applications using database management systems. It presents concepts, methodologies, and techniques important for database analysis, design, implementation, and management. The course focuses on the logical, conceptual and physical implementation of relational database management systems for a real life application. Students can assimilate a basic knowledge of database design by applying database design concepts to a real problem.
Course Precondition
Programming knowledge to implement database project.
Resources
R.Ramakrishnan, J.Gehrke, "Database Management Systems", McGraw Hill, 2003.
Notes
Any reference to SQL
Course Learning Outcomes
Order | Course Learning Outcomes |
---|---|
LO01 | Students can develop real world application projects by using database management systems. |
LO02 | Students investigate concepts, methodologies, and techniques necessary for database analysis, design, implementation, and management. |
LO03 | Students apply the logical, conceptual and physical implementation of relational database management systems for a real life application. |
LO04 | Students can use a relational database management system with a programming language. |
Relation with Program Learning Outcome
Order | Type | Program Learning Outcomes | Level |
---|---|---|---|
PLO01 | Bilgi - Kuramsal, Olgusal | Has capability in the fields of mathematics, science and computer that form the foundations of engineering | 3 |
PLO02 | Bilgi - Kuramsal, Olgusal | Identifies, formulates, and solves engineering problems, selects and applies appropriate analytical methods and modeling techniques, | |
PLO03 | Bilgi - Kuramsal, Olgusal | Analyzes a system, its component, or process and designs under realistic constraints to meet the desired requirements,gains the ability to apply the methods of modern design accordingly. | 5 |
PLO04 | Bilgi - Kuramsal, Olgusal | Ability to use modern techniques and tools necessary for engineering practice and information technologies effectively. | 3 |
PLO05 | Bilgi - Kuramsal, Olgusal | Ability to design and to conduct experiments, to collect data, to analyze and to interpret results | 2 |
PLO06 | Bilgi - Kuramsal, Olgusal | Has ability to work effectively as an individual and in multi-disciplinary teams, take sresponsibility and builds self-confidence | 4 |
PLO07 | Beceriler - Bilişsel, Uygulamalı | Can access information,gains the ability to do resource research and uses information resources | 4 |
PLO08 | Beceriler - Bilişsel, Uygulamalı | Awareness of the requirement of lifelong learning, to follow developments in science and technology and continuous self-renewal ability | 3 |
PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Ability to communicate effectively orally and in writing, and to read and understand technical publications in at least one foreign language | 4 |
PLO10 | Yetkinlikler - Öğrenme Yetkinliği | Professional and ethical responsibility, | |
PLO11 | Yetkinlikler - Öğrenme Yetkinliği | Awareness about project management, workplace practices, employee health, environmental and occupational safety, and the legal implications of engineering applications, | |
PLO12 | Yetkinlikler - Öğrenme Yetkinliği | Becomes aware of universal and social effects of engineering solutions and applications, entrepreneurship and innovation, and knowledge of contemporary issues |
Week Plan
Week | Topic | Preparation | Methods |
---|---|---|---|
1 | Review of database concepts and choosing a real word application project topic | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma |
2 | Project requirement analysis | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Tartışma, Proje Temelli Öğrenme |
3 | Review of the relational model | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
4 | Modeling the application project problem using the relational model | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
5 | Review of logical database design | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
6 | Logical database design for the application project problem | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
7 | Review of the conceptual database design | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
8 | Mid-Term Exam | Reading the lecture notes, project work. | Ölçme Yöntemleri: Proje / Tasarım, Sözlü Sınav |
9 | Conceptual database design for the application project problem | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
10 | Review of the physical database design | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
11 | Physical database design for the application project problem | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
12 | Forming queries for the application project problem | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
13 | Fine tuning the database for the application project problem | Reading the lecture notes, project work. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Problem Çözme, Proje Temelli Öğrenme |
14 | Preparing project presentations | Preparing the project presentation. | Öğretim Yöntemleri: Anlatım, Tartışma, Proje Temelli Öğrenme |
15 | Project presentations | Reading the lecture notes, project presentation. | Öğretim Yöntemleri: Soru-Cevap, Tartışma, Proje Temelli Öğrenme |
16 | Preparation to Final Exam | Preparing the project report | Öğretim Yöntemleri: Proje Temelli Öğrenme |
17 | Term Exams | Preparing the project report | Ölçme Yöntemleri: Proje / Tasarım, Sözlü Sınav |
Student Workload - ECTS
Works | Number | Time (Hour) | Workload (Hour) |
---|---|---|---|
Course Related Works | |||
Class Time (Exam weeks are excluded) | 14 | 3 | 42 |
Out of Class Study (Preliminary Work, Practice) | 14 | 5 | 70 |
Assesment Related Works | |||
Homeworks, Projects, Others | 0 | 0 | 0 |
Mid-term Exams (Written, Oral, etc.) | 1 | 15 | 15 |
Final Exam | 1 | 30 | 30 |
Total Workload (Hour) | 157 | ||
Total Workload / 25 (h) | 6,28 | ||
ECTS | 6 ECTS |