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 |
Ders Genel Tanıtım Bilgileri
| School/Faculty/Institute | Faculty of Engineering | ||||
| Course Code | COMP 203 | ||||
| Course Title in English | Database Management Systems | ||||
| Course Title in Turkish | Database Management Systems | ||||
| Language of Instruction | EN | ||||
| Type of Course | Exercise,Lecture | ||||
| Level of Course | Introductory | ||||
| Semester | Fall | ||||
| Contact Hours per Week |
|
||||
| Estimated Student Workload | 161 hours per semester | ||||
| Number of Credits | 6 ECTS | ||||
| Grading Mode | Standard Letter Grade | ||||
| Pre-requisites |
COMP 106 - Object-Oriented Programming |
||||
| Expected Prior Knowledge | Object Oriented Programming, Data Structures | ||||
| Co-requisites | None | ||||
| Registration Restrictions | Only Undergraduate Students | ||||
| Overall Educational Objective | The main objective of this course is to present the fundamentals of database technology through studying them from three pillars: the database user, the database designer and the database administrator. 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 in the context of SQL Server DBMS 20XX. | ||||
| Course Description | This course provides a comprehensive introduction to some fundamental aspects of Database Management. The following topics are covered: Database concepts. Relational model, relational algebra, queries. Application development. Database design, normalization, entity-relationship model. Concurrency, transactions | ||||
| Course Description in Turkish | Dersin amacı öğrencilerin bir bilgi sisteminin temelini oluşturan veri tabanının mantıksal ve fiziksel olarak nasıl modellendiğini, nasıl yönetildiğini, ve özellikle verinin bilgiye dönüştürülmesi safhalarında yapacakları müdahaleleri öğrenmeleridir. Ders aracı olarak MS SQL Server 20XX kullanılmaktadır. Öğrencilerin bu veri tabanı yönetim sistemini kullanarak veri tabanı yönetimi konusunda da uzmanlaşması beklenmektedir. |
Course Learning Outcomes and CompetencesUpon successful completion of the course, the learner is expected to be able to:1) Model large amounts of data so that they can be processed effectively. 2) Design and implement software applications that will process large amounts of data. 3) Choose an appropriate model along with the necessary database and software components to be used in a project. 4) Work as a member of a team and presenting it in front of an audience |
| Program Learning Outcomes/Course Learning Outcomes | 1 | 2 | 3 | 4 |
|---|---|---|---|---|
| 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 | MUHİTTİN GÖKMEN , December 2018 |
| Course Coordinator | İLKER BEKMEZCİ |
| Semester | Fall |
| Name of Instructor |
Course Contents
| Week | Subject |
| 1) | Introduction, Properties and Classification of DBMS, Fundamental Concepts |
| 2) | Conceptual database modeling using the Entity-Relationship model |
| 3) | Relational Model, Normalization of a Relation |
| 4) | Functional Dependencies and Normal Forms |
| 5) | Integrity Contraints |
| 6) | Relational Algebra |
| 7) | SQL Queries |
| 8) | Complex queries and Aggregate Functions |
| 9) | Transactions Management |
| 10) | Concurrency – Isolation Levels |
| 11) | Trigger and Stored Procedures |
| 12) | Indexing and Optimization |
| 13) | Student Project Presentations and Demos |
| 14) | Student Project Presentations and Demos |
| 15) | Final Examination Period |
| 16) | Final Examination 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 Projects, 10 Homework | |||||||||||||||
| Laboratory Work | Database design exercises, SQL programming, T- SQL programming | |||||||||||||||
| Computer Use | For Database design, Database querying, and Database Administration | |||||||||||||||
| Other Activities | none | |||||||||||||||
| Assessment Methods |
|
|||||||||||||||
| Course Administration |
none none Instructor’s office and phone number, office hours, email address: Dr. Sultan N. TURHAN Tel : 0 212 227 44 80 / 668 e-mail: sturhan@gsu.edu.tr Office Hours : Friday 13:00 – 15:00 Rules for attendance: Minimum of 70% attendance required. Missing a quiz: Provided that proper documents of excuse are presented, each missed quiz by the student will be given a grade which is equal to the average of all of the other quizzes. No make-up will be given. Missing a midterm: Provided that proper documents of excuse are presented, each missed midterm by the student will be given the grade of the final exam. No make-up will be given. Missing a final: Faculty regulations. A reminder of proper classroom behavior, code of student conduct: YÖK Regulations Statement on plagiarism: YÖK Regulations http://3fcampus.mef.edu.tr/uploads/cms/webadmin.mef.edu.tr/4833_2.pdf |
|||||||||||||||
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 | ||
| Presentations / Seminar | 8 | 5 | 3 | 2 | 80 | ||
| Midterm(s) | 1 | 3 | 1 | 4 | |||
| Final Examination | 1 | 5 | 2 | 7 | |||
| Total Workload | 161 | ||||||
| Total Workload/25 | 6.4 | ||||||
| ECTS | 6 | ||||||