OPTICIANRY (TURKISH) | |||||
Associate | TR-NQF-HE: Level 5 | QF-EHEA: Short Cycle | EQF-LLL: Level 5 |
Course Code: | SEN2104 | ||||||||
Ders İsmi: | Database Management Systems | ||||||||
Ders Yarıyılı: | Spring | ||||||||
Ders Kredileri: |
|
||||||||
Language of instruction: | English | ||||||||
Ders Koşulu: | |||||||||
Ders İş Deneyimini Gerektiriyor mu?: | No | ||||||||
Type of course: | Non-Departmental Elective | ||||||||
Course Level: |
|
||||||||
Mode of Delivery: | Hybrid | ||||||||
Course Coordinator : | Dr. Öğr. Üyesi TAMER UÇAR | ||||||||
Course Lecturer(s): | |||||||||
Course Assistants: |
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. |
The students who have succeeded in this course;
|
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 |
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 Öğrenme Kazanımları | ||||||||
---|---|---|---|---|---|---|---|---|
Program Outcomes | ||||||||
1) The student acquires theoretical and practical knowledge related to his field at a basic level. | ||||||||
2) The student owns information about moral discipline and ethical rules related to his field. | ||||||||
3) The student uses theoretical and practical knowledge related to his field at a basic level; basic fundamental computer programs and related technologies. | ||||||||
4) The student manages a duty independently by using the knowledge about his field at a basic level. | ||||||||
5) The student evaluates the knowledge about his field at a basic level with a critical approach, he designates his learning needs and directs his learning. | ||||||||
6) The student uses information and communication technologies with at least at basic level of European Computer Using Licence basic level of computer software which his field of study requires. | ||||||||
7) The student complies with and contributes to quality management and processes. | ||||||||
8) The student has sufficient consciousness about individual and public health, environmental protection and work safety issues. | ||||||||
9) The student acts in accordance with laws, regulations, legislations and professional ethics related to individual duties, rights and responsibilities. |
No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
Program Outcomes | Level of Contribution | |
1) | The student acquires theoretical and practical knowledge related to his field at a basic level. | |
2) | The student owns information about moral discipline and ethical rules related to his field. | |
3) | The student uses theoretical and practical knowledge related to his field at a basic level; basic fundamental computer programs and related technologies. | |
4) | The student manages a duty independently by using the knowledge about his field at a basic level. | |
5) | The student evaluates the knowledge about his field at a basic level with a critical approach, he designates his learning needs and directs his learning. | |
6) | The student uses information and communication technologies with at least at basic level of European Computer Using Licence basic level of computer software which his field of study requires. | |
7) | The student complies with and contributes to quality management and processes. | |
8) | The student has sufficient consciousness about individual and public health, environmental protection and work safety issues. | |
9) | The student acts in accordance with laws, regulations, legislations and professional ethics related to individual duties, rights and responsibilities. |
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 |