| Dersin Adı |
Database Management Systems
|
|
Kodu
|
Yarıyıl
|
Teori
(saat/hafta) |
Uygulama/Lab
(saat/hafta) |
Yerel Kredi
|
AKTS
|
|
SE 306
|
FALL
|
2
|
2
|
3
|
5
|
| Ön-Koşul(lar) | Array | |||||
| Dersin Dili | English | |||||
| Dersin Türü | ELECTIVE_COURSE | |||||
| Dersin Düzeyi | Lisans | |||||
| Dersin Veriliş Şekli | ||||||
| Dersin Öğretim Yöntem ve Teknikleri | - | |||||
| Ulusal Meslek Sınıflandırma Kodu | - | |||||
| Dersin Koordinatörü |
|
|||||
| Öğretim Eleman(lar)ı |
|
|||||
| Yardımcı(ları) | - | |||||
| Dersin Amacı | These classification guidelines provide a broad base for data learning, database design and application module data definitions using ORACLE DBMS tool software. | |||||||||||||||||||||||||||||||||||||||||||||
| Öğrenme Çıktıları |
Bu dersi başarıyla tamamlayabilen öğrenciler;
|
|||||||||||||||||||||||||||||||||||||||||||||
| Ders Tanımı | Database objects will be created using SQL language. SQL 'stored procedures' and 'triggers' writing will be learned using ORACLE. | |||||||||||||||||||||||||||||||||||||||||||||
| Dersin İlişkili Olduğu Sürdürülebilir Kalkınma Amaçları |
-
|
|||||||||||||||||||||||||||||||||||||||||||||
|
|
Temel Ders |
|
| Uzmanlık/Alan Dersleri |
X
|
|
| Destek Dersleri |
|
|
| İletişim ve Yönetim Becerileri Dersleri |
|
|
| Aktarılabilir Beceri Dersleri |
|
| Hafta | Konular | Ön Hazırlık | Öğrenme Çıktısı |
| 1 | Introduction to database management systems | Presentations and lecture notes | LO3 |
| 2 | Database modeling, use of UML and Use Case Diagram | Presentations and lecture notes | LO1 |
| 3 | Relational Model and Algebra in Databases | Presentations and lecture notes | LO2 |
| 4 | Normalization | Presentations and lecture notes | LO2 |
| 5 | Normalization, transformed data | Presentations and lecture notes | LO2 |
| 6 | Definition of SQL database | Presentations and lecture notes | LO4 |
| 7 | Creating the SQL database | Presentations and lecture notes | LO4 |
| 8 | Stored procedures and triggers in SQL | Presentations and lecture notes | LO4 |
| 9 | Query optimization | Presentations and lecture notes | LO4 |
| 10 | Database processing, data integrity and security | Presentations and lecture notes | LO1 |
| 11 | Database throughput, concurrency, and recovery | Presentations and lecture notes | LO1 |
| 12 | Data Farms | Presentations and lecture notes | LO3 |
| 13 | Cloud Computing | Presentations and lecture notes | LO3 |
| 14 | Big Data I | Presentations and lecture notes | LO1 |
| 15 | Big Data II | Presentations and lecture notes | LO1 |
| 16 | Review | Presentations and lecture notes | - |
| Ders Kitabı | “Database Systems” T Connoly C. Begg Addison Wesley publishers |
| Önerilen Okumalar/Materyaller |
“An Introduction to Database Systems”. C J Date. Addison Wesley “Database Management Systems”. R Ramakrishnan. J Gehrke. McGrawHill “Relational Database Principles”. C Ritchie. Letts Educational “Fundamentals of SQL programming”. R MataToledo. P K Cushman. Schaum’s Outlines “Oracle Programming: A Primer”. R Sunderraman. Addison Wesley" |
| Yarıyıl Aktiviteleri | Sayı | Katkı Payı % | LO1 | LO2 | LO3 | LO4 |
| Küçük Sınav / Stüdyo Kritiği | 2 | 30 | X | X | X | X |
| Ara Sınav | 1 | 30 | X | X | ||
| Final Sınavı | 1 | 40 | X | X | ||
| Toplam | 4 | 100 |
| Yarıyıl Aktiviteleri | Sayı | Süre (Saat) | İş Yükü |
|---|---|---|---|
| Katılım | - | - | - |
| Teorik Ders Saati | 16 | 2 | 32 |
| Laboratuvar / Uygulama Ders Saati | 16 | 2 | 32 |
| Sınıf Dışı Ders Çalışması | 16 | 2 | 32 |
| Arazi Çalışması | - | - | - |
| Küçük Sınav / Stüdyo Kritiği | 2 | 7 | 14 |
| Portfolyo | - | - | - |
| Ödev | - | - | - |
| Sunum / Jüri Önünde Sunum | - | - | - |
| Proje | - | - | - |
| Seminer/Çalıştay | - | - | - |
| Sözlü Sınav | - | - | - |
| Ara Sınavlar | 1 | 15 | 15 |
| Final Sınavı | 1 | 25 | 25 |
| Toplam | 150 |
| # | PC Alt | Program Yeterlilikleri / Çıktıları | * Katkı Düzeyi | ||||
| 1 | 2 | 3 | 4 | 5 | |||
| 1 |
Engineering Knowledge: Knowledge of mathematics, science, basic engineering, computation, and related engineering discipline-specific topics; the ability to apply this knowledge to solve complex engineering problems. |
||||||
| 1 |
Mathematics |
||||||
| 2 |
Science |
||||||
| 3 |
Basic Engineering |
||||||
| 4 |
Computation |
||||||
| 5 |
Related engineering discipline-specific topics |
LO1 | |||||
| 6 |
The ability to apply this knowledge to solve complex engineering problems |
LO2 LO4 | |||||
| 2 |
Problem Analysis: Ability to identify, formulate and analyze complex engineering problems using basic knowledge of science, mathematics and engineering, and considering the UN Sustainable Development Goals relevant to the problem being addressed. |
||||||
| 3 |
Engineering Design: The ability to devise creative solutions to complex engineering problems; the ability to design complex systems, processes, devices or products to meet current and future needs, considering realistic constraints and conditions. |
||||||
| 1 |
Ability to design creative solutions to complex engineering problems |
||||||
| 2 |
Ability to design complex systems, processes, devices or products to meet current and future needs, considering realistic constraints and conditions |
LO3 | |||||
| 4 |
Use of Techniques and Tools: Ability to select and use appropriate techniques, resources, and modern engineering and computing tools, including estimation and modeling, for the analysis and solution of complex engineering problems, while recognizing their limitations. |
||||||
| 5 |
Research and Investigation: Ability to use research methods to investigate complex engineering problems, including literature research, designing and conducting experiments, collecting data, and analyzing and interpreting results. |
||||||
| 1 |
Literature research for the study of complex engineering problems |
||||||
| 2 |
Designing experiments |
||||||
| 3 |
Ability to use research methods, including conducting experiments, collecting data. analyzing and interpreting results |
||||||
| 6 |
Global Impact of Engineering Practices: Knowledge of the impacts of engineering practices on society, health and safety, economy, sustainability, and the environment, within the context of the UN Sustainable Development Goals; awareness of the legal implications of engineering solutions. |
||||||
| 1 |
Knowledge of the impacts of engineering practices on society, health and safety, economy, sustainability, and the environment, within the context of the UN Sustainable Development Goals |
||||||
| 2 |
Awareness of the legal implications of engineering solutions |
||||||
| 7 |
Ethical Behavior: Acting in accordance with the principles of the engineering profession, knowledge about ethical responsibility; awareness of being impartial, without discrimination, and being inclusive of diversity. |
||||||
| 1 |
Acting in accordance with the principles of the engineering profession, knowledge about ethical responsibility ethical responsibility |
||||||
| 2 |
Awareness of being impartial and inclusive of diversity, without discriminating on any subject |
||||||
| 8 |
Individual and Teamwork: Ability to work effectively, individually and as a team member or leader on interdisciplinary and multidisciplinary teams (face-to-face, remote or hybrid). |
||||||
| 1 |
Ability to work individually and within the discipline |
||||||
| 2 |
Ability to work effectively as a team member or leader in multidisciplinary teams (face-to-face, remote or hybrid) |
||||||
| 9 |
Verbal and Written Communication: Taking into account the various differences of the target audience (such as education, language, profession) on technical issues. |
||||||
| 1 |
Ability to communicate verbally |
||||||
| 2 |
Ability to communicate effectively in writing |
||||||
| 10 |
Project Management: Knowledge of business practices such as project management and economic feasibility analysis; awareness of entrepreneurship and innovation. |
||||||
| 1 |
Knowledge of business practices such as project management and economic feasibility analysis |
||||||
| 2 |
Awareness of entrepreneurship and innovation |
||||||
| 11 |
Lifelong Learning: Lifelong learning skills that include being able to learn independently and continuously, adapting to new and developing technologies, and thinking questioningly about technological changes. |
||||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
İzmir Ekonomi Üniversitesi, dünya çapında bir üniversiteye dönüşürken aynı zamanda küresel çapta yetkinliğe sahip başarılı gençler yetiştirir.
Daha Fazlası..İzmir Ekonomi Üniversitesi, nitelikli bilgi ve yetkin teknolojiler üretir.
Daha Fazlası..İzmir Ekonomi Üniversitesi, toplumsal fayda üretmeyi varlık nedeni olarak görür.
Daha Fazlası..