İzmir Ekonomi Üniversitesi
  • ENGLISH

  • MÜHENDİSLİK FAKÜLTESİ

    Makine Mühendisliği

    CE 223 | Ders Tanıtım Bilgileri

    Dersin Adı
    Database Systems
    Kodu
    Yarıyıl
    Teori
    (saat/hafta)
    Uygulama/Lab
    (saat/hafta)
    Yerel Kredi
    AKTS
    CE 223
    SPRING
    3
    2
    4
    7

    Ön-Koşul(lar) None
    Dersin Dili English
    Dersin Türü Zorunlu
    Dersin Düzeyi Lisans
    Dersin Veriliş Şekli Face-To-Face
    Dersin Öğretim Yöntem ve Teknikleri Problem Solving
    Application: Experiment / Laboratory / Workshop
    Lecture / Presentation
    Ulusal Meslek Sınıflandırma Kodu -
    Dersin Koordinatörü
    • Prof. Dr. Turhan Tunalı
    Öğretim Eleman(lar)ı
    • Prof. Dr. Cem Evrendilek
    • Dr. Öğr. Üyesi Çağlar Durmaz
    Yardımcı(ları)
    • Araş. Gör. Tugay Direk
    Dersin Amacı The goal of this course is to give basic knowledge of database systems to a student who intends to be a computer or software engineer. It provides a comprehensive introduction to relational data model and entity relationship data model as a design tool. Functional and multivalued dependencies in the context of normalization process are described in detail for designing relational database schema. SQL database language and system aspects of SQL such as transaction management, indexing, constraints, triggers and authorization are studied in detail together with laboratory practices illustrating different ways of database programming.
    Öğrenme Çıktıları Bu dersi başarıyla tamamlayabilen öğrenciler;
    Ad Açıklama PC Alt * Katkı Düzeyi
    1 2 3 4 5
    LO1 Students who can successfully complete this course; Identify and define all the information needed in the design of a database schema specific to a database application, 1.6 X
    LO2 create conceptual and physical database designs for a management information system by drawing the E/R diagram and performing the normalization of relations 3.2 X
    LO3 understand the core terms, concepts, and tools of relational database management systems 1.5 X
    LO4 query a database using SQL 1.5 X
    LO5 implement database applications by properly managing concurrent transactions 1.5 X
    LO6 finetune a database design to improve the performance of applications by the use of beneficial indexes and additional data structures conforming to the characteristics of applications running on them 1.5 X
    Ders Tanımı Topics related to both database design and database programming are covered.
    Dersin İlişkili Olduğu Sürdürülebilir Kalkınma Amaçları
    -

     



    Dersin Kategorisi

    Temel Ders
    X
    Uzmanlık/Alan Dersleri
    Destek Dersleri
    İletişim ve Yönetim Becerileri Dersleri
    Aktarılabilir Beceri Dersleri

     

    HAFTALIK KONULAR VE İLGİLİ ÖN HAZIRLIK ÇALIŞMALARI

    Hafta Konular Ön Hazırlık Öğrenme Çıktısı
    1 Introduction to Database Systems, Relational Data Model, Semi Structured, Data Model J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 1, Ch. 2.1, 2.2, 2.3, Ch. 11.1, 11.2, 11.3) LO3
    2 Entity-Relationship Data Model J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 4.1, 4.2, 4.3, 4.4, 4.5, 4.6) LO1
    3 Introduction to Relational Databases, Functional Dependencies J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5) LO2
    4 Design of Relational Databases, Multivalued Dependencies J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 3.6, 3.7) LO2
    5 Functional Dependencies and Multivalued Dependencies Revisited J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7) LO2
    6 Introduction to SQL (Part I) J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.1, 6.2, 6.3, 6.4.1, 6.4.2) LO4
    7 Introduction to SQL (Part II) J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.2, 6.4, 6.5) LO4
    8 Midterm LO3
    9 Constraints and Triggers J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 7) LO6
    10 SQL Programming: Embedded SQL, PSM (PL/SQL) J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.3, 9.4) LO4
    11 SQL Programming: CLI, JDBC, PHP/PEAR J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.1, 9.2, 9.5, 9.6, 9.7) LO4
    12 Transactions, Views, Indexes J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.6, 8.1, 8.2, 8.3, 8.4, 8.5) LO5
    13 SQL Authorization J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 10.1) LO4
    14 Logical Query Languages (Datalog) and SQL Recursion J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.3, 5.4, 10.2) LO4
    15 Review of the Semester LO1
    16 Final Exam LO1

     

    Ders Kitabı J. D. Ullman. J. Widom. A First Course In Database Systems. 3/e. PrenticeHall. 2008
    Course slides (URL for textbook: http://wwwdb.stanford.edu/~ullman/fcdb.html)
    Önerilen Okumalar/Materyaller Silberschatz et. al. Database System Concepts. 4th ed. McGrawHill. 2002.

     

    DEĞERLENDİRME ÖLÇÜTLERİ

    Yarıyıl Aktiviteleri Sayı Katkı Payı % LO1 LO2 LO3 LO4 LO5 LO6
    Laboratuvar / Uygulama 1 15 X
    Küçük Sınav / Stüdyo Kritiği 1 15 X X X X X X
    Ara Sınav 1 30 X X X X X X
    Final Sınavı 1 40 X X X X X X
    Toplam 4 100

     

    AKTS / İŞ YÜKÜ TABLOSU

    Yarıyıl Aktiviteleri Sayı Süre (Saat) İş Yükü
    Katılım - - -
    Teorik Ders Saati 16 3 48
    Laboratuvar / Uygulama Ders Saati 16 2 32
    Sınıf Dışı Ders Çalışması 14 3 42
    Arazi Çalışması - - -
    Küçük Sınav / Stüdyo Kritiği 1 15 15
    Portfolyo - - -
    Ödev 12 2 24
    Sunum / Jüri Önünde Sunum - - -
    Proje - - -
    Seminer/Çalıştay - - -
    Sözlü Sınav - - -
    Ara Sınavlar 1 21 21
    Final Sınavı 1 28 28
        Toplam 210

     

    DERSİN ÖĞRENME ÇIKTILARININ PROGRAM YETERLİLİKLERİ İLE İLİŞKİSİ

    # 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

    LO6 LO3 LO4 LO5
    6

    the ability to apply this knowledge to solve complex engineering problems.

    LO1
    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.

    LO2
    4

    Use of Techniques and Tools: Ability to select and use appropriate tectıniques, resources, and modern engineering and computing tools. including estimation and modeling. far the analysis and solution of complex engineering problems while recognizing their limitations.

    5

    Research and ınvestigation: Ability to use research methods ta investigate complex engineering problems, including literature research, designing and conducting experiments, collecting data, and analyzing and interpreting results.

    1

    Literature research far 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 lmpact of Engineering Practices: Knowledge of the impacts of engineering practices on s.ociety, health and safety. ttıe economy, sustainability and the environment \ıVlthin the context of the UN Sustainable Development GoaJs; awareness of the legal implications of engineering solutions.

    1

    Knowledge of ttıe impacts of engineering practices on society, health and safety, economy, su.stainability and the environment, within the context of the UN Sustainable Development Goals.

    2

    Awareness of the legal implications of engineering solutions

    7

    Ethical Behavlor: Acting in accordance with the principles of the engineering profession. knowledge about ethical ,esponsibility; awareness of being impartial. without discrimination, and being inclusive of diversity.

    1

    Acting in accordance with engineering professional principles. information about ethical responsibility

    2

    Awareness of being impartial and indusive of diversity, without disaiminating on any subject.

    8

    lndividual and Teamwork: Ability to work effectively individually and as a team member or leader on interdis.ciplinary and multidisciplinary teams (face-to-face, remote or hybrid).

    1

    lndividually and within the discipline

    2

    Ability to work effectivefy as a team member or leader in mutti-disciplinary 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

    Verbal

    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 tedınological changes

    *1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest


    İZMİR EKONOMİ ÜNİVERSİTESİ GÜZELBAHÇE KAMPÜSÜ

    Detaylar

    KÜRESEL KARİYER

    İ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ı..

    BİLİME KATKI

    İzmir Ekonomi Üniversitesi, nitelikli bilgi ve yetkin teknolojiler üretir.

    Daha Fazlası..

    İNSANA DEĞER

    İzmir Ekonomi Üniversitesi, toplumsal fayda üretmeyi varlık nedeni olarak görür.

    Daha Fazlası..

    TOPLUMA FAYDA

    22 yıllık güç ve deneyimini toplumsal çalışmalara aktarmak..

    Daha Fazlası..
    İzmir Ekonomide yapacağın Lisansüstü eğitimle bir adım öndesin