SEN2104 Database Management SystemsBahçeşehir UniversityDegree Programs PERFORMING ARTSGeneral Information For StudentsDiploma SupplementErasmus Policy StatementNational QualificationsBologna Commission
PERFORMING ARTS
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

Course Introduction and Application Information

Course Code Course Name Semester Theoretical Practical Credit ECTS
SEN2104 Database Management Systems Spring
Fall
3 2 4 7
This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester.

Basic information

Language of instruction: English
Type of course: Non-Departmental Elective
Course Level: Bachelor’s Degree (First Cycle)
Mode of Delivery: Hybrid
Course Coordinator : Dr. Öğr. Üyesi TAMER UÇAR
Course Lecturer(s): Dr. Öğr. Üyesi TAMER UÇAR
RA SEVGİ CANPOLAT
Dr. Öğr. Üyesi ÖZGÜR ERKUT ŞAHİN
RA MERVE ARITÜRK
Prof. Dr. ADEM KARAHOCA
Recommended Optional Program Components: None
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.

Learning Outcomes

The students who have succeeded in this course;
1. Define the entity-relationship model.
2. Define the relational data model.
3. Define the relational algebra query language.
4. Define the SQL language.
5. Identify the relational database design approach.
6. Identify indexing, query processing and query optimization.
7. 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.

Weekly Detailed Course Contents

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: -

Evaluation System

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 % 45
PERCENTAGE OF FINAL WORK % 55
Total % 100

ECTS / Workload Table

Activities Number of Activities Duration (Hours) Workload
Total Workload

Contribution of Learning Outcomes to Programme Outcomes

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) They acquire theoretical, historical and aesthetic knowledge specific to their field by using methods and techniques related to performing arts (acting, dance, music, etc.). 2
2) They have knowledge about art culture and aesthetics and they provide the unity of theory and practice in their field. 2
3) They are aware of national and international values in performing arts. 2
4) Abstract and concrete concepts of performing arts; can transform it into creative thinking, innovative and original works. 1
5) They have the sensitivity to run a business successfully in their field. 3
6) Develops the ability to perceive, think, design and implement multidimensional from local to universal. 3
7) They have knowledge about the disciplines that the performing arts field is related to and can evaluate the interaction of the sub-disciplines within their field. 2
8) They develop the ability to perceive, design, and apply multidimensionality by having knowledge about artistic criticism methods. 3
9) They can share original works related to their field with the society and evaluate their results and question their own work by using critical methods. 1
10) They follow English language resources related to their field and can communicate with foreign colleagues in their field. 1
11) By becoming aware of national and international values in the field of performing arts, they can transform abstract and concrete concepts into creative thinking, innovative and original works. 3
12) They can produce original works within the framework of an interdisciplinary understanding of art. 2
13) Within the framework of the Performing Arts Program and the units within it, they become individuals who are equipped to take part in the universal platform in their field. 3
14) Within the Performing Arts Program, according to the field of study; have competent technical knowledge in the field of acting and musical theater. 2
15) They use information and communication technologies together with computer software that is at least at the Advanced Level of the European Computer Use License as required by the field. 3