Information Package / Course Catalogue
| Psychology | |||||
| Bachelor | Length of the Programme: 4 | Number of Credits: 240 | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF: Level 6 |
ECTS Course Information Package
| School/Faculty/Institute | Faculty of Engineering | |||||
| Course Code | COMP 305 | |||||
| Course Title in English | Database Management Systems | |||||
| Course Title in Turkish | Veritabanı Yönetim Sistemleri | |||||
| Language of Instruction | EN | |||||
| Type of Course | Exercise,Lecture | |||||
| Level of Course | Introductory | |||||
| Semester | Fall | |||||
| Contact Hours per Week |
|
|||||
| Estimated Student Workload | 138 hours per semester | |||||
| Number of Credits | 6 ECTS | |||||
| Grading Mode | Standard Letter Grade | |||||
| Pre-requisites |
COMP 106 - Object-Oriented Programming | COMP 110 - Object-Oriented Programming (JAVA) |
|||||
| Co-requisites | None | |||||
| Expected Prior Knowledge | Object Oriented Programming | |||||
| Registration Restrictions | Only Undergraduate Students | |||||
| Overall Educational Objective | Veri tabanı temellerini öğrenmek | |||||
| Course Description | The main objective of this course is to present the fundamentals of database technology. The course is mainly designed to teach the use of a database management system (DBMS) by treating it as a black box and by focusing only on its functionality and its interfaces. Within this context, the course will deal with data modeling and design of a database. This course provides a comprehensive introduction to some fundamental aspects of Database Management. The following topics are covered: Database concepts, Relational model, Application development, Database design, normalization, entity-relationship models. |
Course Learning Outcomes and CompetencesUpon successful completion of the course, the learner is expected to be able to:1) Describe the fundamental elements of relational database management systems 2) Explain the basic concepts of relational data model, entity-relationship model, relational database design, relational algebra and SQL. 3) Design ER-models to represent simple database application scenarios 4) Convert the ER-model to relational tables, populate relational database and formulate SQL queries on data. 5) As a member of a team, design a new DBMS. 6) Present the DBMS project in front of an audience. |
| Program Learning Outcomes/Course Learning Outcomes | 1 | 2 | 3 | 4 | 5 | 6 |
|---|---|---|---|---|---|---|
| 1) Thorough knowledge of the major concepts, theoretical perspectives, empirical findings, and historical trends in psychology. | ||||||
| 2) Understanding of and ability to apply essential research methods in psychology, including research design, data analysis, and data interpretation. | ||||||
| 3) Competence to use critical and creative thinking, skeptical inquiry and a scientific approach to solving problems related to behavior and mental processes. | ||||||
| 4) Understanding and ability to apply psychological principles, skills and values in personal, social, and organizational contexts. | ||||||
| 5) Ability to weigh evidence, to tolerate ambiguity, and to reflect other values that underpin psychology as a discipline. | ||||||
| 6) Internalization and dissemination of professional ethical standards. | ||||||
| 7) Demonstration of competence in information technologies, and the ability to use computer and other technologies for purposes related to the pursuit of knowledge in psychology and the broader social sciences. | ||||||
| 8) Skills to communicate the knowledge of psychological science effectively, in a variety of formats, in both Turkish and in English (in English, at least CEFR B2 level). | ||||||
| 9) Recognition, understanding, and respect for the complexity of sociocultural and international diversity. | ||||||
| 10) Recognition for the need for, and the skills to pursue, lifelong learning, inquiry, and self-improvement. | ||||||
| 11) Ability to formulate critical hypotheses based on psychological theory and literature, and design studies to test those hypotheses. | ||||||
| 12) Ability to acquire knowledge independently, and to plan one’s own learning. | ||||||
| 13) Demonstration of advanced competence in the clarity and composition of written work and presentations. |
Relation to Program Outcomes and Competences
| N None | S Supportive | H Highly Related |
| Program Outcomes and Competences | Level | Assessed by | |
| 1) | Thorough knowledge of the major concepts, theoretical perspectives, empirical findings, and historical trends in psychology. | N | |
| 2) | Understanding of and ability to apply essential research methods in psychology, including research design, data analysis, and data interpretation. | N | |
| 3) | Competence to use critical and creative thinking, skeptical inquiry and a scientific approach to solving problems related to behavior and mental processes. | H | Exam,HW,Participation |
| 4) | Understanding and ability to apply psychological principles, skills and values in personal, social, and organizational contexts. | N | |
| 5) | Ability to weigh evidence, to tolerate ambiguity, and to reflect other values that underpin psychology as a discipline. | N | |
| 6) | Internalization and dissemination of professional ethical standards. | N | |
| 7) | Demonstration of competence in information technologies, and the ability to use computer and other technologies for purposes related to the pursuit of knowledge in psychology and the broader social sciences. | N | |
| 8) | Skills to communicate the knowledge of psychological science effectively, in a variety of formats, in both Turkish and in English (in English, at least CEFR B2 level). | N | |
| 9) | Recognition, understanding, and respect for the complexity of sociocultural and international diversity. | S | Participation |
| 10) | Recognition for the need for, and the skills to pursue, lifelong learning, inquiry, and self-improvement. | S | HW,Participation |
| 11) | Ability to formulate critical hypotheses based on psychological theory and literature, and design studies to test those hypotheses. | N | |
| 12) | Ability to acquire knowledge independently, and to plan one’s own learning. | S | Exam,HW |
| 13) | Demonstration of advanced competence in the clarity and composition of written work and presentations. | H | Exam,HW |
| Prepared by and Date | İLKER BEKMEZCİ , January 2021 |
| Course Coordinator | İLKER BEKMEZCİ |
| Semester | Fall |
| Name of Instructor | Prof. Dr. ADEM KARAHOCA |
Course Contents
| Week | Subject |
| 1) | Introduction and Fundamental Concepts |
| 2) | ER Diagram 1 |
| 3) | ER Diagram 2 |
| 4) | Relational Algebra and Calculus |
| 5) | Relational Model |
| 6) | Normalization of a Relation |
| 7) | SQL Queries – DDL |
| 8) | Implementation of DBMS |
| 9) | Project Presentations - 1 |
| 10) | SQL Queries – DML |
| 11) | SQL Queries – Advanced DML -1 |
| 12) | SQL Queries – Advanced DML -2 |
| 13) | Database Application Development |
| 14) | Stored procedures |
| 15) | Final Exam/Project/Presentation Period |
| 16) | Final Exam/Project/Presentation Period |
| Required/Recommended Readings | Database management systems, by Raghu Ramakrishnan and Johannes Gehrke. 3rd edition, McGraw-Hill. | |||||||||||||||
| Teaching Methods | Lecturing, in-class exercises and 1 term project will be carried out by students | |||||||||||||||
| Homework and Projects | In-class exercises, 1 term project | |||||||||||||||
| Laboratory Work | None | |||||||||||||||
| Computer Use | For Database design, Database querying, and Database Administration | |||||||||||||||
| Other Activities | ||||||||||||||||
| Assessment Methods |
|
|||||||||||||||
| Course Administration |
bekmezcii@mef.edu.tr |
|||||||||||||||
ECTS Student Workload Estimation
| Activity | No/Weeks | Hours | Calculation | ||||
| No/Weeks per Semester | Preparing for the Activity | Spent in the Activity Itself | Completing the Activity Requirements | ||||
| Course Hours | 14 | 1 | 3 | 1 | 70 | ||
| Project | 1 | 15 | 1 | 16 | |||
| Homework Assignments | 2 | 4 | 3 | 14 | |||
| Midterm(s) | 2 | 16 | 3 | 38 | |||
| Total Workload | 138 | ||||||
| Total Workload/25 | 5.5 | ||||||
| ECTS | 6 | ||||||