Psychology | |||||
Bachelor | Length of the Programme: 4 | Number of Credits: 240 | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF: Level 6 |
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. |
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 |
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 |
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 |