CEN441 Database Project Design and Management

6 ECTS - 3-0 Duration (T+A)- 7. Semester- 3 National Credit

Information

Code CEN441
Name Database Project Design and Management
Term 2022-2023 Academic Year
Semester 7. Semester
Duration (T+A) 3-0 (T-A) (17 Week)
ECTS 6 ECTS
National Credit 3 National Credit
Teaching Language İngilizce
Level Lisans Dersi
Type Normal
Mode of study Yüz Yüze Öğretim
Catalog Information Coordinator Prof. Dr. SELMA AYŞE ÖZEL
Course Instructor (A Group) ()


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

Update Time: 17.11.2022 06:23