SEN2104 Database Management SystemsBahçeşehir UniversityDegree Programs FOREIGN TRADE (TURKISH, DISTANCE EDUCATION)General Information For StudentsDiploma SupplementErasmus Policy StatementNational QualificationsBologna Commission
FOREIGN TRADE (TURKISH, DISTANCE EDUCATION)
Associate TR-NQF-HE: Level 5 QF-EHEA: Short Cycle EQF-LLL: Level 5

Ders Genel Tanıtım Bilgileri

Course Code: SEN2104
Ders İsmi: Database Management Systems
Ders Yarıyılı: Spring
Fall
Ders Kredileri:
Theoretical Practical Credit ECTS
3 2 4 7
Language of instruction: English
Ders Koşulu:
Ders İş Deneyimini Gerektiriyor mu?: No
Type of course: Non-Departmental Elective
Course Level:
Associate TR-NQF-HE:5. Master`s Degree QF-EHEA:Short Cycle EQF-LLL:5. Master`s Degree
Mode of Delivery: Hybrid
Course Coordinator : Dr. Öğr. Üyesi TAMER UÇAR
Course Lecturer(s):
Course Assistants:

Dersin Amaç ve İçeriği

Course Objectives: The students will have the ability to analyze and design databases using the entity-relationship model. They will have the ability to define database querying techniques such as relational algebra and SQL. Besides these topics, the students will have the ability to identify relational database design approaches, indexing, query processing, and query optimization. Students will be able to define basic data analysis and data mining concepts.
Course Content: The course content is composed of entity-relationship model, relational data model, relational algebra, SQL, relational database design, indexing, query processing, query optimization, data analysis and data mining related topics.

Learning Outcomes

The students who have succeeded in this course;
Learning Outcomes
1 - Knowledge
Theoretical - Conceptual
2 - Skills
Cognitive - Practical
3 - Competences
Communication and Social Competence
Learning Competence
Field Specific Competence
Competence to Work Independently and Take Responsibility

Ders Akış Planı

Week Subject Related Preparation
1) Introduction to Database Management Systems
2) Entity-Relationship Model
3) Introduction to Relational Data Model
4) Relational Algebra
5) Relational Algebra
6) Applying Relational Algebra Principles to Database Design and Practice
7) Structured Query Language (SQL)
8) Structured Query Language (SQL)
9) Relational Database Design
10) Relational Database Design
11) Relational Database Design
12) Indexing and Query Processing
13) Query Processing and Query Optimization
14) Data Analysis and Data Mining

Sources

Course Notes / Textbooks: Database System Concepts (6th Edition), Abraham Silberschatz, Henry Korth and S. Sudarshan, ISBN-13: 978-0073523323

Fundamentals of Database Systems (7th Edition), Ramez Elmasri and Shamkant Navathe, ISBN-13: 978-0133970777
References: -

Ders - Program Öğrenme Kazanım İlişkisi

Ders Öğrenme Kazanımları
Program Outcomes

Ders - Öğrenme Kazanımı İlişkisi

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution

Öğrenme Etkinliği ve Öğretme Yöntemleri

Ölçme ve Değerlendirme Yöntemleri ve Kriterleri

Assessment & Grading

Semester Requirements Number of Activities Level of Contribution
Quizzes 3 % 20
Project 1 % 15
Midterms 1 % 25
Final 1 % 40
Total % 100
PERCENTAGE OF SEMESTER WORK % 60
PERCENTAGE OF FINAL WORK % 40
Total % 100

İş Yükü ve AKTS Kredisi Hesaplaması

Activities Number of Activities Duration (Hours) Workload
Total Workload